Tabula Documentation
Tabula HomeCommunity
  • 👋Introduction to Tabula
  • Getting Started
    • Product Updates
    • Getting Started
      • Installation and Login
      • Beginner's Guide
    • FAQ
  • Product overview
    • Home Page
    • Exploring Data
      • Data Catalog
      • Exploring Datasets
      • Statistics Panel
    • Designing Flows
      • Creating Flows
      • Flow Designer Guide
        • Working with Canvas
        • Using Groups
        • Working with Table
      • Managing Flows
      • Sharing Flows
      • Demo: Building a Simple Flow
    • Executing Flows
      • Running Flows
      • Jobs overview
    • Building Reports
      • Designing Reports
      • Running Reports
      • Reports Page
    • Connecting Data
  • Integrations
    • Enrichments
      • How to add your API key in Tabula
      • List of Supported Queries
      • Enrichment Providers
        • AnymailFinder
        • Apollo
          • How to find Apollo API key
          • Enrich person by LinkedIn
          • Enrich company by domain
        • Bounceban
        • Bouncer
        • Bouncify
        • CaptainVerify
        • Cleanify
        • Clearout
        • CompanyEnrich
        • ContactOut
          • How to find ContactOut API key
          • Enrich person by LinkedIn
          • Enrich person by email
        • Discolike
        • TheCompaniesAPI
        • Findymail
        • Emailable
        • EmailListVerify
        • Enrichley
        • Heybounce
        • Hunter
        • Kickbox
        • Mails
        • MailChecker
        • MillionVerifier
        • NeverBounce
        • Nubela (Proxycurl)
        • PeopleDataLabs
        • Prospeo
        • ZeroBounce
        • ReverseContact
          • How to find Reverse Contact API key
          • Enrich person by LinkedIn
          • Enrich person and company by email
          • Enrich company by domain
          • Enrich company by LinkedIn
        • UpLead
    • Data Sources
      • Configuring Fivetran Integration
    • Data Storages
      • PostgreSQL
      • Snowflake
      • BigQuery
      • ClickHouse
  • Data Transformation
    • Transforms
      • Source
      • New Empty Table
      • Output
      • Chart
      • Enrichment
      • New Column
      • If...Then
      • Rolling Functions
      • Column Type
      • Columns Edit
      • Filter
      • Remove Duplicates
      • Sort
      • Find and Replace Text
      • Split Column
      • Extract Text
      • Match Text
      • Join
      • Union
      • Group By
      • Pivot
      • Unpivot
      • To JSON
      • From JSON
      • API Call
      • AI Column
      • AI Table
    • Formulas
      • What are Formulas?
      • Math Functions
        • Abs
        • Ceiling
        • Exp
        • Floor
        • IsEven
        • IsOdd
        • Ln
        • Log
        • Log10
        • Mod
        • Pi
        • Power
        • Quotient
        • Round
        • RoundDown
        • RoundUp
        • Sign
        • Sqrt
        • Truncate
      • Trigonometric Functions
        • Acos
        • Asin
        • Atan
        • Atan2
        • Cos
        • Cot
        • Degrees
        • Radians
        • Sin
        • Tan
      • String Functions
        • Compare
        • Concat
        • Contains
        • In
        • CountMatches
        • CountMatchesRegexp
        • EndsWith
        • EndsWithRegexp
        • Extract
        • FindMatchOfString
        • FindMatchOfRegexp
        • FindMatchesOfString
        • FindMatchesOfRegexp
        • Left
        • Length
        • Lower
        • Matches
        • Pad
        • ProperCase
        • RemoveSymbols
        • RemoveWhitespaces
        • Repeat
        • Replace
        • ReplaceRegexp
        • Reverse
        • Right
        • Spaces
        • Split
        • SplitRegexp
        • StartsWith
        • StartsWithRegexp
        • Stuff
        • Substring
        • SubstringDelimiter
        • SubstringRegexpDelimiter
        • Trim
        • Upper
      • Date & Time Functions
        • Date
        • DateAdd
        • DateAdd2
        • DateDiff
        • DateDiff2
        • DateFromParts
        • DateTime
        • DateTimeFromParts
        • DateTrunc
        • DayName
        • DayOfMonth
        • DayOfWeek
        • DayOfYear
        • Hour
        • Minute
        • Month
        • MonthName
        • Now
        • Quarter
        • Second
        • Time
        • TimeFromParts
        • Today
        • Week
        • Year
      • Aggregate Functions
        • Any
        • AnyIf
        • Array
        • ArrayIf
        • Avg
        • AvgIf
        • AvgInRow
        • Count
        • CountA
        • CountIf
        • CountUnique
        • Max
        • MaxIf
        • MaxInRow
        • Median
        • MedianIf
        • Min
        • MinIf
        • MinInRow
        • Mode
        • ModeIf
        • Percentile
        • Quartile
        • StdDev
        • StdDevIf
        • Sum
        • SumIf
        • SumProduct
        • Variance
        • VarianceIf
      • Conversion Functions
        • ToArray
        • ArrayToString
        • ToBoolean
        • ToDate
        • ToDateTime
        • ToDecimal
        • ToInteger
        • ToObject
        • ToTime
        • ToString
      • Misc Functions
        • At
        • IsMissing
        • RowNumber
        • Random
        • If
        • Coalesce
        • True
        • False
        • Null
        • $target
      • Window Functions
      • Custom Functions
      • Data Types
      • Supported Date Parts
      • Regex: List of Tokes
  • Pricing & Billing
    • Plans, Subscriptions, and Credits
    • Tabula for Education
  • Tutorials
    • Tabula Use Cases
    • Merge Columns
    • Join Types
    • Union Introduction
    • Window Functions
    • What is Unpivot?
    • JSON Format Tutorial
    • Using Regex
