I want to know whether incremental load is possible in case where the source data set is Azure SQL database and sink is REST API.

Question

I want to know whether incremental load is possible in case where the source data set is Azure SQL database and sink is REST API.

surjyamani boxi 0

Hi Team,

Does ADF/Azure Synapse pipline support incremental load from Azure SQL Database to REST API ? If yes, Would be very helpful if you could please provide the documentation/ solution.

Regards,

Venkat Reddy Navari 3,625 Reputation points Microsoft External Staff Moderator

2025-07-01T16:24:42.8+00:00

surjyamani boxi Just checking in to see if the below answer provided by @Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
surjyamani boxi 0 Reputation points

2025-07-03T08:42:03.2633333+00:00

Hi,
I have replied. I am still having doubts.

1 answer

Your answer

Venkat Reddy Navari 3,625 Reputation points Microsoft External Staff Moderator

2025-07-01T16:24:42.8+00:00

surjyamani boxi Just checking in to see if the below answer provided by @Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
surjyamani boxi 0 Reputation points

2025-07-03T08:42:03.2633333+00:00

Hi,
I have replied. I am still having doubts.

Answer 1

Nandan Hegde 36,156 MVP Volunteer Moderator

Unfortunately, based on my understanding REST API is not supported as a sink in ADF copy activity but only as a source.

So natively it is not possible.

You can use lookup activity to get data from Azure SQL database and via web activity trigger the API.

Bute note : there are limitations across Lookup activity and web activity

surjyamani boxi 0 Reputation points

2025-07-03T08:41:06.56+00:00

Hi,
Still not clear. How we can push the data from db to API in Json with out storing the json in storage location?

Can you please let me know.

Regards,

Surya
Venkat Reddy Navari 3,625 Reputation points Microsoft External Staff Moderator

2025-07-03T15:04:27.56+00:00
Hi surjyamani boxi building on Nandan Hegde 's response

While it's true that REST API isn't supported as a direct sink in ADF Copy activity, you can still implement incremental loading from Azure SQL DB → REST API using a workaround that avoids blob storage.

Here's how:

Use Lookup or Stored Procedure to fetch only new/changed rows (e.g., using a LastModifiedDate filter).

Pass the output to a ForEach activity, looping through each row.

In the loop, use Web activity to POST the row as JSON to the API endpoint no need to stage it anywhere.

This gives you true row-level incremental push from SQL DB to REST endpoint in JSON fully pipeline-driven.

Reference: Web activity in ADF

Hope this helps. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

I want to know whether incremental load is possible in case where the source data set is Azure SQL database and sink is REST API.

1 answer

Your answer