Search Column

LLM-friendly URL
POST
https://api.luzmo.com/0.1.0/column
API call form
Examples
List of examples
  • Get a column by ID
  • Get all columns from a dataset
  • Get the source name of a column
  • Get the column and its dataset
Description

Get all columns from a specific dataset. The jointype is set to inner to ensure that only columns from the specified dataset are returned.

Install
pip install luzmo-sdk
Example Request
Shell Node Java .NET Python PHP 
from luzmo.luzmo import Luzmo
client = Luzmo(
  "<your Luzmo API key>",
  "<your Luzmo API token>",
  "https://api.luzmo.com"
)

response = client.get("column",
  {
    "attributes": [
      "id",
      "name",
      "source_name",
      "expression"
    ],
    "include": [
      {
        "model": "Securable",
        "where": {
          "id": "<dataset_id>"
        },
        "attributes": [
          "id",
          "name",
          "source_sheet",
          "source_query"
        ],
        "jointype": "inner"
      }
    ]
  }
)
Open in API Form
Example Response
200
400
500
{
  "count": 4,
  "rows": [
    {
      "id": "cfc29a4a-c144-4ba3-9a0f-26a1da6a6994",
      "name": {
        "en": "Purchase value"
      },
      "source_name": "purchase_value",
      "expression": null,
      "securable": {
        "id": "807623f5-ac65-4022-bc87-595b412ce397",
        "name": {
          "en": "Orders dataset"
        },
        "source_sheet": "orders_table",
        "source_query": null
      }
    },
    {
      "id": "52595c8f-0220-4427-8253-f86df6fb1057",
      "name": {
        "en": "Card type"
      },
      "source_name": "card_type",
      "expression": null,
      "securable": {
        "id": "807623f5-ac65-4022-bc87-595b412ce397",
        "name": {
          "en": "Orders dataset"
        },
        "source_sheet": "orders_table",
        "source_query": null
      }
    },
    {
      "id": "52595c8f-0220-4427-8253-f86df6fb1057",
      "name": {
        "en": "Order datetime"
      },
      "source_name": "order_datetime",
      "expression": null,
      "securable": {
        "id": "807623f5-ac65-4022-bc87-595b412ce397",
        "name": {
          "en": "Orders dataset"
        },
        "source_sheet": "orders_table",
        "source_query": null
      }
    },
    {
      "id": "52595c8f-0220-4427-8253-f86df6fb1057",
      "name": {
        "en": "Purchase difference from target (Derived column)"
      },
      "source_name": null,
      "expression": "100 - {{807623f5-ac65-4022-bc87-595b412ce397:cfc29a4a-c144-4ba3-9a0f-26a1da6a6994}}",
      "securable": {
        "id": "807623f5-ac65-4022-bc87-595b412ce397",
        "name": {
          "en": "Orders dataset"
        },
        "source_sheet": "orders_table",
        "source_query": null
      }
    }
  ]
}