Class DataLibraryPowers

{TypeError} when reportKey is missing.

Getting data library report data from within your skill code

// Ensure you import DataLibraryPowers
import { DataLibraryPowers } from "@andi/powers";

// getting data library report rows assuming that data library report has these fields as header
type MyRow = {
    id: string;
    city: string;
    zip: string;
};
const rows = await DataLibraryPowers.get<MyRow>("my-test-report-key");
// access first row
const id = rows[0].id;

// get data library report rows as dynamic type and then refer a particular column that may have space in it's name
const rows = await DataLibraryPowers.get<any>("my-test-report-key");
* // access first row
const data = rows[0]["my column name"];

{TypeError} when reportKey is missing.

{TypeError} when searchOptions is missing.

Searching data library report rows from within a skill code

// Ensure you import DataLibraryPowers
import { DataLibraryPowers, Condition, Operator } from "@andi/powers";

// searching data library report rows assuming that data library report has these fields as header
type MyRow = {
    id: string;
    city: string;
    zip: string;
};
const condition: Condition = { key: "zip", operator: Operator.Equals, value: "34609" };
const searchOptions: SearchOptions = { where: condition };
const rows = await DataLibraryPowers.search<MyRow>("my-test-report-key", searchOptions);
// access first row assuming search criteria returned data so that rows.length is greater than 0
const id = rows[0].id;

// assuming data library report has these headers : "rateType", "rate", "region name"
const condition: Condition = { key: "region name", operator: Operator.Equals, value: "FL" };
const searchOptions: SearchOptions = { where: condition, select: ["rateType", "region name"]};
const results = await DataLibraryPowers.search<any>("my-test-report-key", searchOptions);
// your results array will look like [{"rateType": "floating", "region name": "FL"}, {rateType: "fixed", "region name": "NC"}]
// access first row assuming search criteria returned data so that results.length is greater than 0
const data = results[0]["region name"];