BudgetOrderService filter by PoNumber and date range is not working

[Nicolae Rosca]

Hi,

I am using AdWords API and found a problem with filtering BudgetOrders by PoNumber and DateRange. This is the request: 

<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <soapenv:Header>

        <ns1:RequestHeader xmlns:ns1="https://adwords.google.com/api/adwords/billing/v201506" soapenv:mustUnderstand="0">

            <ns2:clientCustomerId xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201506">... </ns2:clientCustomerId>

            <ns3:developerToken xmlns:ns3="https://adwords.google.com/api/adwords/cm/v201506">... </ns3:developerToken>

            <ns4:userAgent xmlns:ns4="https://adwords.google.com/api/adwords/cm/v201506">BudgetAPI+TestMCC (AwApi-Java, AdWords-Axis/2.4.0, Common-Java/2.4.0, Axis/1.4, Java/1.7.0_79, maven)</ns4:userAgent>

            <ns5:validateOnly xmlns:ns5="https://adwords.google.com/api/adwords/cm/v201506">false</ns5:validateOnly>

            <ns6:partialFailure xmlns:ns6="https://adwords.google.com/api/adwords/cm/v201506">true</ns6:partialFailure>

        </ns1:RequestHeader>

    </soapenv:Header>

    <soapenv:Body>

        <get xmlns="https://adwords.google.com/api/adwords/billing/v201506">

            <serviceSelector>

                <ns7:fields xmlns:ns7="https://adwords.google.com/api/adwords/cm/v201506">BillingAccountId</ns7:fields>

                <ns8:fields xmlns:ns8="https://adwords.google.com/api/adwords/cm/v201506">BillingAccountName</ns8:fields>

                <ns9:fields xmlns:ns9="https://adwords.google.com/api/adwords/cm/v201506">BudgetOrderName</ns9:fields>

                <ns10:fields xmlns:ns10="https://adwords.google.com/api/adwords/cm/v201506">EndDateTime</ns10:fields>

                <ns11:fields xmlns:ns11="https://adwords.google.com/api/adwords/cm/v201506">Id</ns11:fields>

                <ns12:fields xmlns:ns12="https://adwords.google.com/api/adwords/cm/v201506">LastRequest</ns12:fields>

                <ns13:fields xmlns:ns13="https://adwords.google.com/api/adwords/cm/v201506">PoNumber</ns13:fields>

                <ns14:fields xmlns:ns14="https://adwords.google.com/api/adwords/cm/v201506">PrimaryBillingId</ns14:fields>

                <ns15:fields xmlns:ns15="https://adwords.google.com/api/adwords/cm/v201506">StartDateTime</ns15:fields>

                <ns16:predicates xmlns:ns16="https://adwords.google.com/api/adwords/cm/v201506">

                    <ns16:field>PoNumber</ns16:field>

                    <ns16:operator>EQUALS</ns16:operator>

                    <ns16:values>33</ns16:values>

                </ns16:predicates>

                <ns17:dateRange xmlns:ns17="https://adwords.google.com/api/adwords/cm/v201506">

                    <ns17:min>20151026</ns17:min>

                    <ns17:max>20151026</ns17:max>

                </ns17:dateRange>

                <ns17:paging xmlns:ns17="https://adwords.google.com/api/adwords/cm/v201506">

                    <ns17:numberResults>100</ns17:numberResults>

                </ns17:paging>

            </serviceSelector>

        </get>

    </soapenv:Body>

</soapenv:Envelope>

I receive 3 entries, 2 with empty field and one with PoNumber = 31. Also you observe that date range is wrong and I still receive results so interval does not quite matter. 

I have tried also separately and I have the same results. 

Regards,

Nicolae 

[Anthony Madrigal]

Hi Nicolae,

You are correct. The date range should not matter when filtering these results since the important fields in BudgetOrders are the startDateTime and endDateTime. The predicate with PoNumber 33 should not give you results since the values for PoNumber should be between 0 and 30. Could you send me your SOAP response (through reply privately to author) so I can take a look at why you are getting poNumber = 31?

Regards,

Anthony

AdWords API Team