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

Example how we can use a Formula that has been created previously, as a measure and order.

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"
          }
        ],
        measures: [
          {
            formula_id: "a4fbb816-8339-4e22-8ff0-ea48255ce048"
          }
        ],
        where: [

        ],
        having: [

        ],
        order: [
          {
            dataset_id: "a4fbb816-8339-4e22-8ff0-ea48255ce048",
            column_id: "1de5f517-8ff0-d09f-c8cc-c4825a8ea37c",
            order: "desc"
          }
        ],
        options: {
          locale_id: "en",
          timezone_id: "Europe/Brussels"
        }
      }
    ]
  }
);