REST ImportAccountEntJSON Pagination

[mgandr]

I have the below results from Postman. However, when I added the below pagination and ran the account import job, no accounts were being imported. Could someone assist me with this? Thank you!

"http": {
"url": "https://ABC.com/scim/v2/Users?scim_provisioned_only=false&include_inactive=true",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${response.completeResponseMap.itemsPerPage < 51? null : 'https://ABC.com/scim/v2/Users?scim_provisioned_only=false&include_inactive=true&startIndex=' + Math.addExact(response.completeResponseMap.itemsPerPage, response.completeResponseMap.startIndex) + '&count=' + response.completeResponseMap.itemsPerPage}"
}
}

[NM]

Hi @mgandr can you share last page response. Plus for count you can give a constant value.

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/rest-connector-offset-pagination/m-p/43765#M25645

[mgandr]

This has been fixed by including a count on the URL. 

[rushikeshvartak]

Please share fixed json

[pradeepv]

Hi @mgandr 
I have the same requirement can you please share the working json.

Thank in advance.

[mgandr · Accepted solution]

Here's the working JSON

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://ABC.com/scim/v2/Users?scim_provisioned_only=false&include_inactive=true&count=9999",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "Resources",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "internalId~#~char",
"name": "userName~#~char",
"displayName": "displayName~#~char",
"customproperty1": "name.givenName~#~char",
"customproperty2": "name.familyName~#~char",
"accounttype": "userType~#~char",
"customproperty5": "active~#~bool",
"customproperty3": "title~#~char",
"customproperty4": "timezone~#~char",
"customproperty6": "locale~#~char",
"customproperty7": "emails.value~#~char",
"customproperty8": "addresses.value~#~char"
}
}
}
}

[This post has been edited by a Moderator to fix the formatting.]

[pradeepv]

Thanks for the prompt response @mgandr appreciated!

You are not using the pagination? thanks