Report service api fails to generate report what exactly configured and working in report UI

[sbsdw.p...@sbs.com.au]

Hi,

I was trying to execute the report using google dfp api, I am running into issues. Below are the problem I am facing with respect to DFP Client API.

We were able to create report and run the report successfully using the UI. But when the same dimensions, dimension attribute and columns added into API and invoke report services api it fails to run and return the expected report. below is the error message: 

  <ApiExceptionFault xmlns="https://www.google.com/apis/ads/publisher/v201705">
                    <message>[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS']</message>
                    <errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ReportError">
                        <fieldPath>columns</fieldPath>
                        <fieldPathElements>
                            <field>columns</field>
                        </fieldPathElements>
                        <trigger>SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS</trigger>
                        <errorString>ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS</errorString>
                        <reason>COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS</reason>
                    </errors>
                </ApiExceptionFault>

So, I decided to use run saved query option by passing the query id, same issue. I have received the following error "The saved query is not compatible with this API version".

Below are the details for your reference.  Let me know what is causing this issue also is there any documentation or any specific API which can tell us what are all the unsupported columns or dimensions not supported when using API?

Network id : 4117

Query id : 10006161061

Appreciate your inputs.

Thanks,

Venkatesh S

[sbsdw.p...@sbs.com.au]

The request - response message is for your reference:

<?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://www.google.com/apis/ads/publisher/v201705" soapenv:mustUnderstand="0">
            <ns1:networkCode>4117</ns1:networkCode>
            <ns1:applicationName>DFP-EXTRACTION (DfpApi-Java, Dfp-Axis/3.4.0, Common-Java/3.4.0, Axis/1.4, Java/1.8.0_60, jars)</ns1:applicationName>
        </ns1:RequestHeader>
    </soapenv:Header>
    <soapenv:Body>
        <runReportJob xmlns="https://www.google.com/apis/ads/publisher/v201705">
            <reportJob>
                <reportQuery>
                    <dimensions>MONTH_AND_YEAR</dimensions>
                    <dimensions>REQUESTED_AD_SIZES</dimensions>
                    <dimensions>ADVERTISER_NAME</dimensions>
                    <dimensions>LINE_ITEM_TYPE</dimensions>
                    <dimensions>LINE_ITEM_NAME</dimensions>
                    <dimensions>AD_UNIT_ID</dimensions>
                    <dimensions>AD_UNIT_NAME</dimensions>
                    <dimensions>PROPOSAL_NAME</dimensions>
                    <dimensions>PROPOSAL_LINE_ITEM_NAME</dimensions>
                    <dimensions>ORDER_NAME</dimensions>
                    <columns>AD_SERVER_IMPRESSIONS</columns>
                    <columns>AD_SERVER_CPM_AND_CPC_REVENUE</columns>
                    <columns>SELL_THROUGH_FORECASTED_IMPRESSIONS</columns>
                    <columns>SELL_THROUGH_AVAILABLE_IMPRESSIONS</columns>
                    <dimensionAttributes>AD_UNIT_CODE</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_START_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_END_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_STATUS</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_ADVERTISER</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_AGENCIES</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_PRIMARY_SALESPERSON</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_START_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_END_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_RESERVATION_STATUS</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_LISTING_RATE_NET</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_RATE_TYPE</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_SIZE</dimensionAttributes>
                    <dimensionAttributes>ORDER_START_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>ORDER_END_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>ORDER_LIFETIME_IMPRESSIONS</dimensionAttributes>
                    <startDate>
                        <year>2017</year>
                        <month>7</month>
                        <day>7</day>
                    </startDate>
                    <endDate>
                        <year>2017</year>
                        <month>7</month>
                        <day>8</day>
                    </endDate>
                    <dateRangeType>CUSTOM_DATE</dateRangeType>
                </reportQuery>
            </reportJob>
        </runReportJob>
    </soapenv:Body>
</soapenv:Envelope>

[07 Jul 2017 11:55:07,056-soapXmlLogger:WARN:main] SOAP Response:
<?xml version="1.0" encoding="UTF-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Header>
        <ResponseHeader xmlns="https://www.google.com/apis/ads/publisher/v201705">
            <requestId>c160412985eaa552abbfacebacd9d7e8</requestId>
            <responseTime>128</responseTime>
        </ResponseHeader>
    </soap:Header>
    <soap:Body>
        <soap:Fault>
            <faultcode>soap:Server</faultcode>
            <faultstring>[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS']</faultstring>
            <detail>

                <ApiExceptionFault xmlns="https://www.google.com/apis/ads/publisher/v201705">
                    <message>[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS']</message>
                    <errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ReportError">
                        <fieldPath>columns</fieldPath>
                        <fieldPathElements>
                            <field>columns</field>
                        </fieldPathElements>
                        <trigger>SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS</trigger>
                        <errorString>ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS</errorString>
                        <reason>COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS</reason>
                    </errors>
                </ApiExceptionFault>

            </detail>
        </soap:Fault>
    </soap:Body>
</soap:Envelope>

Exception in thread "main" AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server
 faultSubcode:
 faultString: [ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS']
 faultActor:
 faultNode:
 faultDetail:
 {https://www.google.com/apis/ads/publisher/v201705}ApiExceptionFault:<message>[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS']</message><errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ReportError"><fieldPath>columns</fieldPath><fieldPathElements><field>columns</field></fieldPathElements><trigger>SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS</trigger><errorString>ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS</errorString><reason>COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS</reason></errors>

ApiException{errors=[ReportError{errorString=ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS, fieldPath=columns, fieldPathElements=[FieldPathElement{field=columns}], reason=COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS, trigger=SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS}]}
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
 at java.lang.Class.newInstance(Class.java:442)
 at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:104)
 at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:90)
 at com.google.api.ads.dfp.axis.v201705.ApiException.getDeserializer(ApiException.java:162)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:497)
 at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized(BaseDeserializerFactory.java:154)
 at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs(BaseDeserializerFactory.java:84)
 at org.apache.axis.encoding.DeserializationContext.getDeserializer(DeserializationContext.java:464)
 at org.apache.axis.encoding.DeserializationContext.getDeserializerForType(DeserializationContext.java:547)
 at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild(SOAPFaultDetailsBuilder.java:157)
 at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
 at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:509)
 at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:379)
 at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2786)
 at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
 at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:117)
 at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
 at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
 at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
 at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
 at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
 at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:649)
 at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:333)
 at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
 at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
 at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
 at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
 at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
 at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
 at org.apache.axis.client.Call.invoke(Call.java:2767)
 at org.apache.axis.client.Call.invoke(Call.java:2443)
 at org.apache.axis.client.Call.invoke(Call.java:2366)
 at org.apache.axis.client.Call.invoke(Call.java:1812)
 at com.google.api.ads.dfp.axis.v201705.ReportServiceSoapBindingStub.runReportJob(ReportServiceSoapBindingStub.java:879)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:497)
 at com.google.api.ads.common.lib.soap.SoapClientHandler.invoke(SoapClientHandler.java:109)
 at com.google.api.ads.common.lib.soap.axis.AxisHandler.invokeSoapCall(AxisHandler.java:246)
 at com.google.api.ads.common.lib.soap.SoapServiceClient.callSoapClient(SoapServiceClient.java:62)
 at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:92)
 at com.sun.proxy.$Proxy17.runReportJob(Unknown Source)
 at dfp.axis.v201705.reportservice.AsyncDownloadReport.runExample(AsyncDownloadReport.java:103)
 at dfp.axis.v201705.reportservice.AsyncDownloadReport.main(AsyncDownloadReport.java:166)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:497)
 at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)

