Rest Connection & JSON

[Sharbel]

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