Can we push data from ADLS GEN 2 / SQL POOL to rest api end point using Azure synapse pipeline? If Yes, Is there any document to follow for this process?

Bhanu 1 Reputation point
2022-11-01T19:39:47.827+00:00

We have a requirement to create a synapse pipeline to push the csv file data from ADLS GEN2/azure sql pool to REST API end point.

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,561 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Bhanu 1 Reputation point
    2022-11-10T21:52:15.083+00:00

    Heloo @MartinJaffer-MSFT ,
    Thank you for your response. I have used the rest connector now can be used a sink which you have shared in the first comment.
    I have used the we activity function in synapses to read data from the adls container and post the data to REST endpoin.

    QQ: I have the requirement to post csv file which should be in BASE64 format and then push to REST API end point.
    Does the REST as SINK only accepts json format? or can we convert csv to base64 and the post to REST API endpoint using WEB ACTIVITY.

    Thanks in advance!
    Bhanu