Result of execute() giving list not dict - python client

[dee]

HI Guys,

I am trying to get the Admob network report generate API in python. the old adSence API was returning the dictionary so it was easy to convert into the CSV formate. now the new AdMob API is returning the List and inside the list the JSON. could you please suggest if it is possible to get the result in structure formate from API. 

[google me]

also, I don't see API has an alt=csv option available? 

do we need a separate code for converting to CSV in the client library like in python? 

[google me]

How do we parse the GenerateMediationReportResponse in python? do we have any method? 

[Maksym Prokhorenko]

Hello

The alt=csv is not supported yet. But you could find a java example on my github project.  Most likely you would need to implement something similar.

Many Thanks

[google me]

HI Maksym,

Thank you for your respose. 

I am using client API using Python do we have any example? the execute statement gives a list and bit and bit different to parse than Adsense which was very straight forward. 

[Maksym Prokhorenko]

Just provided a basic example on the stack overflow and shared the code on github.

[google me]

I am able to fetch the data but when I include  MATCH_RATE and IMPRESSION_CTR metrics its doesn't show up the records. 

I made some changes to the code below to get them in

if row.get('metricValues'):

for key, value in row.get('metricValues').items():

dm.update({key: next(filter(None, [value.get('value'), value.get('microsValue'), value.get('integerValue'), value.get('doubleValue')]))})

return self.admob.accounts().mediationReport().generate(

parent='accounts/{}'.format(publisher_id),

body=request).execute()

I added the value.get('doubleValue') the but it failed for the MATCH_RATE and IMPRESSION_CTR metrics. 

[AdMob API Forum Advisor]

Hello Dee,

Thanks for your feedback on your interest in a feature that would return report data in a csv format. We will consider your input into our prioritization planning.

All the Best,

Amira Badreldin AdMob API Team

ref:_00D1U1174p._5004Q24aGoY:ref

[google me]

HI Admob Team,

Is there any way we get the AdMob mediation report using python client in structure formate? without writing parser. 

[AdMob API Forum Advisor]

Hello there,

Thank you for reaching out to the forum. At the moment, the AdMob API python samples may require a parser for individual needs. If you could please elaborate on the format required, we will consider your input into our prioritization planning.

All the best,