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

composer require luzmo/luzmo-sdk-php

Example Request

Shell

Node

Java

.NET

Python

PHP

<?php
require 'vendor/autoload.php';
use Luzmo\Luzmo;

$client = Luzmo::initialize(
  '<your Luzmo API key>',
  '<your Luzmo API token>',
  'https://api.luzmo.com'
);

$response = $client->get("data",
  array (
    'queries' => array (
      array (
        'dimensions' => array (
          array (
            'dataset_id' => "a4fbb816-8339-4e22-8ff0-ea48255ce048",
            'column_id' => "1de5f517-8ff0-d09f-c8cc-c4825a8ea37c"
          )
        ),
        'measures' => array (
          array (
            'formula_id' => "a4fbb816-8339-4e22-8ff0-ea48255ce048"
          )
        ),
        'where' => array (

        ),
        'having' => array (

        ),
        'order' => array (
          array (
            'dataset_id' => "a4fbb816-8339-4e22-8ff0-ea48255ce048",
            'column_id' => "1de5f517-8ff0-d09f-c8cc-c4825a8ea37c",
            'order' => "desc"
          )
        ),
        'options' => array (
          'locale_id' => "en",
          'timezone_id' => "Europe/Brussels"
        )
      )
    )
  )
);
?>