QuickBooks-V3-PHP-SDK icon indicating copy to clipboard operation
QuickBooks-V3-PHP-SDK copied to clipboard

Unable to query `RecurringTransaction`

Open baaskoen opened this issue 1 year ago • 4 comments

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.

baaskoen avatar Sep 14 '22 08:09 baaskoen

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>

baaskoen avatar Sep 14 '22 08:09 baaskoen