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.
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.
Does it require data?
✅ Yes — A reference to the table must be provided.
the datetime format is "your-format"
What does it do?
Defines the format used to represent datetime values when converting table data to JSON.
Where does it go?
Indented under convert the table to a json.
Is it required?
❌ No — This phrase is optional.
Does it require data?
✅ Yes — Replace your-format with your desired datetime format.
Example
the datetime format is "%Y-%d-%m"
Examples
1. Convert a Sample Table to JSON
create a sample table
convert the table to a json
the json
Address: 123 east street City: San Francisco Name: john Number: + 1 (415) 691 9426
Address: 321 west street City: San Jose Name: joe Number: + 1 (415) 691 1234
Address: 213 north street City: San Francisco Name: jack Number: + 1 (415) 691 4595
2. Convert a Table to JSON with Date & Time Data
Consider the following table that is stored in a .xlsx file:
