Forum Discussion
Copy Data Pagination - Offset in Request Body
Hi Anonymous ,
If the API uses the offset in the request body for paging, you can implement the paging logic in the following ways:
Use the Define Variable activity to initialize the offset (e.g. offset = 0). Use the Until activity to loop through calls to the API until all page data has been fetched.For more details, you can refer to below document:
Set Variable activity - Microsoft Fabric | Microsoft Learn
Until activity - Microsoft Fabric | Microsoft Learn
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
If the API uses the offset in the request body for paging, you can implement the paging logic in the following ways:
Use the Define Variable activity to initialize the offset (e.g. offset = 0). Use the Until activity to loop through calls to the API until all page data has been fetched.
For more details, you can refer to below document:
Set Variable activity - Microsoft Fabric | Microsoft Learn
Until activity - Microsoft Fabric | Microsoft Learn
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.