paginated_rest_source
Generate a query for a REST API that loops through all pages using offset or cursor pagination and combines results into one table.
Instructions
Generate a paginated REST source as a new query: a List.Generate page loop that accumulates pages then Table.Combine. mode = offset (uses pageParam+sizeParam, stops on an empty page) or cursor (reads the next token from nextField, stops when null). The base URL stays STATIC and the page key folds through Web.Contents [Query=...]; each page is List.Buffer-ed. dataPath is the JSON field holding the records array (e.g. "value" or "data"; empty = the body IS the array). Refresh afterwards.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | offset | cursor | offset |
| name | Yes | ||
| baseUrl | Yes | the static base URL | |
| dataPath | No | JSON field holding the records array, e.g. value or data (empty = body is the array) | value |
| pageSize | No | page size (offset mode, default 100) | |
| nextField | No | JSON field holding the next cursor/token (REQUIRED for cursor mode) | |
| pageParam | No | offset/page/cursor query parameter name (default offset for offset mode, cursor for cursor mode) | |
| sessionId | Yes | ||
| sizeParam | No | page-size query parameter name (offset mode, default limit) | |
| recordFieldsExpr | No | optional raw M for Table.FromRecords' second argument (column list/type), e.g. type table [Id=Int64.Type] |