Does Rest API activity exist in Synapse Analytics activity?

Question

Does Rest API activity exist in Synapse Analytics activity?

Gabe 1

I am trying to download or copy a file from a vendor api the file is in json format. Is there an activity synapse analytics to use. I know in adf we have REST activity. Do we have similar in synapse analytics to use.

Gabe 1 Reputation point

2023-10-23T22:00:35.5033333+00:00

I did create Linked service with Http that connect to the API but I am still not able to retrieve the json File with copy data activity. There is no REST API in synapse. It only exists in ADF. The link u provided works for ADF only.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-10-24T20:12:21.12+00:00

Sorry, the document that I shared earlier is still applicable to Synspe Analytics.

Please let me know if you have any further questions.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-10-25T20:13:40.25+00:00

Hello Gabe,

I am checking to see if you had a chance to look into my above response.
Gabe 1 Reputation point

2023-10-25T21:31:07.17+00:00

Hi, that actually did not work, some one from YouTube suggested to keep refreshing the copy activity once the schema is imported and it worked for me. Very interesting
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-10-25T22:24:37.6466667+00:00

Hello Gabe,

Glad to know that you were able to resolve the issue. Could you please provide the video link that you are referencing here so that it will be useful to the community members looking for help on a similar question?
Gabe 1 Reputation point

2023-11-09T15:15:40.6533333+00:00

https://www.youtube.com/watch?v=5cm6bRyostE

1 answer

Your answer

Gabe 1 Reputation point

2023-10-23T22:00:35.5033333+00:00

I did create Linked service with Http that connect to the API but I am still not able to retrieve the json File with copy data activity. There is no REST API in synapse. It only exists in ADF. The link u provided works for ADF only.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-10-24T20:12:21.12+00:00

Sorry, the document that I shared earlier is still applicable to Synspe Analytics.

Please let me know if you have any further questions.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-10-25T20:13:40.25+00:00

Hello Gabe,

I am checking to see if you had a chance to look into my above response.
Gabe 1 Reputation point

2023-10-25T21:31:07.17+00:00

Hi, that actually did not work, some one from YouTube suggested to keep refreshing the copy activity once the schema is imported and it worked for me. Very interesting
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2023-10-25T22:24:37.6466667+00:00

Hello Gabe,

Glad to know that you were able to resolve the issue. Could you please provide the video link that you are referencing here so that it will be useful to the community members looking for help on a similar question?
Gabe 1 Reputation point

2023-11-09T15:15:40.6533333+00:00

https://www.youtube.com/watch?v=5cm6bRyostE

Answer 1

Hello Gabe,

Welcome to the Microsoft Q&A forum.

You can use the Copy Activity in Azure Synapse Analytics to copy data from an HTTP endpoint.

The Copy Activity in Azure Synapse Analytics supports copying data from REST API. You can use the REST connector to copy data from a REST endpoint.

Please follow the below Microsoft document.

https://learn.microsoft.com/en-us/azure/data-factory/connector-rest?tabs=data-factory

You can also use web activity in Synapse to download or copy a file.

Web Activity can be used to call a custom REST endpoint from Synapse pipeline. You can pass datasets and linked services to be consumed and accessed by the activity.

https://learn.microsoft.com/en-us/azure/data-factory/control-flow-web-activity

I hope this helps. Please let me know if you have any further questions.

Share via

Does Rest API activity exist in Synapse Analytics activity?

1 answer

Your answer