Photo by Ferenc Almasi on Unsplash

How to Coda with JSON — intro

What is JSON and when do you need it in Coda?

JSON

The abbreviation JSON stands for JavaScript Object Notation and this implies you work with JavaScript. JSON is a Data Representation Format, a syntax a set of rules that describe how data of all sorts relates. You need to understand how to notate it, how to write it, when you make use of it in the context of exchanging data between Coda and other software tools. These are the basics.

  • Strings — ‘Christiaan Huizer”,
  • Numbers — 10 1.5 -35
  • Boolean s— true false
  • null — null (stands for nothing)
  • Arrays — [1,1,2,3,5,8,13,21] [“Hello”, “Nathan”, “Louison”]
  • Objects {“Key” : “value”} {“age” : 50}
the square brackets around a column name

Nesting Arrays

So far we described mainly one to one relations, but in the real world the data complexity requires a bit more. We start with writing a simple JSON object, one we open and close with the curly brackets. This is called a flat format of data.

Simple JSON — a flat format of data
nested objects inside an array
The format logic in Coda with curly brackets, double quotes and commas
Christiaan — ‘How to Coda with JSON — intro?”

--

--

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.

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.