REST; Account Import

[vivekrajan]

Hi Team,

I require a sample acctparams{ } to import accounts for the following Postman response.

When I keep ListField as "result_set", it is not importing any account, because Json Path is not pointing to 'email' or 'user' or 'organization' as per JSON response.

1.

"listField":"result_set",
"keyField":"accountID",
"colsToPropsMap":
{
"accountID":"email~#~char",
"name":"user~#~char",
"displayName":"user~#~char",
"customproperty2":"organization~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},

2.

when I keep "ListField" as "result_set./api/*****/29", then it is importing 1 account only. Not all the accounts. Because json path to fetch each account's detail is changing. How to import all the account using below sample response?

"listField":"result_set./api/*****/29",
"keyField":"accountID",
"colsToPropsMap":
{
"accountID":"email~#~char",
"name":"user~#~char",
"displayName":"user~#~char",
"customproperty2":"organization~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},

Saviynt Version - 23.4

Postman Response:

Please let me know if anyone requires further information

[This message has been edited by moderator to merge reply comment]

[SB]

You will have to use iterator in order to get the entire data set and import it. You can refer the below REST documentation for the example. 

https://docs.saviyntcloud.com/bundle/REST-v23x/page/Content/Developers-Handbook.htm