[Vincent Racaza (DFP API Team)]

Hi Venkatesh,

Could you confirm if you selected a Future-sell through report type in your UI report? When I selected this type of report in your network (4117), I could not select some columns (Ad server impressions, Ad server CPM and CPC revenue) in the UI report (please see attached screenshot). If I also select the Historical type of report, I could not select the Sell through columns (Forecasted impressions, Available impressions).

That said, it is weird that you were able to generate the UI report with these parameters on your end. Could you provide a whole UI report screenshot on this so I could check? Also, kindly provide the email address that you used in generating both the UI and API reports.

Thanks,

Vincent Racaza, DFP API Team

[SBSDW.P...@sbs.com.au]

Hi Vincent,

Thanks for your quick response.

As for as I understand, yes we are able to select future-sell-through report type in UI report. In the UI report, we haven't selected Ad server impressions, Ad server CPM and CPC revenue.

The problem I could see is in the UI report for future-sell-through report, whatever dimensions, dimension attributes (you can refer the soap request in the post below)  I am allowed to add and run a report using the given API's. But if I add Columns like sell_through_available_impression, sell_through_future_impression etc (exactly what is configured in UI report)  the API report service fails.

As you rightly mentioned, its weired for me that UI report executes fine, but the same configuration parameters when I use through API it fails.

