Client Secrets file Missing Property client_secret

[rna...@ancestry.com]

I would like to pull reports from DoubleClick Campaign Manager using Python via my command-line interface. 

I am attempting to use these two scripts to provide this functionality:

• dfareporting_utils.py: https://github.com/googleads/googleads-dfa-reporting-samples/blob/master/python/v3_0/dfareporting_utils.py
• get_dcm_reports.py: https://github.com/kumikokashii/google-dcm-reporting/blob/master/get_dcm_reports.py

When running get_dcm_reports.py via command-line (on Mac OS Sierra), I receive the following error:

The client secrets were invalid:

Missing property "client_secret" in a client type of "installed".

WARNING: Please configure OAuth 2.0

To make this sample run you will need to populate the client_secrets.json file

I followed the steps here to receive a client_secrets.json file: https://developers.google.com/doubleclick-advertisers/getting_started

The client_secrets.json is in the same directory as dfareporting_utils.py & get_dcm_reports.py. However client_secrets.json does not contain a client_secret property. Accordingly, I'm unsure why get_dcm_reports.py is throwing the above error. Has anyone had success in getting reports from DCM using python via a command-line interface?

Any help, advice or suggestions is greatly appreciated. 

[Lakshmi Prathipati (DCM API Team)]

Hi,

Did you generate the JSON file for application type 'other'? Does the downloaded JSON file have the following format:

{"installed":{"client_id":"XXXXXXXXXX.apps.googleusercontent.com","project_id":"xxxxxxxxx","auth_uri":"https://accounts.google.com/o/oauth2/auth","token_uri":"https://accounts.google.com/o/oauth2/token","auth_provider_x509_cert_url":"https://www.googleapis.com/oauth2/v1/certs","client_secret":"xxxxxxxxxxxxxxxx","redirect_uris":["urn:ietf:wg:oauth:2.0:oob","http://localhost"]}}

I recommend double checking your application and the steps you followed while generating the credentials.

Thanks,

Lakshmi, DCM API Team