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

Pagination synatx for Nexturl type for REST Connector

mansoorahmed1
New Contributor III
New Contributor III

Im using REST connector for Dynamics365 and have genrate account import json for the same. The response contain next url for pagination and in the next url response map it doesnt support special character. What is the syntax for the next url page parameter in pagination for the below once.

mansoorahmed1_0-1707666796416.png

this is the error I get .

Got null response statusCode with erroMsg - [error:Error Illegal character in path at index 1: ${response?.completeResponseMap?.@odata.nextLink==null?null:response.completeResponseMap.next_page}]

Account Import JSON:

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty11",
"activeStatus": [
true
],
"deleteLinks": true,
"accountThresholdValue": 10000,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": true,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://****crm6.dynamics.com/api/data/v9.2/systemusers ",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "value",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "systemuserid~#~char",
"name": "windowsliveid~#~char",
"customproperty1": "address1_composite~#~char",
"customproperty2": "title~#~char",
"customproperty3": "azureactivedirectoryobjectid~#~char",
"customproperty4": "firstname~#~char",
"customproperty5": "lastname~#~char",
"displayname": "fullname~#~char",
"customproperty11": "isdisabled~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${response?.completeResponseMap?.@odata.nextLink==null?null:response.completeResponseMap.next_page}"
}
}
}
}
}
}

[This message has been edited by moderator to disable URL hyperlink]

2 REPLIES 2

rushikeshvartak
All-Star
All-Star
"pagination":{
               "nextUrl":{
                     "nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
               }
            }

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Manu269
All-Star
All-Star

@mansoorahmed1 There is a sample available here :

Configuring the Integration for Importing Users (saviyntcloud.com)

Can you try?

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.