POST json data (stored as json files in ADLS) to REST endpoint in Azure Data factory

Question

I have a requirement to POST json data (stored as json files in ADLS) to REST API endpoint. I have to use Azure Data factory for this. I have gone through Microsoft documentation but unable to get a clear idea on it is implementation. As per my understanding ADF Data Copy activity doesn't support REST API as output/sink service.

Reaching out if anyone could help me with any documentation or reference material that could guide me to implement this. Thanks!

Answer 1

ADF has the "REST as the Source" and "REST as the sink". You can check the details on the following page: https://learn.microsoft.com/en-us/azure/data-factory/connector-rest?tabs=data-factory

I have created the pipeline with sample API and was able to post the JSON data from blob storage to the REST endpoint using copy activity in Azure data factory.

Linked Service: Rest Service as Linked Service Dataset: Rest data set Copy Activity Source: Copy activity source Copy Activity Sink: Copy activity sink

Answer 2

I have repro’d with sample API and was able to post the JSON data from blob storage to the REST endpoint using data flow activity in azure data factory.

Source dataset:

• Connect source to json dataset.

• Connect sink to rest endpoint.