Having said that, If I add the above said dimensions, dimension attribute and the cloumns like Ad server impressions, Ad server CPM and CPC revenue in report service API and execute it, it generates the reports.

Hope I made my problem statement clear 😊

Let me know if you need any other information in this regard.

Thanks,
Venkatesh S

[Vincent Racaza (DFP API Team)]

Hi Venkatesh,

Thanks for the clarification.

Since you were not able to select the "Ad server impressions" and "Ad server CPM and CPC revenue" in your future sell through report in the UI, then you also could not add these columns in the API report. It will generate the same error you received if you'll try to add these columns with the future sell through columns in the API.

That said, if you want a future sell through report in the API, then you need to delete the AD_SERVER_IMPRESSIONS and AD_SERVER_CPM_AND_CPC_REVENUE columns in your report. On the other hand, if you really want these columns in your report, then you need to delete the future sell through columns (SELL_THROUGH_FORECASTED_IMPRESSIONS, SELL_THROUGH_AVAILABLE_IMPRESSIONS) since the combination of these columns are not possible in both UI and API.

[SBSDW.P...@sbs.com.au]

Hi Vincent,

Thanks for your response.

I have attached the screen grab of the report configured and running through UI report.

I am trying to perform the same through API it fails.

If you can validate the metrics (columns I presume in API) configured in the UI . I am trying to add them through API it fails to generate report.

Appreciate your inputs to fix this issue.

Thanks,

Venkatesh S

[SBSDW.P...@sbs.com.au]

see the attachment.

[Vincent Racaza (DFP API Team)]

Hi Venkatesh,

Thanks for providing the screenshot.

Based on your screenshot, you can only select the future sell through columns (Forecasted impressions, Available impressions, Reserved impressions and Sell-through rate) in the UI report, that's why, your API report with AD_SERVER_IMPRESSIONS and AD_SERVER_CPM_AND_CPC_REVENUE columns generated an error.

These will be the equivalent API columns that you need to include in the API based on your UI report columns : SELL_THROUGH_FORECASTED_IMPRESSIONS, SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_RESERVED_IMPRESSIONS and SELL_THROUGH_SELL_THROUGH_RATE.

Please use these columns instead and let me know if the issue persists.

[SBSDW.P...@sbs.com.au]

Hi Vincent,

As you mentioned I added those columns, but it fails to generate report through API. See the request/response and the error message for your reference below:

