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 query request to group on a dimension and query an aggregated measure.

Install

composer require luzmo/luzmo-sdk-php

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: [

        ],
        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"
        }
      }
    ]
  }
);

Example Response

200

400

500

{
  "cached": false,
  "performance": {
    "validating": 0,
    "preparing": 115,
    "queuing": 0,
    "querying": 10331,
    "processing": 0,
    "rows": 1
  },
  "data": [
    [
      19
    ]
  ]
}