Create Authorization

LLM-friendly URL

POST

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

API call form

Examples

List of examples

Create an embed token
Create a Login token
Create an API token
Specify parameter overrides when creating an embed token
Specify sticky account overrides when creating an embed token
Specify a global filter when creating an embed token
Specify a chart filter when creating an embed token
Specify an initialization filter on a dropdown or slicer filter item when creating an embed token
Specify an initialization filter on a datefilter item when creating an embed token
Specify an initialization filter on a slider item when creating an embed token
Specify an initialization filter on a chart when creating an embed token
Specify a having filter on a dashboard level when creating an embed token
Specify a having filter on a chart level when creating an embed token
Specify a theme override when creating an embed token
Specify a CSS override when creating an embed token
Specify a feature override when creating an embed token
Specify a currency override when creating an embed token
Specify a timezone override when creating an embed token
Specify column(s) to hide when creating an embed token
Give a tenant edit access to its own fields only
Specify AWS Athena connection override when creating an embed token
Specify BigQuery connection override when creating an embed token
Specify BigQuery dataset(s) connection override when creating an embed token
Specify Clickhouse connection override when creating an embed token
Specify Clickhouse dataset(s) connection override when creating an embed token
Specify Databricks connection override when creating an embed token
Specify Databricks dataset(s) connection override when creating an embed token
Specify ElasticSearch connection override when creating an embed token
Specify ElasticSearch dataset(s) connection override when creating an embed token
Specify MariaDB connection override when creating an embed token
Specify MariaDB dataset(s) connection override when creating an embed token
Specify MongoDB connection override when creating an embed token
Specify MongoDB dataset(s) connection override when creating an embed token
Specify MySQL connection override when creating an embed token
Specify MySQL dataset(s) connection override when creating an embed token
Specify Oracle connection override when creating an embed token
Specify PostgreSQL connection override when creating an embed token
Specify PostgreSQL dataset(s) connection override when creating an embed token
Specify Presto connection override when creating an embed token
Specify Presto dataset(s) connection override when creating an embed token
Specify Redshift connection override when creating an embed token
Specify Redshift dataset(s) connection override when creating an embed token
Specify SAP HANA connection override when creating an embed token
Specify Snowflake connection override when creating an embed token
Specify Snowflake dataset(s) connection override when creating an embed token
Specify SQL Server connection override when creating an embed token
Specify SQL Server dataset(s) connection override when creating an embed token
Specify Azure Synapse connection override when creating an embed token
Specify Trino connection override when creating an embed token
Specify Trino dataset(s) connection override when creating an embed token
Specify Plugin connection override when creating an embed token
Create an embed token with a Luzmo IQ context

Description

This will create an Embed token and override the properties specified for specific dataset(s) serviced by the MariaDB connection** When doing connection overrides, it's important that the schema of the tables in the override conform to the same schema as the original datasets to avoid query failures due to schema mismatches The fields available for overriding a MariaDB connection are as follows

Connection ID: The ID of the Connection to be overridden. Retrieve the ID to specify as detailed here
host: The new database host to connect to. The database must be of the same type as the originally configured database
port: The new port to connect to
user: The new user to use when connecting
password: The new password to use when connecting
database: The new schema to retrieve data from. Note that to MariaDB the concepts database and schema are identical. So when overriding a database / schema for MariaDB, make sure to pass the same value for both schema and database
schema: The new schema to retrieve data from. Note that to MariaDB the concepts database and schema are identical. So when overriding a database / schema for MariaDB, make sure to pass the same value for both schema and database
table: The new table to retrieve data from
datasets: List of dataset-level overrides. Useful if you want to override only a single dataset in your dashboard or if you have a separate table per client. The SQL query of the dataset can also be overridden if it's a SQL dataset within Luzmo
- schema: the new schema to connect to
- table: The new MariaDB table to query.
- sql: The new SQL query to run (only for SQL datasets ). Alternatively, you could also use parameterized SQL Datasets .

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.create('authorization',
  {
    type: "embed",
    username: "< A unique and immutable identifier for your user >",
    name: "< user name >",
    email: "< user email >",
    suborganization: "< a suborganization name >",
    access: {
      collections: [
        {
          id: "<collection_id>",
          inheritRights: "use"
        }
      ]
    },
    account_overrides: {
      <your connection_id>: {
        datasets: {
          < Luzmo dataset ID>: {
            sql: "SELECT ... FROM ..."
          }
        }
      }
    }
  }
);