Photo by Pankaj Patel on Unsplash

How to Coda with JSON — main

Applying basic JSON knowledge in Coda

Isolating the raw image URL
ParseJson() applied.

Nested JSON Objects

So far the JSON Object (the one starting and closing with the curly brackets — {} — ) was a flat object, there was no nesting. This changed when I tried to set up a web hook to import data living in a form builder. Creating appealing and seductive forms and thus having a good lead or sales conversion is maybe the most important reason to use an external form builder (compared to the simple forms Coda offers).

Simple Paperform to generate leads for project PlusBus
input and output properly formatted

The JSON string in your doc

When you import the data in Coda it looks like below and that is not so appealing. On purpose I added some blue to show the start and the end of the Array inside the Object named “Data”:

The JSON String I brought into the coda doc
Understanding the data structure of the JSON sting using an external tool
RawJSON.ParseJSON("data.*.value").BulletedList()
RawJSON.ParseJSON("*..value").BulletedList()RawJSON.ParseJSON("$..value").BulletedList()
via the link Coda provided
thisRow.RawJSON.Split('"value":"')
.FormulaMap(CurrentValue.Split('"')
.First())
.Slice(2)
.NumberedList()
The Final Result
Christiaan on “How to Coda with JSON — main”

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Christiaan Huizer

I use Coda mainly for (HR) planning & (budget) calculations. Follow me to learn how to Coda with numbers. I blog at least once per week.