This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I have some JSON in a custom column field, I need to parse it. If I use ?eval it throws an unexpected error. Can't figure it out

From memory ?eval chokes on null. There is a new eval_json directive in Freemarker but I don't think it's available yet in the version NetSuites uses

You can read a bit more about it on here. <https://stackoverflow.com/questions/13087436/freemarker-parse-a-string-as-json|https://stackoverflow.com/questions/13087436/freemarker-parse-a-string-as-json>

<@U29QCJQF3> you're right, eval_json doesn't seem to work yet

<@U027PS9BDU2> I believe this is going from string to JSON, i'm trying to go from JSON to array

This is a string right stored in a field in some record ?
You will first have to parse the string and convert it to JSON?
And then you will have your array of dictionaries which you can iterate?

it's possible that NS see's it as a string

because yes a user event script is generating it as JSON and then setting it into a freeform text field

I don't think you can do a outer square bracketed JSON like you example [ { }, { }, { } ]

you need to convert it to:

{ translations: [ { } , { } ] }

you outer brackets must be curly braces.

this is the JSON now, the second I run ?eval it gets an unexpected error

even if i try ?eval something like this it throws the error