Sample SOAP request XML for getCompaniesByStatement operation

[gopavaram...@gmail.com]

Hi,

Could anyone help me to get the sample example SOAP request for getCompaniesByStatement operation ASAP?

Thanks,

Kiran G

[Vincent Tsao (DFP API Team)]

Hi Kiran:

We strongly recommend you use one of our client libraries to make it easier to access the API instead of generating the SOAP manually:

https://developers.google.com/doubleclick-publishers/docs/clients

If you do need to generate the raw SOAP yourself, please see documentation here:

https://developers.google.com/doubleclick-publishers/docs/soap_xml

You can also use one of the client libraries to make a call and then examine the SOAP (all of them offer SOAP logging). For instance, the Java client library has an example here:

https://code.google.com/p/google-api-ads-java/source/browse/examples/dfp_axis/src/main/java/dfp/axis/v201306/companyservice/GetAdvertisers.java

Thanks,

Vincent Tsao, DFP API Team

[gopavaram...@gmail.com]

Hi Vincent,

Thanks for your response.

I've already tried with the raw SOAP request as shown below and able to get the response.

<soapenv:Body>

      <v20:getCompaniesByStatement>

         <v20:filterStatement>

                  <v20:query>WHERE id = 'XXXXXXXX'</v20:query>

         </v20:filterStatement>

      </v20:getCompaniesByStatement>

   </soapenv:Body>

But I need the query to be modified in the form of key value pair as shown below format of request body. 

<soapenv:Body>

      <v20:getCompaniesByStatement>

         <v20:filterStatement>

            <v20:query>?????</v20:query>

            <v20:values>

               <v20:key>?????</v20:key>

               <v20:value>

                  <v20:Value.Type>?????</v20:Value.Type>

               </v20:value>

            </v20:values>

         </v20:filterStatement>

      </v20:getCompaniesByStatement>

   </soapenv:Body>

Appreciate your help to fill the ???? with proper syntax in above request body. Please let me know if you need more details.

Thanks,

Kiran G

[Vincent Tsao (DFP API Team)]

Hi Kiran:

Here's an example using bind variables:

        <getCompaniesByStatement xmlns="https://www.google.com/apis/ads/publisher/v201306">
            <filterStatement>
                <query>WHERE id = :id ORDER BY id ASC LIMIT 1000</query>
                <values>
                    <key>id</key>
                    <value xmlns:ns2="https://www.google.com/apis/ads/publisher/v201306" xsi:type="ns2:NumberValue">
                        <ns2:value>12345678</ns2:value>
                    </value>
                </values>
            </filterStatement>
        </getCompaniesByStatement>

Once again, I strongly recommend using one of our client libraries instead of generating the SOAP request manually. If you cannot use them because your production environment does not allow it, then at least I would recommend using them locally and making calls with our examples to see what the SOAP requests look like if you're having trouble with them. All of our client libraries provide SOAP logging.

Thanks,

Vincent Tsao, DFP API Team

[gopavaram...@gmail.com]

Hi Vincent,

I'm using the SOAP UI for testing the service request. This approach is only for testing purpose.

Thanks for your help, the problem was solved.

Thanks,

Kiran G