with Trello and Columns Ai?
Builds a graph object from scratch and publishes it. See the documentation
Builds a graph object from a template and publishes it. See the documentation
Trello's API lets you craft workflows around managing boards, lists, cards, and users. With Pipedream, you can automate Trello tasks, like syncing cards with external databases, updating checklists, and posting notifications to other platforms. It enables seamless connection with other apps, fostering productivity by automating routine board operations, card management, and team notifications.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
trello: {
type: "app",
app: "trello",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.trello.com/1/members/me`,
}, {
token: {
key: this.trello.$auth.oauth_access_token,
secret: this.trello.$auth.oauth_refresh_token,
},
oauthSignerUri: this.trello.$auth.oauth_signer_uri,
})
},
})
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;
},
})