We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Map API fields to import accounts

Manju_p
New Contributor II
New Contributor II

Hi, 

We are trying to import accounts into saviynt Application using REST Connector. Below is the API output format of list of users received through API.  Looking for steps on how we can map  values in ImportAccountEntJSON  under colsToPropsMap values

format of API output
"username": {
"authentication": "windows",
"props": {
"Full_Name": "fullname"
}
}
Request GET https://XXXXXXX/api/latest/users

RESPONSE: 
{
"a-XXXXX.rusman": {
"authentication": "windows",
"props": {
"Full_Name": "Aizul XXXX Rusman"
}
},
"a-XXXXX.mrawi": {
"authentication": "windows",
"props": {
"Full_Name": "Nor XXX Rawi",
"Previous_Hub": "devcdchub01"
}
},
"a-XXXXXX.zulkefli": {
"authentication": "windows",
"props": {
"Compact_Mode": false,
"Full_Name": "XXXXX Zulkefli",
"Num_Events_Initially": 50,
"Previous_Hub": "devcdchub01",
"Show_Inactive_Jobs": false,
"Show_Internal_Jobs": false,
"Theme": "dark",
"Topology_Animation": true,
"Topology_Preferences": "{\"location_props\":[1,5],\"location_group\":0,\"metrics\":[{\"name\":\"Hub\",\"value\":[2001]},{\"name\":\"Channel\",\"value\":[2001]},{\"name\":\"Capture job\",\"value\":[2000]},{\"name\":\"Integrate job\",\"value\":[2001]},{\"name\":\"Capture location\",\"value\":[2000]},{\"name\":\"Integrate location\",\"value\":[2001]},{\"name\":\"Bidirectional location\",\"value\":[2000,2001]}],\"latency_sla\":7200}"
}
}
}

Thanks, 
Manju

3 REPLIES 3

SB
Saviynt Employee
Saviynt Employee

You can refer to the REST integration document for information on how to map and construct the JOSN. 

 

Examples of JSON Construction and 

Developers Handbook


Regards,
Sahil

Manju_p
New Contributor II
New Contributor II

Hi Sahil, 

Thanks for the response.  We have difference in the  structure of CDC application response and Zendesk application. Zendesk application response has  a standard structure  of userlist. We can define "Listfield" as users and each user value is clearly segregated. In CDC application we have each username  has  authentication, full name embedded into it.   

CDC application format
"username-user1": {
"authentication": "windows",
"props": {
"Full_Name": "fullname"
}
}

Zendesk fromat

"users": [
{
"id": "",
"name": "John",
"Eail": "customer@example.com",
"phone":"1232324324",
}
]


Thanks, 
Manju

SB
Saviynt Employee
Saviynt Employee

The data has to be structed in order to be imported correctly. Based on the response you shared, it appears there is no way to identify in the response the key field value. Let me know if I am not reading the response right.


Regards,
Sahil