and more in a single search tool across platforms. Read the announcement here. |
11/29/2022 06:33 PM
Hi,
we are trying to Import accounts using REST Connector. We are able to import accounts from the response but unable to map all the account attributes to colsToPropsMap.
Below is the API Response. We are able to map name, location, id when importing accounts, but we want to retrieve the accountDisable, displayName and other fields inside the "values" array json.
API Response
{
"name": "Testuser1",
"location": "India",
"id": "Testuser1@gmail.com",
"values": [
{
"name": "displayName",
"values": [
"Test User 1"
]
},
{
"name": "UserCannotChangePassword",
"values": [
"false"
]
},
{
"name": "accountDisabled",
"values": [
"false"
]
}
]
}
Below is the AccountImport Json
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"doNotChangeIfFailed": true,
"includeExistingInActiveAccounts": true,
"statusAndThresholdConfig": {
"deleteLinks": false,
"accountThresholdValue": 100,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "<<URL Address>>",
"httpHeaders": {
"TICKETHeader": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "id~#~char",
"customproperty1": "id~#~char",
"customproperty2": "location~#~char",
"displayName": "name~#~char"
}
}
}
}
}
Thanks,
Nitish
12/04/2022 08:43 PM
Hi @ssrnitish ,
Please try with the below JSON.
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"doNotChangeIfFailed": true,
"includeExistingInActiveAccounts": true,
"statusAndThresholdConfig": {
"deleteLinks": false,
"accountThresholdValue": 100,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "<<URL Address>>",
"httpHeaders": {
"TICKETHeader": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "values[0].name~#~char",
"name": "id~#~char",
"customproperty1": "id~#~char",
"customproperty2": "location~#~char",
"displayName": "name~#~char"
}
}
}
}
}
Thank you
Vedanth