"C:\Program Files\Java\jdk1.8.0_60\bin\java" -Didea.launcher.port=7533 "-Didea.launcher.bin.path=D:\Training\Scala\JetBrains\IntelliJ IDEA Community Edition 2016.2.1\bin" -Dfile.encoding=UTF-8 -classpath "D:\SBS\DW\dfp_axis\bin;C:\Program Files\Java\jdk1.8.0_60\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_60\jre\lib\rt.jar;D:\SBS\DW\dfp_axis\lib\ads-lib-3.4.0.jar;D:\SBS\DW\dfp_axis\lib\ads-lib-axis-3.4.0.jar;D:\SBS\DW\dfp_axis\lib\aopalliance-1.0.jar;D:\SBS\DW\dfp_axis\lib\axis-1.4.jar;D:\SBS\DW\dfp_axis\lib\commons-beanutils-1.9.2.jar;D:\SBS\DW\dfp_axis\lib\commons-codec-1.3.jar;D:\SBS\DW\dfp_axis\lib\commons-collections-3.2.2.jar;D:\SBS\DW\dfp_axis\lib\commons-configuration-1.10.jar;D:\SBS\DW\dfp_axis\lib\commons-discovery-0.4.jar;D:\SBS\DW\dfp_axis\lib\commons-lang-2.6.jar;D:\SBS\DW\dfp_axis\lib\commons-logging-1.1.1.jar;D:\SBS\DW\dfp_axis\lib\dfp-axis-3.4.0.jar;D:\SBS\DW\dfp_axis\lib\google-api-client-1.22.0.jar;D:\SBS\DW\dfp_axis\lib\google-api-client-gson-1.22.0.jar;D:\SBS\DW\dfp_axis\lib\google-http-client-1.22.0.jar;D:\SBS\DW\dfp_axis\lib\google-http-client-gson-1.22.0.jar;D:\SBS\DW\dfp_axis\lib\google-http-client-jackson2-1.22.0.jar;D:\SBS\DW\dfp_axis\lib\google-oauth-client-1.22.0.jar;D:\SBS\DW\dfp_axis\lib\gson-2.1.jar;D:\SBS\DW\dfp_axis\lib\guava-20.0.jar;D:\SBS\DW\dfp_axis\lib\guice-4.0.jar;D:\SBS\DW\dfp_axis\lib\guice-assistedinject-4.0.jar;D:\SBS\DW\dfp_axis\lib\guice-multibindings-4.0.jar;D:\SBS\DW\dfp_axis\lib\httpclient-4.0.1.jar;D:\SBS\DW\dfp_axis\lib\httpcore-4.0.1.jar;D:\SBS\DW\dfp_axis\lib\jackson-core-2.1.3.jar;D:\SBS\DW\dfp_axis\lib\javax.inject-1.jar;D:\SBS\DW\dfp_axis\lib\jaxrpc-api-1.1.jar;D:\SBS\DW\dfp_axis\lib\joda-time-2.8.2.jar;D:\SBS\DW\dfp_axis\lib\jsr305-1.3.9.jar;D:\SBS\DW\dfp_axis\lib\log4j-1.2.16.jar;D:\SBS\DW\dfp_axis\lib\opencsv-1.8.jar;D:\SBS\DW\dfp_axis\lib\slf4j-api-1.7.7.jar;D:\SBS\DW\dfp_axis\lib\slf4j-log4j12-1.7.7.jar;D:\SBS\DW\dfp_axis\lib\wsdl4j-1.6.2.jar;D:\Training\Scala\JetBrains\IntelliJ IDEA Community Edition 2016.2.1\lib\idea_rt.jar" com.intellij.rt.execution.application.AppMain dfp.axis.v201705.reportservice.AsyncDownloadReport

[10 Jul 2017 22:27:22,984-requestInfoLogger:INFO:main] Request made: Service: "ReportServiceInterfacePort" Method: "runReportJob" URL: "https://ads.google.com/apis/ads/publisher/v201705/ReportService" Request ID: "15bab99c9b2bd4c1ecbb97f380b1d6bf"
[10 Jul 2017 22:27:23,109-soapXmlLogger:WARN:main] SOAP 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://www.google.com/apis/ads/publisher/v201705" soapenv:mustUnderstand="0">
            <ns1:networkCode>4117</ns1:networkCode>

Exception in thread "main"             <ns1:applicationName>DFP-EXTRACTION (DfpApi-Java, Dfp-Axis/3.4.0, Common-Java/3.4.0, Axis/1.4, Java/1.8.0_60, jars)</ns1:applicationName>

        </ns1:RequestHeader>
    </soapenv:Header>
    <soapenv:Body>
        <runReportJob xmlns="https://www.google.com/apis/ads/publisher/v201705">
            <reportJob>
                <reportQuery>

                    <columns>SELL_THROUGH_FORECASTED_IMPRESSIONS</columns>
                    <columns>SELL_THROUGH_AVAILABLE_IMPRESSIONS</columns>

                    <columns>SELL_THROUGH_RESERVED_IMPRESSIONS</columns>
                    <columns>SELL_THROUGH_SELL_THROUGH_RATE</columns>

                    <startDate>
                        <year>2017</year>
                        <month>7</month>

                        <day>10</day>

                    </startDate>
                    <endDate>
                        <year>2017</year>
                        <month>7</month>

                        <day>11</day>

                    </endDate>
                    <dateRangeType>CUSTOM_DATE</dateRangeType>
                </reportQuery>
            </reportJob>
        </runReportJob>
    </soapenv:Body>
</soapenv:Envelope>

[10 Jul 2017 22:27:23,109-soapXmlLogger:WARN:main] SOAP Response:

