You can translate the question and the replies:

I've a pagination where I need to give the last id to have more than limit.

https://developers.miro.com/reference/enterprise-get-organization-members **limit** int32 Limit for the number of organization members returned in the result list. ==> OK **cursor** string The ID of the organization member used as the reference for pagination. To retrieve the first portion of the collection don't pass a cursor value. To retrieve the next portion of the collection, set the cursor parameter value to the ID of the last organization member you received in the response of the previous request. ==> how to configure that ??
miro pagination limit
user
27-04-2023 12:24:36 -0400
code

5 Answers

Greetings, Hope you are doing well. Denodo has dedicated pagination options for configuring HTTP requests to fetch data from a data source (i.e., XML, JSON, or delimited text file (DF)). You could use the following [documentation](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/http_path#pagination) to set the required configurations. Hope this helps!
Denodo Team
02-05-2023 02:53:35 -0400
code
Indeed but the documentation propose 4 solutions 1. Obtain the “Next Page URL” from an HTTP Header of the Response 2. Obtain the “Next Page URL” from the Body of the Response 3. Obtain a Token from the Response 4. Pagination with Indices - the 3 first solution use static values - the 4th is the solution more linking what i need but works with an offset (computed by denodo) The miro API want the id of the liste item of the previous page.
user
02-05-2023 10:38:46 -0400
IMHO : the miro API is strange/complicated, but if there is an existing solution in Denodo, I take it :)
user
02-05-2023 10:40:05 -0400
FYI , Miro team just propose me a method. I would try and give feedback after > The second option (Obtain the “Next Page URL” from the Body of the Response) that his tool provides will work with our pagination: ``` { "size": 10, "limit": 10, "total": 22, "data": [ ... ], "links": { "self": "https://api.miro.com/v2/boards/uXjVMOreMKE=/items?limit=10&cursor=", "next": "https://api.miro.com/v2/boards/uXjVMOreMKE=/items?limit=10&cursor=MzQ1ODc2NDU1MzI2OTExNDI2NH4%3D", <- he can use this link "last": "https://api.miro.com/v2/boards/uXjVMOreMKE=/items?limit=10&cursor=MzQ1ODc2NDU1MzI2OTExNDI5N34%3D" }, "cursor": "MzQ1ODc2NDU1MzI2OTExNDI2NH4=", "type": "cursor-list" } ```
user
02-05-2023 13:18:58 -0400
In fact, miro's community manager answered me and will check with their development team. Specifically, in the entry point of their api I'm interested in, the response doesn't return the "links" block while others do. So I'm not crazy ;), but it just seems like an oversight. When they have developed/corrected it, I could continue my development. However, this remains a use case to consider for improving Denodo. (Although I can understand that its rarity may not justify this development) An option 5 where we give the name of a metadata which represents the location of the cursor (note with this solution the "limit" is not even mandatory anymore)
user
03-05-2023 01:22:46 -0400
You must sign in to add an answer. If you do not have an account, you can register here