Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners Click HERE | EMEA/APJ Click HERE |
08/08/2023 06:33 AM
Hi All,
We have created a sav4sav rest-based connector and there We have ImportUserJSON block as per below. Here we wanted to know why this block is importing only 500 users.
{
"connection": "userAuth",
"url": "https://******/ECM/api/v5/getUser",
"httpMethod": "POST",
"httpHeaders": {
"Authorization": "${access_token}",
"contentType": "application/json"
},
"httpParams": "{\"userQuery\":\"employeeclass like 'External Contractor'\" }",
"httpContentType": "application/json",
"colsToPropsMap": {
"username": "username~#~char",
"locationdesc": "locationdesc~#~char",
"location": "location~#~char"
},
"userResponsePath": "userdetails",
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "max",
"batchSize": 10000,
"totalCountPath": "completeResponseMap.total"
}
}
}
Thanks
Sandeep
08/08/2023 10:07 PM
Hello @sandeepverma,
What is the total number of users you see in the Postman response when you hit the above query? And do you see iterations happening after 500user import in the logs?
08/16/2023 07:05 AM
Hi Teams,
Could you please help me to know what user import limits for the below scenarios are:
1> if users are imported using file-based import in Saviynt.
2> if users are extracted using API "url": "https://******/ECM/api/v5/getUser" in sav4sav rest based connector in Saviynt.
Appreciate your help.
Thanks
Sandeep
08/16/2023 10:29 PM
Hello @sandeepverma,
Could you please help me to know what user import limits for the below scenarios are:
1> if users are imported using file-based import in Saviynt.
Answer :- There is no limit set, thought you can validate it once.
2> if users are extracted using API "url": "https://******/ECM/api/v5/getUser" in sav4sav rest based connector in Saviynt.
Answer :- Max is 500, if you want to get more user to be displayed then you need to use the pagination.
Thanks,
08/17/2023 11:14 PM
Hi @sudeshjaiswal,
I appreciate your help.
In the 2nd query we have used the below pagination, but we are still getting 500 users only could you please check and let us know if any correction required?
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "max",
"batchSize": 10000,
"totalCountPath": "completeResponseMap.total"
}
Thanks
Sandeep
10/16/2023 08:22 AM
Hi @sudeshjaiswal,
I have one query in the second option using "url": "https://******/ECM/api/v5/getUser" we can get max 500 users in Postman so I understand to increase displayed number we have to use user pagination but where we have to use this pagination in postman.
could you please provide some sample and guidance on same.
Thank you,
Sandeep
08/18/2023 12:47 AM
Hello @sandeepverma,
Can you provide the complete json, and did you checked it in postman if it is working?
Thanks,
10/17/2023 09:28 PM
Hello @sandeepverma,
To retrieve records with pagination, you currently need to manually set the "Offset" and "Max" values in the URL, as demonstrated below:
Please note that the default setting for "Max" is 500, and you'll need to adjust the "Offset" and "Max" values as needed to fetch the desired records. If you wish to retrieve a greater number of records, this will require changes at the database level,
If you require assistance with fetching a larger set of records, please consider raising a support ticket for further guidance.
Thanks
11/10/2023 10:04 AM
@sandeepverma : update totalCountPath as below
"totalCountPath": "completeResponseMap.totalcount"