JSON Format – Lists and Arrays

JSON is commonly used to convert table-based information into a structured text format that can be exchanged between applications, APIs, databases, and AI systems. While a JSON object represents a single record, a JSON array represents a collection of multiple records.

A JSON array is enclosed in square brackets [], and each item inside the array is a separate JSON object enclosed in curly braces {}. Every object contains the same set of keys, while the values represent the data for a specific record. Objects inside the array are separated by commas.

For example, a Student List table can be converted directly into a JSON array. Each row of the table becomes one JSON object, and all objects are grouped inside the same array. If the table contains columns such as image, name, surname, email, and mobile, each JSON object will contain these same keys with values taken from the corresponding row.

When creating JSON arrays, use clear and consistent key names, place all keys and text values inside double quotation marks, and separate key-value pairs with colons. Numeric values may be written without quotation marks. Following these rules ensures that the data can be processed correctly by APIs, databases, frontend applications, backend services, and AI systems.

The accompanying video demonstrates how to convert a Student List table into a JSON array by transforming each table row into a JSON object and combining all objects into a single structured list. It also explains the standard syntax, naming conventions, and formatting rules required to create valid and reusable JSON data.