and more in a single search tool across platforms. Read the announcement here. |
02/11/2024 06:42 PM - last edited on 02/11/2024 09:40 PM by Sunil
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.
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]
Solved! Go to Solution.
02/11/2024 06:58 PM
"pagination":{ "nextUrl":{ "nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}" } }
02/11/2024 08:59 PM
@mansoorahmed1 There is a sample available here :
Configuring the Integration for Importing Users (saviyntcloud.com)
Can you try?