Powered by GitBook
On this page
  • Introduction
  • JSON Data Types
  • JSON Objects and Arrays

Was this helpful?

  1. Tutorials

JSON Format Tutorial

Introduction

What is JSON?

JSON, or JavaScript Object Notation, is a lightweight data interchange format that is easy for humans to read and write and easy for machines to parse and generate. JSON is a text format that is completely language-independent but uses conventions familiar to programmers of the C family of languages, including C, C++, C#, Java, JavaScript, Perl, Python, and many others.

Example

{
"name": "Alice Smith",
"age": 30,
"email": "[alice.smith@example.com](<mailto:alice.smith@example.com>)",
"isStudent": false,
"courses": ["math", "history", "chemistry"],
"address": {
			"street": "123 Main St",
			"city": "New York",
			"state": "NY",
			"zipCode": "10001"
			}
}

In this JSON example:

  • The person's name, email, and address fields are strings.

  • The age is a number.

  • The isStudent field is a boolean.

  • The courses field is an array of strings.

  • The address field is an object containing the street, city, state, and zipCode fields

Why JSON?

JSON is often used to transmit data between a server and a web application, serving as an alternative to XML. JSON is favored because it is:

  • Easy to read and write for humans

  • Easy to parse and generate for machines

  • Less verbose than XML

  • Natively supported in JavaScript

  • Widely supported in many programming languages

JSON Syntax

JSON syntax is a set of rules for writing JSON data. JSON data is represented using two structures:

  1. A collection of key-value pairs (also known as an object)

  2. An ordered list of values (also known as an array)

The key features of JSON syntax are:

  • Data is stored in key-value pairs, separated by colons (:)

  • Curly braces ({}) hold objects

  • Square brackets ([]) hold arrays

  • Keys must be strings wrapped in double quotes (")

  • Values can be strings, numbers, booleans, objects, or arrays

  • Multiple key-value pairs in an object, as well as multiple values in an array, are separated by commas (,)

JSON Data Types

JSON supports the following data types:

String: A sequence of characters enclosed in double quotes, e.g., "hello"

Number: A number without quotes, e.g., 42 or 3.14. JSON numbers can be integers or floating-point values.

Boolean: Represents either true or false (without quotes)

Array: An ordered collection of values enclosed in square brackets, e.g., ["apple", "banana", "cherry"]

Object: A collection of key-value pairs enclosed in curly braces, e.g., {"name": "John", "age": 30}

null: Represents an empty value or non-existence (without quotes)

JSON Objects and Arrays

JSON Objects

A JSON object is a collection of key-value pairs, where each key is a string, and the value can be any JSON data type. JSON objects are wrapped in curly braces ({}). For example:

jsonCopy code
{
  "name": "John Doe",
  "age": 35,
  "isStudent": false
}

JSON Arrays

A JSON array is an ordered collection of values, where each value can be any JSON data type. JSON arrays are wrapped in square brackets ([]). For example:

jsonCopy code
[
  {
    "name": "John Doe",
    "age": 35,
    "isStudent": false},
  {
    "name": "Jane Doe",
    "age": 28,
    "isStudent": true
   }
]
PreviousWhat is Unpivot?NextUsing Regex

Last updated 1 year ago

Was this helpful?