REST Connector - manipulate value returned in array

[Community_User]

Originally posted on October 17 2021 at 18:19 UTC

I feel this should be simple to accomplish but I cannot figure it out.

I have a simple REST data return that has a char at the beginning "E" that I wish to remove when mapping to the user record. In the ImportUserJson I have tried a variety of methods such as this:

 "customproperty1": "${workRelationships[0].assignments[0].managers[0].ManagerAssignmentNumber.substring(1)}~#~char"

This returns no data at all. If I remove the substring function, it returns the full data "E332126"

The source data value pair looks like this:

 "ManagerAssignmentNumber": "E332126"
How to only pull in "332126" in ImportUserJson?

[Community_User · Accepted solution]

Originally posted on October 18 2021 at 22:09 UTC

Saviynt novice here.. this resolved my issue once I discovered the capability:

User Import Preprocessor : Customer Portal (freshdesk.com)