Google Search Concole API connection from azure synapse or ADF

Bhoopathiraju Deepthi 66 Reputation points
2022-11-22T07:48:32.963+00:00

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.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,426 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,687 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,180 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee
    2022-11-23T10:29:07.82+00:00

    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.

    1 person found this answer helpful.