Load JSON

[Sharbel]

Hi,

I  created connection to data source 'REST'  :

here is the full script in the  request body :

{
"jsonrpc": "2.0",
"id": 38,
"cred": {
"token": "*********",
"user": "*********"
},
"method": "appointment.get_appointment_by_filter_v2",
"params": {
"business": {
"id": "4000000007291"
},
"pageSize": 1000,
"page": 1,
"skipBusinessCancelled": false,
"filter": {
"start": "2023-06-10T00:00:00.000",
"end": "2023-07-31T23:59:59.000"
},
"network": {
"id": 388
}
}
}

the above connection has it's own limitations, such as  : 

1.the script returns data per specified page only (i.e  "page": 1, )

2.each page is limited to 1000 rows only

Is there any way to  overcome the above limitations and be able to retrieve all the data under this kind of connections? 

Any ideas would be appreciable.

Regards,

Sharbel 

[Jason_Dyer]

Hi @Sharbel - have you investigated the Pagination options found under the REST connection?

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Create...

Pagination is used when there is more data to load than the data source provides in a single load. You must specify how the connector is to page through the entire set of data you want to load. REST APIs have different mechanisms for pagination, and you must know which mechanism the selected data source uses before you can select a pagination option in the REST Connector and complete the required property fields.