<?xml version="1.0" encoding="UTF-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Header>
        <ResponseHeader xmlns="https://www.google.com/apis/ads/publisher/v201705">

            <requestId>15bab99c9b2bd4c1ecbb97f380b1d6bf</requestId>
            <responseTime>98</responseTime>

        </ResponseHeader>
    </soap:Header>
    <soap:Body>
        <soap:Fault>
            <faultcode>soap:Server</faultcode>

            <faultstring>[ReportError.NOT_NULL @ dimensions]</faultstring>

            <detail>
                <ApiExceptionFault xmlns="https://www.google.com/apis/ads/publisher/v201705">

                    <message>[ReportError.NOT_NULL @ dimensions]</message>

                    <errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ReportError">

                        <fieldPath>dimensions</fieldPath>
                        <fieldPathElements>
                            <field>dimensions</field>
                        </fieldPathElements>
                        <trigger/>
                        <errorString>ReportError.NOT_NULL</errorString>
                        <reason>NOT_NULL</reason>

                    </errors>
                </ApiExceptionFault>
            </detail>
        </soap:Fault>
    </soap:Body>
</soap:Envelope>

AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server
 faultSubcode:

 faultString: [ReportError.NOT_NULL @ dimensions]
 faultActor:
 faultNode:
 faultDetail:
 {https://www.google.com/apis/ads/publisher/v201705}ApiExceptionFault:<message>[ReportError.NOT_NULL @ dimensions]</message><errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ReportError"><fieldPath>dimensions</fieldPath><fieldPathElements><field>dimensions</field></fieldPathElements><trigger/><errorString>ReportError.NOT_NULL</errorString><reason>NOT_NULL</reason></errors>

ApiException{errors=[ReportError{errorString=ReportError.NOT_NULL, fieldPath=dimensions, fieldPathElements=[FieldPathElement{field=dimensions}], reason=NOT_NULL, trigger=}]}

 at dfp.axis.v201705.reportservice.AsyncDownloadReport.runExample(AsyncDownloadReport.java:109)
 at dfp.axis.v201705.reportservice.AsyncDownloadReport.main(AsyncDownloadReport.java:172)

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:497)
 at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)

Process finished with exit code 1

Thanks,

Venkatesh S

[SBSDW.P...@sbs.com.au]

Hi Vincent,

See the error after adding the dimensions, dimension attributes:

[10 Jul 2017 22:33:18,129-requestInfoLogger:INFO:main] Request made: Service: "ReportServiceInterfacePort" Method: "runReportJob" URL: "https://ads.google.com/apis/ads/publisher/v201705/ReportService" Request ID: "1a67d6a0288ad8de69534a71d2b509f9"
[10 Jul 2017 22:33:18,160-soapXmlLogger:WARN:main] SOAP 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://www.google.com/apis/ads/publisher/v201705" soapenv:mustUnderstand="0">
            <ns1:networkCode>4117</ns1:networkCode>
            <ns1:applicationName>DFP-EXTRACTION (DfpApi-Java, Dfp-Axis/3.4.0, Common-Java/3.4.0, Axis/1.4, Java/1.8.0_60, jars)</ns1:applicationName>
        </ns1:RequestHeader>
    </soapenv:Header>
    <soapenv:Body>
        <runReportJob xmlns="https://www.google.com/apis/ads/publisher/v201705">
            <reportJob>
                <reportQuery>

                    <dimensions>DATE</dimensions>

                    <dimensions>REQUESTED_AD_SIZES</dimensions>
                    <dimensions>ADVERTISER_NAME</dimensions>
                    <dimensions>LINE_ITEM_TYPE</dimensions>
                    <dimensions>LINE_ITEM_NAME</dimensions>
                    <dimensions>AD_UNIT_ID</dimensions>
                    <dimensions>AD_UNIT_NAME</dimensions>
                    <dimensions>PROPOSAL_NAME</dimensions>
                    <dimensions>PROPOSAL_LINE_ITEM_NAME</dimensions>
                    <dimensions>ORDER_NAME</dimensions>

                    <columns>SELL_THROUGH_FORECASTED_IMPRESSIONS</columns>
                    <columns>SELL_THROUGH_AVAILABLE_IMPRESSIONS</columns>

                    <columns>SELL_THROUGH_RESERVED_IMPRESSIONS</columns>
                    <columns>SELL_THROUGH_SELL_THROUGH_RATE</columns>

                    <dimensionAttributes>AD_UNIT_CODE</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_START_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_END_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_STATUS</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_ADVERTISER</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_AGENCIES</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_PRIMARY_SALESPERSON</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_START_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_END_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_RESERVATION_STATUS</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_LISTING_RATE_NET</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_RATE_TYPE</dimensionAttributes>
                    <dimensionAttributes>PROPOSAL_LINE_ITEM_SIZE</dimensionAttributes>
                    <dimensionAttributes>ORDER_START_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>ORDER_END_DATE_TIME</dimensionAttributes>
                    <dimensionAttributes>ORDER_LIFETIME_IMPRESSIONS</dimensionAttributes>
                    <startDate>
                        <year>2017</year>
                        <month>7</month>

                        <day>10</day>

                    </startDate>
                    <endDate>
                        <year>2017</year>
                        <month>7</month>

                        <day>12</day>

                    </endDate>
                    <dateRangeType>CUSTOM_DATE</dateRangeType>
                </reportQuery>
            </reportJob>
        </runReportJob>
    </soapenv:Body>
