Google Search Concole API connection from azure synapse or ADF

Question

Hi,

We have a requirement to build process from azure to extract data from Google search console API.
we did enable the API and created the App, required OAUTH 2.0 credentials and able to get data from postman through post.

Trying to replicate the same in azure synapse using REST API connector, will it be possible and is there any documentation or blogs available for the same?

Thank You.

Answer 1

Hi @Bhoopathiraju Deepthi ,

Thank you for posting query in Microsoft Q&A Platform.

Yes, its possible. In Synapse you can create a Synapse Pipeline for same. Inside Synapse Pipeline use web activity to make REST API call OR you can consider using Copy activity with REST connector as source.

• When you use web activity to make REST API call you get data in output json of activity. Check this video to understand web activity.
• If you want to copy data from REST API into some storage then consider using Copy activity. In copy activity use REST connector dataset as Source. Click here to know more about REST connector.

Hope this helps. Please let me know if any further queries.

-------------

Please consider hitting Accept Answer button. Accepted answers help community as well.