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

Post-aggregation 'having' filter on an ad-hoc Aggregation Formula.

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: [
          {
            dataset_id: "a4fbb816-8339-4e22-8ff0-ea48255ce048",
            column_id: "bf99d517-69ff-409f-b866-c2e53a8ea37c",
            aggregation: {
              type: "sum"
            }
          }
        ],
        where: [

        ],
        having: [
          {
            expression: "? > ?",
            parameters: [
              {
                formula: "SUM({a4fbb816-8339-4e22-8ff0-ea48255ce048:bf99d517-69ff-409f-b866-c2e53a8ea37c}) / MAX({a4fbb816-8339-4e22-8ff0-ea48255ce048:bf99d517-69ff-409f-b866-c2e53a8ea37c})",
                dataset_id: "a4fbb816-8339-4e22-8ff0-ea48255ce048"
              },
              5
            ]
          }
        ],
        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"
        }
      }
    ]
  }
);