Help

Beautify JSON , Need help

Solved
Jump to Solution
1966 10
cancel
Showing results for 
Search instead for 
Did you mean: 
AirtableNoob
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello friends , iam a noob airtable user , i’m in charge of a table that recieves data from an api in json format , the output is all in one line , so when i try to extract a value from a key using regex it does not work (it shows error) unless i use a website or manually fix the indentations and beautify the json text .
is there anyway to fix this issue using formulas or some extension that iam not aware of ?
Thank you

10 Replies 10
AirtableNoob
5 - Automation Enthusiast
5 - Automation Enthusiast

I went the scripting way at the end and i crafted a small script that go through all the records and of a specific table’s cell and just parse the json data and get the value of the key i specified and problem solved .
Thank you again for all the help guys .