Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Sav4sav rest based user import limits

sandeepverma
Regular Contributor
Regular Contributor

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

8 REPLIES 8

sudeshjaiswal
Saviynt Employee
Saviynt Employee

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?

If you find the above response useful, Kindly Mark it as "Accept As Solution".

sandeepverma
Regular Contributor
Regular Contributor

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
Saviynt Employee
Saviynt Employee

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,

If you find the above response useful, Kindly Mark it as "Accept As Solution".

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

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
Saviynt Employee
Saviynt Employee

Hello @sandeepverma,

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

Thanks,

If you find the above response useful, Kindly Mark it as "Accept As Solution".

sudeshjaiswal
Saviynt Employee
Saviynt Employee

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

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Saathvik
All-Star
All-Star

@sandeepverma : update totalCountPath as below

"totalCountPath": "completeResponseMap.totalcount"

 


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.