Get Data

LLM-friendly URL

POST

https://api.luzmo.com/0.1.0/data

API call form

Examples

List of examples

Aggregated measure query
Row-level query (non aggregated)
OR filters
Querying a Formula
Querying an ad-hoc Formula
Having filter on a Formula
Having filter on an ad-hoc Formula

Description

Simple Row-level query request to query non-aggregated data (e.g. a few columns). This is controlled by the rollup_data parameter.

Install

npm install @luzmo/nodejs-sdk

Example Request

Shell

Node

Java

.NET

Python

PHP

import Luzmo from '@luzmo/nodejs-sdk';
const client = new Luzmo({
  api_key: '<your Luzmo API key>',
  api_token: '<your Luzmo API token>',
  host: 'https://api.luzmo.com'
});


const response = await client.get('data',
  {
    queries: [
      {
        dimensions: [
          {
            dataset_id: "a4fbb816-8339-4e22-8ff0-ea48255ce048",
            column_id: "1de5f517-8ff0-d09f-c8cc-c4825a8ea37c"
          },
          {
            dataset_id: "a4fbb816-8339-4e22-8ff0-ea48255ce048",
            column_id: "99909a5d-aa8f-405b-8325-2d30b67af583",
            level: 6
          },
          {
            dataset_id: "a4fbb816-8339-4e22-8ff0-ea48255ce048",
            column_id: "bf99d517-69ff-409f-b866-c2e53a8ea37c"
          }
        ],
        order: [
          {
            dataset_id: "a4fbb816-8339-4e22-8ff0-ea48255ce048",
            column_id: "1de5f517-8ff0-d09f-c8cc-c4825a8ea37c",
            order: "desc"
          }
        ],
        options: {
          rollup_data: false,
          locale_id: "en",
          timezone_id: "Europe/Brussels"
        }
      }
    ]
  }
);