执行REST API的分页 - ADF [英] Perform Pagination for REST API - ADF

问题描述

我正在使用已实现分页的ADF来使用REST API，响应确实包含文档中的部分，其中显示总行数和行数每个页面都有，使用它可以决定我必须运行多少页。

I'm consuming REST API using ADF which has pagination implemented, response does contain section in document which says how many total rows are there and how many rows each page has, using which can decide for how many pages I have to Run.

但是我不知道如何在ADF中读取这些数据并执行此操作。

However I'm not sure how to read this data within ADF and perform this operation.

我当前的设置看起来像（这没有分页，只是获取第一页）

My current setup looks like (this does not have pagination and just gets first page)

获取我必须调用API的企业的SQL任务，然后是迭代每个业务的每个外观并调用API

SQL task to get Businesses for which I have to call API, then for each look which iterated over each business and calls API

这将返回第一页，我存储而不是blob存储

This returns first page and I store than in blob storage

现在如果我必须进行分页，我认为for循环需要另一个for循环用于分页

Now if I have to do pagination, i think for-loop need to have another for loop which is for pagination

我是在正确的轨道上还是有更好的实现方式这个分页？

Am I on right track or is there better way of achieving this pagination?

另外我如何阅读那些具有分页细节的json页面部分。

Also how do I read those json page section which has pagination detail.

谢谢，

Dilkush

谢谢，Dilkush Patel Microsoft SQL开发人员支持Microsoft Corporation

Thanks, Dilkush Patel Microsoft SQL Developer Support Microsoft Corporation

推荐答案

ADF将发布一个新的连接器，通用REST连接器，它能够自动从所有页面获取数据。 我相信这就是你想要的。

ADF will release a new connector, generic REST connector, which is able to automatically fetch data from all pages.  I believe that's what you want.

这篇关于执行REST API的分页 - ADF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！