Connect API using QlikView

[HJ]

Hi all,

I'm kind of new to the use of an API, so I hope you can help me some further.

In our organisation we use QlikView for reporting. Could anyone explain me how to connect to the DFP API by using QlikView?

Regards,

HJ

[DFP Advisor]

Hi HJ,

The DFP API is a SOAP API and from what I can tell, QlikView is mostly javascript based. In this way, you could theoretically call the SOAP API through some jquery POST commands. The hard part would be forming the correct XML and setting up the right authentication.

However, since I imagine you are mostly concerned with reports, I would suggest creating a business logic layer that simply runs reports and loads the data into a database, or returns it through some servlet.

So:

| QlikView |   <--GET--> | Data servlet | <----> (DB) <--- | DFP report runner | <--SOAP--> | DFP API |

You can cut the DB if you want, but I'm not sure if you need your own custom historical data.

You could also theoretically do everything in the servlet, but I suggest having a layer of abstraction since running reports should be a daily occurrence, not something run every time the report is loaded.

If you haven't yet, take a look at our client libraries: https://developers.google.com/doubleclick-publishers/docs/clients

They have examples for running and downloading reports.

Thanks,

Adam Rogal, DFP API Team

[chrisb]

Just a quick note that we have started looking into adding a DFP Connector for QlikView to our QVSource product.

http://www.qvsource.com

Please feel free to get in touch if you would like to help test it out.

[chrisb]

We now have a DFP Connector for QlikView:

http://wiki.qvsource.com/DoubleClick-for-Publishers-(DFP)-Connector-For-QlikView.ashx