I would like to be able to convert that data into a 3 record list with each of the objects as individual items in that list.
I am not expecting it to just magically work, but is it possible to automate this to create a table of records that is sourced from a JSON source? Ideally I would be able to also retrieve the data via a HTTP request to keep the table up-to-date automatically.
the published solution is using ParseJson() which is available in Coda for a long time.
the FormulaMap() (also knows as ForEach(), they are identical) will take a list and apply the formula you give it to EACH item in the list, combining all the results into a new list.
So, no, the FormulaMap() function is NOT for processing JSON directly.
I was a really early user of Coda in 2018-2019 and built some interesting docs but the limitations of the early app caused me to take a pause. I am quite pleased with the progress over the last few years - including Packs, Pack Studio, and OpenAI Pack among others. These are gamechangers and it looks like I can now complete the projects I was hoping to do then.