Update Formula

LLM-friendly URL
POST
https://api.luzmo.com/0.1.0/formula

Update an existing formula.

Note: during updating of formula, expressions will be validated. Please, see details in the validate endpoint.

Request parametersResponse schema
id UUID

The unique identifier of the entity

name Multilingual string

Internationalized name of the formula.

description Multilingual string

Internationalized description of the formula.

expression STRING
No description available
type STRING
No description available
subtype STRING
No description available
format STRING
No description available
informat STRING
No description available
lowestLevel NUMBER
No description available
currency_id STRING

Currency ID for this column. The currency_id is expected in the form of an ISO 4217 currency code , for example: EUR or USD .

custom_metadata OBJECT

Custom metadata attached to this formula. Must be a valid JSON object with a maximum size of 65536 bytes. Set to null to clear previously stored metadata.

created_at DATETIME

RFC 3339 date time string indicating when the resource was created

updated_at DATETIME

RFC 3339 date time string indicating when the resource was last updated

Can be executed by:
Dataset Modifier
Can be associated to:
Currency
Dataset
User
Search Formula
Delete Formula
Did this page help you?
Yes No
Language
Shell
Node
Java
.NET
Python
PHP
Base URL
https://api.luzmo.com/0.1.0/formula
Example Request 
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.update('formula', '<the entity id>',
  {
    expression: "AVG({69c36023-f791-4225-a6cb-b093ac598a70:6a71afc0-c95c-4d8b-8a99-c9c568d83f53})",
    name: {
      en: "avg_uniq_id"
    },
    custom_metadata: {
      scope: "sales",
      nested: {
        level: "L2",
        enabled: true
      }
    }
  }
);
You are not authenticated.
Log in to try
Example Response
200
400
500
{
  "count": 1,
  "rows": [
    {
      "id": "b3ad615a-5199-4e58-8e0e-73dceba18af0",
      "currency_id": null,
      "description": {
        "en": "Calculated average of unique ID"
      },
      "expression": "AVG({69c36023-f791-4225-a6cb-b093ac598a70:6a71afc0-c95c-4d8b-8a99-c9c568d83f53})",
      "format": ",.2af",
      "informat": "numeric",
      "lowestLevel": 0,
      "name": {
        "en": "avg_uniq_id"
      },
      "subtype": null,
      "type": "numeric",
      "created_at": "2024-05-20T12:44:23.163Z",
      "updated_at": "2024-05-20T13:29:37.273Z",
      "custom_metadata": null,
      "user_id": "34b22f36-4904-497f-8acf-b0ba1d7e83cb"
    }
  ]
}