Get JSON format from adwords api report

[Rafaella Keyzer]

So I'm building an application which has a frontend in React and a backend in python (pyramid framework). 

I recently integrated the google adwords api to query custom reports (doing this in python). 

I'm able to get a report from the api by making a query. 

However, the response comes either in xml or csv format. The api doesn't support json response at the moment.

My question is: how can I get the data to json format and send it back to my frontend so I can display it in my webapp?

[Shwetha Vastrad (AdWords API Team)]

Hi Rafaella, 

The supported formats for report download are listed here. I'm afraid JSON is not yet supported for report downloads at the moment. You need to process the response and convert the downloaded report to JSON in your application. 

Regards,

Shwetha, AdWords API Team.

[Rafaella Keyzer]

Thank you for the reply.

Whatever I try to do to convert the xml to json I get this error: TypeError: 'NoneType' does not support the buffer interface

Do you have any experience in converting the response?

Op woensdag 7 juni 2017 18:56:33 UTC+2 schreef Shwetha Vastrad (AdWords API Team):

[Shwetha Vastrad (AdWords API Team)]

Hi Rafaella, 

Since this question is specific to Python, I would suggest that you post your question on the library's issue tracker.