Create Dataset

LLM-friendly URL
POST
https://api.luzmo.com/0.1.0/securable

Datasets and dashboards are in the Luzmo API a type of securable . As such, the API calls to create, update, delete, ... datasets or dashboards are executed against the securable endpoint.

Properties relevant to one, may not be relevant to the other. Those will be null (e.g. contents is null for a dataset while for dashboards it is one of the most important properties as it holds the definition of screenmodes, charts, ...).

Any user with an API token can create a dataset. The user that creates the dataset will be automatically associated as the owner. Note that the creation of a dataset simply creates a securable of a certain type with properties such as name, title and description. To actually add data to the dataset you also have to create columns, associate them to the dataset and push data to the dataset.

⚠️ We advice to create your dataset automatically, rather than creating your dataset via this endpoint. The creation of a dataset via this route involves several steps (creation of dataset, creation of columns, association of columns and datasets and finally adding of the data) which need to be executed entirely correct to ensure you have a working dataset. We thus advise to instead look at this documentation:
  • via the data endpoint if you are looking to create a dataset for data push
  • via the dataprovider endpoint if you are looking to create a dataset based on a connection to your database or plugin. Also check the dataprovider to understand how to programmatically establish a connection to your data source.
Parameters
Expand all Reset
properties *OBJECTrequired
name Multilingual string
description Multilingual string
subtitle Multilingual string
type STRING
subtype STRING
source_dataset STRING
source_sheet STRING
source_query STRING
transformation STRING
cache NUMBER
update_metadata BOOLEAN
meta_sync_interval NUMBER
meta_sync_inherit BOOLEAN
meta_sync_enabled BOOLEAN
last_metadata_sync_at DATETIME
Can be executed by:
Organization Editor
Can be associated to:
Columns
Groups
Schedule
Users
favorites
Tags
Collections
Integrations
EmbedFilterGroups
Dashboards
Did this page help you?
Yes No
Language
Shell
Node
Java
.NET
Python
PHP
Install
npm install @luzmo/nodejs-sdk
Example Response
200
400
500
{
  "id": "f13df731-fff4-4b6b-b6e0-58a7d3956685",
  "type": "dataset",
  "subtype": "demodataplugin",
  "name": {
    "en": "Sales dataset",
    "nl": "Verkoopsgegevens",
    "fr": "Données de ventes"
  },
  "description": {
    "en": "Dataset with demo sales data.",
    "nl": "Dataset met demo verkoopsgegevens",
    "fr": "Dataset contenant des données de ventes"
  },
  "subtitle": null,
  "contents": null,
  "css": null,
  "source_dataset": "8b7954e2-3664-4437-b8cb-4b05b6ddee91",
  "source_sheet": "sales_dataset",
  "source_query": null,
  "transformation": null,
  "rows": 102,
  "featured": false,
  "modified_at": "2023-09-14T15:36:26.338Z",
  "cache": 0,
  "storage": "client",
  "is_variant": false,
  "migrated_rows": null,
  "uses_clickhouse_experimental": false,
  "meta_sync_interval": 1,
  "meta_sync_inherit": true,
  "meta_sync_enabled": true,
  "last_metadata_sync_at": "2024-02-21T11:47:27.432Z",
  "last_metadata_sync_attempt_at": "2024-02-21T11:47:25.391Z",
  "created_at": "2023-09-14T15:36:26.338Z",
  "updated_at": "2024-02-21T11:47:27.431Z",
  "acceleration_id": null,
  "account_id": "8b7954e2-3664-4437-b8cb-4b05b6ddee91",
  "template_id": null,
  "original_id": null,
  "modifier_id": "8ad836a8-3547-4ed6-ba59-b445bfed05ed",
  "owner_id": "8ad836a8-3547-4ed6-ba59-b445bfed05ed",
  "source_template_id": null
}