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.