Any elegant way to convert table data to JSON?

2

This is the most compact way to represent a Coda table as a JSON object:

The formula is…
image

How it works…

  • we use Format() to provide the JSON structure & insert the names & values
  • for each column we provide the column name, and a list of its values
  • so in this example we do that for the Name, Email, Amount, and Notes columns
  • then we use SubstituteAll() to place double quotes around all the commas

We can test this JSON by using ParseJson() with c column name & a row+1
This proves the JSON is formatted correctly.

Max

3 Likes