Convert a Table to JSON

Converts a table into JSON.

Overview

This procedure transforms a given table into its JSON representation. It accepts a table as input and outputs a JSON that represents the table's structure and content.

Prerequisite Data

These required data elements must be present in the automation before using the procedure.

Data Name	Data Type
the table	Table

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

convert the table to a json

What does it do?

Instructs the system to convert the table to a JSON string.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required in the syntax.

Does it require input data?

⛔ No — This phrase does not require input data.

the datetime format is

What does it do?

Defines the format used to represent datetime values when converting table data to JSON.

Where does it go?

This phrase should be indented beneath convert the table to a json.

Is it required?

🌟 No — This phrase is optional in the syntax.

Does it require input data?

✅ Yes — A Text value should be specified.

Example

the datetime format is "%Y-%d-%m"

Examples

1. Convert a Sample Table to JSON

Automation

create a sample table
convert the table to a json

Results

the json

• Address: 123 east street City: San Francisco Name: john Number: + 1 [phone]

• Address: 321 west street City: San Jose Name: joe Number: + 1 [phone]

• Address: 213 north street City: San Francisco Name: jack Number: + 1 [phone]

2. Convert a Table to JSON with Date & Time Data

Consider the following table that is stored in a .xlsx file:

Vegetable	Harvest Date	Harvest Time	Quantity (kg)
Carrot	2025-01-15	14:30:00	150
Broccoli	2025-03-20	09:00:00	85

Automation

open the table at the file
convert the table to a json
    the datetime format is "%m-%d-%Y"

Results

the json

• Harvest Date: 01-15-2025 Harvest Time: '14:30:00' Quantity (kg): 150 Vegetable: Carrot

• Harvest Date: 03-20-2025 Harvest Time: '09:00:00' Quantity (kg): 85 Vegetable: Broccoli

Details

The table below lists common datetime codes that can be combined to specify a format string.

Each directive represents a specific component of a date or time, such as year, month, day, etc.

Directive	Description	Example
%Y	4-digit year	2025
%y	2-digit year	25
%m	Month (01-12)	06
%B	Full month name	June
%b	Abbreviated month name	Jun
%d	Day (01-31)	18
%H	Hour (24-hour, 00-23)	14
%I	Hour (12-hour, 01-12)	02
%p	AM/PM	PM
%M	Minute (00-59)	30
%S	Second (00-59)	45
%f	Microsecond (000000-999999)	000123
%z	UTC offset (+HHMM)	+0000
%Z	Timezone name	UTC
%j	Day of year (001-366)	169
%U	Week number (Sun first day)	25
%W	Week number (Mon first day)	25
%c	Locale date & time	Tue Jun 18 14:30:00 2025
%x	Locale date	06/18/25
%X	Locale time	14:30:00