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
{
"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)