How to configure REST pipeline in Azure Data Factory to call PUSH command with some data

Andrzej Jarosz 1 Reputation point
2022-12-04T14:30:33.08+00:00

I am trying to use Azure Data Factory to retrieve data from the external rest API server and to put data into the Azure SQL database. I configured "DATA COPY" with source "REST" but I can't configure it to send the PUSH command with data.

Using the command line tool curl

curl -X POST https://shelly-56-eu.shelly.cloud/device/status -d "id=aaaaaaaaa&auth_key=bbbbbbbbbbbbbb"

where aaaaa and bbbbb have proper values it works fine.

How to repeat in Azure Data Factory? How to configure Azure REST pipeline, where to set the data "id=aaaaaaaaa&auth_key=bbbbbbbbbbbbbb"

I would be extremely grateful when having your support.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,643 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,971 Reputation points Microsoft Employee
    2022-12-06T07:54:29.023+00:00

    Hi @Andrzej Jarosz ,

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

    Do you want to copy data from REST to Azure SQL? If yes, you can do it using copy activity.

    Inside copy activity, under source tab use REST dataset and under sink tab use Azure SQL database dataset. Click here to know about REST connector with Copy activity. Check this video to understand copying data from REST.

    Now, coming to another part of query, you mentioned you want to make PUSH API call. Where exactly you want to do that? Is it after copy activity? If yes, you can consider using web activity for this.

    Check this video to understand about web activity.

    Hope this helps.

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

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