AccntEnt Import - Removing characters during account import

[shreyascn]

Hello All, 

Have a response like below where the accounts are in a array, currently the account names are getting imported with [ ], please share example on how to import without [ ] in the name

Response

 {
            "Values": [
                "Derek.Brown@XXX.com"
            ]
        },
        {
            "Values": [
                "devendra-radhakrishna.panda@XXX.com"
            ]
        },
        {
            "Values": [
                "dhara.mehta@XXX.com"
            ]
        },

JSON

"keyField": "accountID",
				"colsToPropsMap": {
					"accountID": "Values~#~char",
					"name": "Values~#~char"
				}

[naveenss]

Hi @shreyascn Please refer to the below forum post. Hope this helps!

Solved: REST - String Functions - Saviynt Forums - 9161

[Vedanth_BK]

Hi @shreyascn 

Please try the below :

	"accountID": "#CONST#${response.Values.size() > 0  ? response.Values[0].replace('[','').replace(']','') : null}~#~char",

Thank you
Vedanth B.K