DFA Reporting API Downloading Reports Directly - report contents as json

[Nick Albano]

Hi, I am new to development, and have been working with the DFA Reporting API to setup and download reports via the API. My overall goal here would be to set up recurring calls to the API overnight so that I can store data in a database, which will be hit with other workflows as part of a greater reporting umbrella.

I'm working in Python, and have successfully created a report, checked the status of the report, and returned a URL that downloads the report in a browser.

My question:

Is it possible to have the response from the API contain the report's data in like json?

The goal here being so that I could ingest and manipulate the report contents directly into my workflows without having to worry about an actual file that I'm downloading and storing somewhere.

[dcmapi-fo...@google.com]

Hello,

This guide describes how to get started with the DCM/DFA Reporting and Trafficking API.

Before using the DCM/DFA Reporting and Trafficking API, there are a few prerequisite steps you'll need to satisfy:

1. You must have a Campaign Manager account. See Advertisers/Agencies for signup information.

2. Your Campaign Manager account must be enabled for API Access.Most accounts have this enabled by default; if you're not sure, contact your DoubleClick representative or the Campaign Manager support team for assistance.

3. You must have a user profile with access to this account. Have your Campaign Manager account administrator create a user profile associated with this account.

4. Check user profile permissions in the Campaign Manager UI. These control what the user profile can access from the API. There are no separate API permissions.

The JSON response represents a File resource. A file contains the metadata for a report run. It shows the status of the run and holds the URLs to the generated report data if the run is finished and the status is "REPORT_AVAILABLE". Please see our reference document for more information.

Regards,

Michael Cartagena, DCM API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/dfa_api
    https://developers.google.com/doubleclick-advertisers/community
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
You received this message because you are subscribed to the Google Groups "Google's DoubleClick Campaign Manager API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-advertisers-api+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Salonie Rego]

Hello :) Opening this up again since I have the same problem. I haven't been able to find any documentation about retrieving report data in json format. I would like to be able to download the data via API and then continue to manipulate it, without having to go through an external csv etc. Neither the direct download nor the download to browser options allow this.

Can you share any further information/thoughts/suggestions?

Thank you, 

Salonie

[DCM API (DoubleClick Campaign Mgr)]

Hi,

In DCM API, you will get download URL to CSV or EXCEL file based on the size of the data. There is no such feature in DCM API which would return the reporting data in JSON format. You need to post process at your end to convert the CSV data into JSON format. 

Thanks,
Lakshmi, DCM API Team

ref:_00D1U1174p._5001UApr3J:ref

[Nenad Pantic]

Just on this, we are also highly interested if you would provide direct insights endpoint rather than going through the proccess of generating reports, downloading and parsing downloaded files. It is a lot of overhead.

[DCM API (DoubleClick Campaign Mgr)]

Hi,

I forwarded this request as a feature request to the rest of the team. 

[Elettra Damaggio]

Hi all,

I found this conversation very relevant to the issues I have at the moment.

I would like to put the GCM report into a dataframe, however the CSV format is not the best because it has a commentary on top of the file.

What would be the best way to handle this and put the report directly in a dataframe?

Of course having the report as Json would solve a lot.

[DCM API (DoubleClick Campaign Mgr)]

Hi there,

I work along with Lakshmi. Allow me to assist you in this.

With regard to your use case, I'm afraid that you need to post process the report at your end once you download the report file.

Regards,

Teejay Wennie Pimentel DCM API Team

ref:_00D1U1174p._5001UApr3J:ref