</soapenv:Envelope>

[10 Jul 2017 22:33:18,160-soapXmlLogger:WARN:main] SOAP Response:

<?xml version="1.0" encoding="UTF-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Header>
        <ResponseHeader xmlns="https://www.google.com/apis/ads/publisher/v201705">

            <requestId>1a67d6a0288ad8de69534a71d2b509f9</requestId>
            <responseTime>113</responseTime>

        </ResponseHeader>
    </soap:Header>
    <soap:Body>
        <soap:Fault>
            <faultcode>soap:Server</faultcode>

            <faultstring>[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS, SELL_THROUGH_RESERVED_IMPRESSIONS, SELL_THROUGH_SELL_THROUGH_RATE']</faultstring>

            <detail>
                <ApiExceptionFault xmlns="https://www.google.com/apis/ads/publisher/v201705">

                    <message>[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS, SELL_THROUGH_RESERVED_IMPRESSIONS, SELL_THROUGH_SELL_THROUGH_RATE']</message>

                    <errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ReportError">
                        <fieldPath>columns</fieldPath>
                        <fieldPathElements>
                            <field>columns</field>
                        </fieldPathElements>

                        <trigger>SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS, SELL_THROUGH_RESERVED_IMPRESSIONS, SELL_THROUGH_SELL_THROUGH_RATE</trigger>

                        <errorString>ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS</errorString>
                        <reason>COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS</reason>
                    </errors>
                </ApiExceptionFault>
            </detail>
        </soap:Fault>
    </soap:Body>
</soap:Envelope>

Exception in thread "main" AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server
 faultSubcode:

 faultString: [ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS, SELL_THROUGH_RESERVED_IMPRESSIONS, SELL_THROUGH_SELL_THROUGH_RATE']
 faultActor:
 faultNode:
 faultDetail:
 {https://www.google.com/apis/ads/publisher/v201705}ApiExceptionFault:<message>[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS, SELL_THROUGH_RESERVED_IMPRESSIONS, SELL_THROUGH_SELL_THROUGH_RATE']</message><errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ReportError"><fieldPath>columns</fieldPath><fieldPathElements><field>columns</field></fieldPathElements><trigger>SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS, SELL_THROUGH_RESERVED_IMPRESSIONS, SELL_THROUGH_SELL_THROUGH_RATE</trigger><errorString>ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS</errorString><reason>COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS</reason></errors>

ApiException{errors=[ReportError{errorString=ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS, fieldPath=columns, fieldPathElements=[FieldPathElement{field=columns}], reason=COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS, trigger=SELL_THROUGH_AVAILABLE_IMPRESSIONS, SELL_THROUGH_FORECASTED_IMPRESSIONS, SELL_THROUGH_RESERVED_IMPRESSIONS, SELL_THROUGH_SELL_THROUGH_RATE}]}

 at dfp.axis.v201705.reportservice.AsyncDownloadReport.runExample(AsyncDownloadReport.java:108)
 at dfp.axis.v201705.reportservice.AsyncDownloadReport.main(AsyncDownloadReport.java:171)

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:497)
 at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)

Thanks,

Venkatesh S

[Vincent Racaza (DFP API Team)]

Hi Venkatesh,

I was able to replicate this issue in your network (4117). The issue was caused by the REQUESTED_AD_SIZES dimension. The equivalent of "Ad request sizes" in your UI report is the AD_REQUEST_AD_UNIT_SIZES dimension. Please use this dimension instead.

Apologies as I was not able to correct this dimension in my previous reply as I was focused on the API columns on which you already corrected in your latest SOAP request.

Please see below for the complete report parameters which runs successfully in your network:

<reportQuery>
    <dimensions>DATE</dimensions>
    <dimensions>AD_REQUEST_AD_UNIT_SIZES</dimensions>

Let me know if you encounter any issues after doing the suggestion.

[SBSDW.P...@sbs.com.au]

Hi Vincent,

Thank you.. I will try and revert back to you.

When you say AD_REQUEST_AD_UNIT_SIZES is the right dimension? How can we figure out allowed dimensions, attributes and columns with respect to API in our case?

Could you please give your inputs as Is there a way to figure out this matches or do we need to trial and error or do we need to reach out to the forum every time we run into issue?

Much Appreciated.

Thanks,

Venkatesh S

[SBSDW.P...@sbs.com.au]

Hi Vincent,

In addition to the question I have asked. I tried to execute the same query through API it throws the following error. Could you please help us on this as well.

[11 Jul 2017 16:45:40,776-requestInfoLogger:INFO:main] Request made: Service: "ReportServiceInterfacePort" Method: "getSavedQueriesByStatement" URL: "https://ads.google.com/apis/ads/publisher/v201705/ReportService" Request ID: "4b703bdec392a7f148587146b6e535dd"
Exception in thread "main" java.lang.IllegalStateException: The saved query is not compatible with this API version.
 at dfp.axis.v201705.reportservice.RunSavedQuery.runExample(RunSavedQuery.java:66)
 at dfp.axis.v201705.reportservice.RunSavedQuery.main(RunSavedQuery.java:117)

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:497)
 at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)

