import.lucid
├── data
│   ├── sales-performance.csv
│   └── templates
│       └── email-flow.csv
└── document.json

To import a data set from Google Sheets, Excel, or CSV with your document, include the CSV export of the file in the data directory.

To reference it from the JSON, refer to Linked Data and Collections.

Data files are referenced without including directories. To use the file email-flow.csv shown in the example file structure, the collection data source would be defined as "dataSource": "email-flow.csv", not "dataSource": "templates/email-flow.csv".

🚧
Important: The data directory is not allowed to exceed 1MB.

Collections

An array of collection objects to draw data from. Exactly one of dataSource or values
must be provided — providing both or neither is an error.

Property	Description
`id`	ID Identifier for a collection that linked data objects will reference.
`dataSource`	String File reference.
`values`	Array[Object] Inline JSON data for the collection. Each element is an object whose keys become the column headers and whose values become the row data.

{
  "id": "sales-performance",
  "dataSource": "sales-performance.csv"
}

{
    "id": "mind-map-data",
    "values": [
        {
            "Topic ID": "E001",
            "Title": "Sustainable Urban Planning",
            "Parent Topic ID": ""
        },
        {
            "Topic ID": "E002",
            "Title": "Green Transportation",
            "Parent Topic ID": "E001"
        },
        {
            "Topic ID": "E003",
            "Title": "Renewable Energy",
            "Parent Topic ID": "E001"
        },
        {
            "Topic ID": "E004",
            "Title": "Waste Management",
            "Parent Topic ID": "E001"
        },
        {
            "Topic ID": "E005",
            "Title": "Public Green Spaces",
            "Parent Topic ID": "E001"
        },
        {
            "Topic ID": "E006",
            "Title": "Bike Lanes & Cycling Paths",
            "Parent Topic ID": "E002"
        },
        {
            "Topic ID": "E007",
            "Title": "Electric Public Transit",
            "Parent Topic ID": "E002"
        },
        {
            "Topic ID": "E008",
            "Title": "Solar Powered Grids",
            "Parent Topic ID": "E003"
        },
        {
            "Topic ID": "E009",
            "Title": "Wind Energy Integration",
            "Parent Topic ID": "E003"
        },
        {
            "Topic ID": "E010",
            "Title": "Zero Waste Initiatives",
            "Parent Topic ID": "E004"
        },
        {
            "Topic ID": "E011",
            "Title": "Composting Programs",
            "Parent Topic ID": "E004"
        },
        {
            "Topic ID": "E012",
            "Title": "Urban Parks & Forestry",
            "Parent Topic ID": "E005"
        },
        {
            "Topic ID": "E013",
            "Title": "Community Gardens",
            "Parent Topic ID": "E005"
        }
    ]
}

Supported Media

Extension	Description
`.txt`	Text file
`.csv`	Comma-Separated Values

...
    "collections": [
        {
            "id": "sales-performance",
            "dataSource": "sales-performance.csv"
        },
        {
            "id": "email-flow",
            "dataSource": "email-flow.csv"
        }
    ]
...
    "linkedData": [
        {
            "collectionId": "email-flow",
            "key": 1
        }
    ]
...