Hi ,
I am able to fetch the data from API using oauth2 successfully, I am facing a challenge in configuring the pagination.
https://apiexplorer.csod.com/apiconnectorweb/apiexplorer#/info
I am trying to fetch the data from the above instructions, as they are the data providers
In the instructions it says the next page url comes as part of response for which below settings are recommended in denodo
https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/http_path#obtain-the-next-page-url-from-the-body-of-the-response
The tables contains around 6k records, the pagesize is set to 1000 records per call.
sample resonse from the API
{
"@odata.context": "https://[program]-pilot.csod.com/services/api/x/odata/api/views/$metadata#table_name",
"value": [
{
"user_custom_field_00030": Hello,
"user_custom_field_00031": world,
}
],
"@odata.nextLink": "https://[program]-pilot.csod.com/services/api/x/odata/api/views/table_name?$skiptoken=12345678"
}
@odata.nextLink is the key which holds next request URL string
I have entered in the next URL path the value "**/@odata.nextLink**" .as per the syntax provided in denodo instruction for pagination.
Still the resulting records from API are only 1000.
And denodo converts the Response key **@odata.nextLink** to **odatanextlink_0** when base view is created, I tried using **odatanextlink_0** as well in the next URL path, It didn't work, I am getting only 1000 records.
Please let me know, If I am missing anything else.