Create trello cards from SQL query

Question

Hello,

I would like to do as follows.

Given a sql query with two outputs, ID and Description, being able to create trello cards based on these two outputs where ID goes to Card Title and Description goes to Card Description.

If my query returns 10 records it should create 10 cards in a specific list of a trello board witch i would specify

Is this possible? Can anyone help me?

Thanks in advance.

marc -Collabello--Phase Locked- · Answer

Creating a card in Trello from SQL is entirely possible. I've worked at a similar problem: create a Trello card through the API from external data.

What you would need to do:

* Get a Trello API key.
* Get the board and list id's where you'd like your cards to appear.
* On the computer where you run the SQL query, create a script to capture the results of the query.
* Let the script post the captured results to the Trello API, using the API key for authentication.

Doing this requires some scripting/programming experience.

Mike_kuzrt1 · Answer

Hi Rita,

If you can combine those SQL queries, wherever you're running them, with the Trello API, you should certainly be able to pipe results from your first query to the Trello API call, which would be able to create those cards for you.

While we're not able to write the specific calls for you, our API is fully documented here, and is a great place to start: https://developers.trello.com