import { NdiClient } from "ndi-sdk";
const client = new NdiClient();
const workspaceId = "550e8400-e29b-41d4-a716-446655440001";
const answer = await client.tools.queryTables(workspaceId, {
paths: ["books/ledger.xlsx", "books/trial-balance.xlsx"],
query: "Which accounts increased more than 10 percent?",
});
console.log(answer.answer);
const sql = await fetch(`${process.env.NDI_BASE_URL}/v1/workspaces/${workspaceId}/tools/run-sql`, {
method: "POST",
headers: {
"X-API-Key": process.env.NDI_API_KEY ?? "",
"Content-Type": "application/json",
},
body: JSON.stringify({ sql: "SELECT account, amount FROM ledger LIMIT 20" }),
});
console.log(await sql.json());