QuickBooks-V3-PHP-SDK
QuickBooks-V3-PHP-SDK copied to clipboard
Unable to query `RecurringTransaction`
I'm on version: ^6.0
and I'm trying to get all RecurringTransaction
:
$dataService = (new QuickbooksClient())
->getDataService();
$results = $dataService->Query('SELECT * FROM RecurringTransaction');
Then an exception is thrown:
Message: Exception appears in converting Response to XML.
File: v3-php-sdk/src/DataService/DataService.php
Line: 1035
I'm not getting this exception in other queries.
This is the content of $responseBody
before it throws an exception:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<IntuitResponse xmlns="http://schema.intuit.com/finance/v3" time="2022-09-14T01:17:47.511-07:00">
<QueryResponse startPosition="1" maxResults="1">
<RecurringTransaction>
<Invoice domain="QBO" sparse="false">
<Id>182</Id>
<SyncToken>1</SyncToken>
<MetaData>
<CreateTime>2022-09-14T00:46:50-07:00</CreateTime>
<LastModifiedByRef>9130354723602346</LastModifiedByRef>
<LastUpdatedTime>2022-09-14T00:49:01-07:00</LastUpdatedTime>
</MetaData>
<CustomField>
<DefinitionId>1</DefinitionId>
<Name>Crew #</Name>
<Type>StringType</Type>
</CustomField>
<CurrencyRef name="United States Dollar">USD</CurrencyRef>
<Line>
<Id>1</Id>
<LineNum>1</LineNum>
<Description>Doloribus.</Description>
<Amount>4.00</Amount>
<DetailType>SalesItemLineDetail</DetailType>
<SalesItemLineDetail>
<ItemRef name="Services">1</ItemRef>
<Qty>2</Qty>
<ItemAccountRef name="Services">1</ItemAccountRef>
<TaxCodeRef>NON</TaxCodeRef>
<TaxClassificationRef>EUC-99990201-V1-00020000</TaxClassificationRef>
</SalesItemLineDetail>
</Line>
<Line>
<Id>2</Id>
<LineNum>2</LineNum>
<Description>Accusantium quasi.</Description>
<Amount>6.00</Amount>
<DetailType>SalesItemLineDetail</DetailType>
<SalesItemLineDetail>
<ItemRef name="Services">1</ItemRef>
<Qty>2</Qty>
<ItemAccountRef name="Services">1</ItemAccountRef>
<TaxCodeRef>NON</TaxCodeRef>
<TaxClassificationRef>EUC-99990201-V1-00020000</TaxClassificationRef>
</SalesItemLineDetail>
</Line>
<Line>
<Amount>10.00</Amount>
<DetailType>SubTotalLineDetail</DetailType>
<SubTotalLineDetail/>
</Line>
<TxnTaxDetail>
<TxnTaxCodeRef>5</TxnTaxCodeRef>
<TotalTax>0</TotalTax>
<TaxLine>
<Amount>0</Amount>
<DetailType>TaxLineDetail</DetailType>
<TaxLineDetail>
<TaxRateRef>9</TaxRateRef>
<PercentBased>true</PercentBased>
<TaxPercent>0.5</TaxPercent>
<NetAmountTaxable>0</NetAmountTaxable>
</TaxLineDetail>
</TaxLine>
<TaxLine>
<Amount>0</Amount>
<DetailType>TaxLineDetail</DetailType>
<TaxLineDetail>
<TaxRateRef>6</TaxRateRef>
<PercentBased>true</PercentBased>
<TaxPercent>6.25</TaxPercent>
<NetAmountTaxable>0</NetAmountTaxable>
</TaxLineDetail>
</TaxLine>
<TaxLine>
<Amount>0</Amount>
<DetailType>TaxLineDetail</DetailType>
<TaxLineDetail>
<TaxRateRef>8</TaxRateRef>
<PercentBased>true</PercentBased>
<TaxPercent>1.5</TaxPercent>
<NetAmountTaxable>0</NetAmountTaxable>
</TaxLineDetail>
</TaxLine>
<TaxLine>
<Amount>0</Amount>
<DetailType>TaxLineDetail</DetailType>
<TaxLineDetail>
<TaxRateRef>7</TaxRateRef>
<PercentBased>true</PercentBased>
<TaxPercent>1</TaxPercent>
<NetAmountTaxable>0</NetAmountTaxable>
</TaxLineDetail>
</TaxLine>
</TxnTaxDetail>
<RecurDataRef>4</RecurDataRef>
<RecurringInfo>
<Name>My company name</Name>
<RecurType>Automated</RecurType>
<Active>true</Active>
<ScheduleInfo>
<IntervalType>Daily</IntervalType>
<NumInterval>1</NumInterval>
<MaxOccurrences>5</MaxOccurrences>
<StartDate>2022-09-14</StartDate>
<NextDate>2022-09-14</NextDate>
</ScheduleInfo>
</RecurringInfo>
<CustomerRef name="My company name">65</CustomerRef>
<CustomerMemo>THIS IS RECURRING</CustomerMemo>
<FreeFormAddress>false</FreeFormAddress>
<ShipFromAddr>
<Id>130</Id>
<Line1>123 Sierra Way</Line1>
<Line2>San Pablo, CA 87999 US</Line2>
</ShipFromAddr>
<TotalAmt>10.00</TotalAmt>
<ApplyTaxAfterDiscount>false</ApplyTaxAfterDiscount>
<PrintStatus>NeedToPrint</PrintStatus>
<EmailStatus>NotSet</EmailStatus>
<BillEmail>
<Address>[email protected]</Address>
</BillEmail>
<Balance>10.00</Balance>
<TaxExemptionRef/>
<AllowIPNPayment>false</AllowIPNPayment>
<AllowOnlinePayment>false</AllowOnlinePayment>
<AllowOnlineCreditCardPayment>false</AllowOnlineCreditCardPayment>
<AllowOnlineACHPayment>false</AllowOnlineACHPayment>
</Invoice>
</RecurringTransaction>
</QueryResponse>
</IntuitResponse>