How to connect with Appnexus API

[ilana105]

Dear community,

How is it possible to connect PowerBI with the API of Appnexus, and have it as a data source? Currently we access to Appnexus through a SOAP client that Appnexus offers. After this connection is done, we send an XML file with the information we want to get, and receive one XML with the response. 

To access to the API, we need to provide information of:

• Host URL
• User ID
• Password
• User Account

However, we do not know how to provide all that information in the web query

Thank you very much for all the help

[chass · Accepted solution]

Hello Ilana, 

You should try and getting this working in chrome first.  You should see the JSON being returned in the browser. 

I have an example of this here: 

https://blogs.msdn.microsoft.com/charles_sterling/2016/05/25/how-to-call-rest-apis-and-parse-json-wi...