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

API Query Component

I have a requirement to get Google search console (GSC) data through matillion.I do have API_key, which is running fine through API Explorer.

Now i have seen in one of matillion support page that OAuth is not applicable for Google search console API..Is this correct?

I tried to give credentials by passing parameters in RSD generator, it seems this is not applicable for GSC API data.

Finally trying to provide creds using custom headers but got error as below:

Code piece:
<rsb:set attr="Header:Name#" value="Authorization" />
<rsb:set attr="Header:Value#" value="username password"/>

Error:
"code": 401, "message": "Invalid Credentials"

Please suggest ways to get the data properly.

1 Community Answers

Matillion Agent  

David Lipowitz —

Hi Rumi,

Thanks for the question. Does the API Explorer show the headers it’s using to connect? Also, can you get the API call you’re interested in working from Postman? From there you should be able translate the appropriate call into our API profile. More details on developing such profiles are available here: Connecting To Any REST API.

Please let us know the answers to the questions above and happy to dig into this further.

Best Regards,
Dave

Post Your Community Answer

To add an answer please login