Populate Saviynt user field from Rest Connector Reponse

[Community_User]

Originally posted on August 17 2020 at 19:46 UTC

I'm working on setting up a REST connection and I need to populate a customproperty field in saviynt either for the account created or the user's saviynt account. The data I am trying to get is part of the the rest reponse we get after creating an account, the other system grants them an ID that can't be looked up later user REST calls. How do I pass the information from a response to a user's fields so it can bee used later for account removal?

[Community_User]

Originally posted on August 19 2020 at 09:20 UTC

Hi Adam Huisman,

The data(id) that is received as a part of Create Account response can be saved into the account's customproperty and the customproperty can be accessed during the remove account with the binding {account.customproperty}.Attaching a sample CreateAccountJSONand RemoveAccountJSON.

Thank you

Vedanth B.K

[Community_User]

Originally posted on August 19 2020 at 19:38 UTC

I tried adding this line to the beginning of my create json

"accountIdPath":"call1.message.user.id",

"dateFormat":"yyyy-MM-dd'T'HH:mm:ssXXX",

"responseColsToPropsMap":{

"customproperty20":"call1.message.business_admin_id"

},

However, no customproperty20 is getting populated on the user or the account in the endpoint.

Here is a copy of the response we are getting from our call:

Call response: {"email":"test.test68@test.com","first_name":"Test","last_name":"Test68","timezone":null,"role_id":1,

"read_only":false,"suspend":false,"wants_notify_for_campaign_approval_email":false,"business_admin_id":153,"locations":[],"location_groups":[]}

It's bringing back the information we need, business_admin_id. I'm just not having any luck getting this data to populate a field in saviynt.

[Community_User]

Originally posted on August 20 2020 at 06:17 UTC

Hi Adam,

The delimiter and the datatype are missing for the customproperty20 attribute. Please try with the below and let me know if you still face any issues.

"customproperty20":"call1.message.business_admin_id~#~char"

Thank you

Vedanth B.K

[Community_User]

Originally posted on August 20 2020 at 12:52 UTC

I tried that and am still not getting any values populating customproperty20.

I've attached the debuglog from the account creation.

[Community_User]

Originally posted on August 20 2020 at 14:37 UTC

Hi Adam,

Please share the complete debug logs and the CreateAccountJSON.

Thank you

Vedanth

[Community_User]

Originally posted on August 20 2020 at 15:23 UTC

Here is the create account json and the debug log. We are trying to get the business_admin_id that is returned to currently be set as a customproperty on the account. It would be better if we could get it set as the accountID though. I'm not sure where this value is being populated, but it is currently being set to their email address.

[Community_User · Accepted solution]

Originally posted on August 25 2020 at 08:08 UTC

Hi Adam,

I noticed that the accountIdPath was incorrect. I have mapped the business_admin_id as the accoundID.Please try with the attached JSON and let me know if you still face any issues.