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

REST Connector - API Response Format Issue during AccountImport

ssrnitish
New Contributor III
New Contributor III

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

1 REPLY 1

Vedanth_BK
Saviynt Employee
Saviynt Employee

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