Sav4sav rest based user import limits

[sandeepverma]

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

[sudeshjaiswal]

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?

[sandeepverma]

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

[sudeshjaiswal]

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,

[sandeepverma]

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

[sandeepverma]

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 

[sudeshjaiswal]

Hello @sandeepverma,

Can you provide the complete json, and did you checked it in postman if it is working?

Thanks,

[sudeshjaiswal]

Hello @sandeepverma,

To retrieve records with pagination, you currently need to manually set the "Offset" and "Max" values in the URL, as demonstrated below:

URL: https://xxxx.saviyntxxx.com/ECM/api/v5/user?q=accountExpired:0&fields=firstname,lastname,username&so... 

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

[Saathvik]

@sandeepverma : update totalCountPath as below

"totalCountPath": "completeResponseMap.totalcount"