How to output a JSON object from Airtable Script to select individual keys/values in Airtable Automation

[Jaco]

I have a table with a JSON string in a long text field. I want to use the individual values in the Airtable Automation to update a record.

I pass the JSON string to the script and want to get it back as an object (like retrieving the body from a webhook) where I can select the individual values. I tried JSON.stringify but that returned just a string. Output.table (noticed in documentation) is not recognized.

I have no clue how to format the output function to return the value as an object instead of a string. I want to solve this within Airtable.

Any ideas?

[Rupert_Hoffsch1]

Hi @Jaco, JSON.parse() is what you’re looking for: JSON.parse() - JavaScript | MDN