with SeaTable and Columns Ai?
Builds a graph object from scratch and publishes it. See the documentation
Deletes a specific row from a specified table. See the documentation
Builds a graph object from a template and publishes it. See the documentation
The SeaTable API allows you to interact programmatically with SeaTable databases. With it, you can create, update, and delete records, rows, and columns, manipulate tables, and manage users. In Pipedream, you can harness this API to automate data flows between SeaTable and other apps, trigger workflows based on changes in your SeaTable bases, and manipulate data without manual intervention. Think of it as connecting your spreadsheets' data to the wider web.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
seatable: {
type: "app",
app: "seatable",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://cloud.seatable.io/api2/account/info/`,
headers: {
Authorization: `Bearer ${this.seatable.$auth.account_token}`,
},
})
},
})
import { ChartType } from 'columns-graph-model';
import { Columns } from 'columns-sdk';
export default defineComponent({
props: {
columns_ai: {
type: "app",
app: "columns_ai",
}
},
async run({steps, $}) {
const rows = [{
"value": 312,
"state": "WA",
"parent": "US"
}];// rows is an example data set where you should organize your data in a similar way.
//Instantiates a Columns SDK object with your API Key.
const columns = new Columns(this.columns_ai.$auth.api_key);
const data = columns.data(['state'], ['value'], rows);
const graph = columns.graph(data);
// switch to different chart types: BAR, PIE, DOUGHGUT, LINE, AREA, SCATTER, etc.
graph.type = ChartType.COLUMN;
// customise the graph (lots of options in its data model)
graph.settings.general.palette = ['#ff0000', '#00ff00', '#0000ff'];
graph.settings.general.background = '#00000002';
return graph;
},
})