Forum Discussion
Solved
API Loop
Good morning, have a question regarding a pipeline that I am building and looking for input on. I am making a call to an API endpoint that will only return up to 500 results. If there are more than 5...
Hi halll_sc
You can perform the SQL query activity after the Copy Data activity. Add an sql query to calculate whether 500 records are returned.
How to use Script activity - Microsoft Fabric | Microsoft Learn
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi halll_sc
You can perform the SQL query activity after the Copy Data activity. Add an sql query to calculate whether 500 records are returned.
How to use Script activity - Microsoft Fabric | Microsoft Learn
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.