I have JSON data stored in a long-text field in Airtable that I want Zapier to use as line-item data. The JSON data is an array of objects but Zapier is reading it as a string.
I would think that Zapier should be able to recognize the data as JSON in the initial trigger result dataset. However, I’ve also tried using Zapier’s Formatter app to reformat the string, but this doesn’t work either. The Formatter app is apparently designed for the use case of a CSV string input and is unable to gracefully handle the JSON data format. (This makes sense—it’s intended to output JSON data, after all. I don’t really want to use Formatter in my Zap anyway. It’d be inefficient, since the data should already be readable as JSON!)
How do I make sure that Zapier reads this field as the JSON dataset that it is, rather than escaping it as a plaintext string?
Best answer by Troy Tessalone
View original