Load JSON

Sharbel — Tue, 11 Jul 2023 16:19:47 GMT

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

Re: Load JSON

Jason_Dyer — Wed, 12 Jul 2023 13:26:26 GMT

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-REST-connection/Pagination-scenarios.htm

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.

topic Re: Load JSON in Integration, Extension & APIs

Load JSON

Re: Load JSON