Skip to main content

Upload Static CSV Data

Create a data connection from a CSV file for lookup tables, reference data, or testing.

Steps​

1. Create a new connection​

Go to Data Connections → New Connection → Static.

2. Upload your CSV​

Upload a CSV file. The first row should contain column headers.

Example CSV:

status_code,label,color
COMP,Complete,green
PROG,In Progress,blue
FAIL,Failed,red

3. Verify the data​

After uploading, review the parsed rows to make sure columns and values look correct.

4. Name and save​

Give the connection a descriptive name (e.g., "Status Codes") and click Save.

5. Use in a widget​

In a widget, fetch the data like any other connection:

const statuses = await getData("Status Codes");
// [{ status_code: "COMP", label: "Complete", color: "green" }, ...]

Use cases​

  • Lookup tables — Map codes to display labels or colors
  • Thresholds — Store target values for comparison (e.g., max temperature per zone)
  • Test data — Provide sample data while building a widget before a real data source is ready

Updating the data​

To update a static connection's data, edit the connection and upload a new CSV. The old data is replaced entirely.