Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Google DCM with Query API

Hello,

could you give an advice or an example how to get Campaign for example from DCM using API Query component?

I don't know how to combine the API Query component with the my already configured Oauth credentials.

Thanks and best regards,
Mohamed

3 Community Answers

Matillion Agent  

Kalyan Arangam —

hi Mohamed,

Unfortunately, its not possible to use the existing oauth credentials as the product limits their use to Google components.

You will have to implement your own logic for retrieving a OAuth token in Python. Then use the API Query to build your workflows to Query DCM and retrieve data.

Please note that the API Query component is useful if Google DCM returns JSON or XML data. Do you know if Google DCM returns JSON/XML or CSV?

Best
Kalyan


Mohamed Anssaien —

Hi Kalyan,

is it necessary to install oauth2client Library on the server ?

Thanks and best regards,
Mohamed


Matillion Agent  

Kalyan Arangam —

Hi Mohamed,

oauth2client looks like a the one. I have never used this previously but looks promising.

The following is from my own experience and is not related to matillion -

Please note that the default OAuth workflow requires the user to click on an authorisation link and then obtaining the Access/Refresh token. However, user-intervention may not be required if you generate the Access token yourself using the OAuth playground.

Also look into service accounts that may be suitable when working with web applications like matillion.

Hope that helps.

Best
Kalyan

Post Your Community Answer

To add an answer please login