Rest Connection & JSON

Sharbel — Sat, 10 Jun 2023 12:20:07 GMT

Hi,

I have the following rest connection in Qlik sense :

and also the following 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
}
}
}

there are some limitations with the above script :

1.it always returns 250 rows (although "pageSize": 1000)

2.it is limited to only 1 page ("page": 1)

3.it is limited to specific id ("id": "4000000007291")

4."start date" and "end date" are hardcoded as well

I appreciate any help in modifying the above script so it accomplishes the following:

1. parameter "page size" returns maximum rows

2.Number of pages is not limited to 1 (maximum pages available)

3.Parameter "id" there are 17 different id's each one is consists of 13 digits and always starts with 400000000 (the complete number would look like 400000000XXXX)

4."start date" & "end date" are dynamic

appreciate your help

Sharbel

topic Rest Connection & JSON in App Development

Rest Connection & JSON