Skip to main content

Static (CSV) Connections

A static connection stores rows of data directly in Crow's Nest, with no external data source. You can enter data manually or upload a CSV file. This is useful for lookup tables, reference data, or testing.

Setting up a static connection​

  1. Go to Data Connections and click New Connection.
  2. Select Static as the connection type.
  3. Upload a CSV file or enter data manually.
  4. Give the connection a name.
  5. Click Save.

CSV upload​

When you upload a CSV file:

  • The first row is treated as column headers.
  • All subsequent rows become data records.
  • Column types are inferred automatically (text, numbers, etc.).

Using static data in widgets​

Static connections work the same as other types in widget code:

const lookupTable = await getData("Part Numbers");

The data is returned as an array of objects, one per row, with keys matching the column headers.

When to use static connections​

  • Lookup tables — Map codes to descriptions (e.g., status codes to human-readable labels).
  • Reference data — Thresholds, targets, or configuration values that don't live in an external database.
  • Testing — Provide sample data while developing a widget before connecting a real data source.

Notes​

  • Static data is stored within Crow's Nest. It doesn't require a data source config.
  • To update the data, edit the connection and re-upload a new CSV or modify the rows.
  • There's no automatic refresh — the data stays as-is until you manually update it.