Thanks,

Venkatesh S

On Friday, July 7, 2017 at 12:01:33 PM UTC+10, sbsdw.p...@sbs.com.au wrote:

[Vincent Racaza (DFP API Team)]

Hi Venkatesh,

For your first concern, we can figure out the dimensions/columns combination that you need to use in the API by creating a report first in the UI. Through the UI report, you'll know if the dimensions and columns are match with each other. If a report is possible in the UI, then it would also be possible in the API if supported.

In identifying what is the equivalent API dimension for "Ad request sizes", you can read through the description of the API dimension, or the easier way, you can use the saved query functionality. You can create a simple report with few dimensions/columns just to identify what is the correct dimensions/columns to use.

For your second concern which is the "Not compatible with this API version" error, it means that there are some UI report dimensions/dimension attributes/columns which are not compatible in the API. In your case, there are three dimension attributes (Proposal status, Product type, Proposal line item status) which are not compatible in the API. These dimension attributes could not be automatically translated to its API equivalent or do not really have their API equivalents. For "Product type" and "Proposal line item status", they do not have their API equivalents. For "Proposal status", it could not be automatically translated to its API equivalent.

That said, if you want to include the "Proposal status" dimension attribute, then you need to manually create an API report. Otherwise, if it is okay with you to not include these three dimension attributes in your report, then do not select them in your UI report. 

[SBSDW.P...@sbs.com.au]

Hi Vincent,

Thanks for your prompt and detailed responses. Appreciate it.

Yeah. I verified 'Ad request sizes' in the API documentation I could find the following from the documentation, so it concludes the usage of AD_REQUEST_AD_UNIT_SIZES for sell-through report. I am able to execute the API without any issues.

AD_REQUEST_SIZE Size of the creative requested for an ad.

 

AD_REQUEST_AD_UNIT_SIZES Breaks down reporting data by the ad unit sizes specified in ad requests.
Formatted as comma separated values, e.g. "300x250,300x250v,300x60".

This dimension is supported only for sell-through columns.

As part of calling saved query api, your response do help. After removing the Proposal status, Product type, Proposal line item status dimension attributes from UI query.

Considering the above scenarios, We need to have 2 different strategy one through UI another through API.

Once again thanks for helping us out to resolve this issue.

Much Appreciated.

Thanks,

Venkatesh S