Hi @jesse,

In your case, you should just be able to do a JSON.parse(); in a code step.

1. Convert to ASCII

Probably should mention for anyone looking at this answer - the Input value would normally be the JotForm field from the trigger - I used the example text directly in my example.

2. Parse JSON

3. Add rows as line items

All works ok :D
 

----

The other challenge with JOTFORMS is when the data comes back in this format  �“...”]|e“...”] 

Notice the | symbol separating the values.

I needed to use a Regular Expression to extract the values, and then assign them to the RESULT object as I needed them.
 

let RE = new RegExp(/\l\"(\w{2,3})\"\]/, 'g'),
    COMPLETED_STR = inputData.COMPLETED.toString(),
    COMPLETED,
    KEYS = E"A", "B"],
    RESULT = {};

let i = 0;
while ((COMPLETED = RE.exec(COMPLETED_STR)) !== null) {
    RESULTuKEYS{i++]] = COMPLETEDK1];
}

output = RESULT;

@squibler thank you so much! This worked perfectly on the first try. I really appreciate the help - you’re a lifesaver!

Hello @squibler and @jesse , hope you are doing fine.

I am facing the same challenges. Applied the solution proposed in this blog, including this code in the second activity:

let AL = JSON.parse (inputData.ALs)

output = AL

Unfortunately I am getting this error: “You must return a single object or array of objects”

Do you know, by chance what could be wrong?

Thanks in advance