What's JSON?

JSON (JavaScript Object Notation) is a way of storing and displaying a value type.

Any of type of data can be represented by JSON, which make it really handy for quickly understanding any piece of data you have.

For example, below is a table of data:

Name Gender Age Attending Event
Calum Moore Male 28
FALSE
Sarah Jones Female 22 TRUE

In JSON it would look like this:

[{
  "Name": "Calum Moore",
  "Gender": "Male",
  "Age": 28,
  "Attending Event": false
}, {
  "Name": "Sarah Jones",
  "Gender": "Female",
  "Age": 22,
  "Attending Event": true
}]

See what other value types look like when they're represented as JSON.

Using JSON in formula

You can write JSON in any formula - the following creates a list of numbers and then sums them.

Sum([1, 2, 3])

JSON as a String

JSON can be stored as a string - which makes it easier for computers to send the data across the internet or store in a database. JSON looks the same when stored as a string, but it is encapsulated with speech marks '.

'[{
  "Name": "Calum Moore",
  "Gender": "Male",
  "Age": 28,
  "Attending Event": false
}, {
  "Name": "Sarah Jones",
  "Gender": "Female",
  "Age": 22,
  "Attending Event": true
}]'
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.