Datamart Query Data Example

This example shows how the datamart_query_data tool retrieves the last 10 transactions from a Datamart. It includes the prompt, request, and response.

Prompt

Can you list the last 10 transactions from "Standard_Sales_Data"?

Request

JSON
{
  "uniqueName": "Standard_Sales_Data",
  "queryColumns": [
    "DocumentId",
    "DocumentLineId",
    "CustomerName",
    "ProductId",
    "ProductName",
    "Quantity",
    "InvoicePrice",
    "PricingDate"
  ],
  "limit": 10,
  "dateColumnName": "PricingDate",
  "startDateOperator": "lessOrEqual",
  "startDate": "2026-09-09"
}

Response

Here are the last 10 transactions (most recent by Pricing Date, 2025-12-31) in Standard_Sales_Data:

Customer

Product

Pricing Date

Invoice Price

Quantity

Lakers Industrial Distributor (CID-0098)

BN1350M2

2025-12-31

$2,468.81

5

Lakers Industrial Distributor (CID-0098)

MEG5220-6033

2025-12-31

$52.98

5

Lakers Industrial Distributor (CID-0098)

MEG5220-6036

2025-12-31

$79.04

5

Milo H (CID-0070)

CN9789

2025-12-31

$548.60

2

Milo H (CID-0070)

A9N2103

2025-12-31

$485.95

2

SO Company Inc UK Global customer Paddington (CID-0031)

R9H13603

2025-12-31

$197.68

2

SO Company Inc UK Global customer Paddington (CID-0031)

TR47513

2025-12-31

$547.81

2

Gabe Corporation (CID-0037)

IMT80020

2025-12-31

$6.14

2

Gabe Corporation (CID-0037)

MEG5220-6033

2025-12-31

$7.72

1

Gabe Corporation (CID-0037)

R9H13601

2025-12-31

$46.17

2

truncated: true (10 rows returned == max_rows; more transactions on 2025-12-31 or earlier may exist)