AnsweredAssumed Answered

How to Map a CSV variable to a JSON array

Question asked by JensSorensen724 on Apr 17, 2018
Latest reply on Apr 20, 2018 by leif.jacobsen@dagrofa.dk

I'm trying to map a database profile's csv field into a JSON array (absolute) and not making much progress.  I have tried to use a few string replace functions but the result has the inner quotes escaped.  Are there any suggestions or solutions that I'm not finding on Community to do this?

 

 

 

DB String Input: "FIRST,SECOND,THIRD"

 

Desired JSON Array

"JSONARRAY": [
"FIRST",
"SECOND",
"THIRD"
]

Outcomes