0

I have data extracted through REST API from one of my applications and store it in a spreadsheet. I am using Azure Logic apps to extract data based on the date range for incremental loading everyday. In worst case, if I run the workflow twice in a single day, the data might be duplicated in the target spreadsheet. Is there a way to keep a check to avoid inserting or update the existing data in the target side ?

Improve this question
3
  • Could you please share a screenshot of your Azure logic app? Commented Mar 10, 2021 at 1:26
  • If it is based on a date range, is the extraction of duplicate data due to date overlap? Commented Mar 10, 2021 at 1:38
  • In an incremental load, always store the last run time and ensure your logic app doesn't pull records before the last run time. Commented Mar 10, 2021 at 14:39
Related questions
2
Using Excel to pull data from API
0
Simple REST API Call from logic app - Azure
50
How do we use restful APIs from Excel macros (vba)?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.