Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,557
Community Members
 
Community Events
165
Community Groups

Read from an external data source, even a CSV or Excel file

We would like the ability to read from an external data source, and add a selected value to a Trello custom field.  Say, a list of customers from our legacy ERP, so we can add standard fields like customer number or even customer name to the card.  There are restrictions in access the SQL data directly, so we could even do a nightly data dump to update a lookup table. 

Thoughts?  

1 answer

@Ron McClellan 

Trello provide a http request action to do just that. It returns a response via {httpresponse}. 
see

https://help.trello.com/article/1203-issuing-http-requests-with-butler

I used with py-Trello which will allow me to work with my cards directly like custom fields. 

But, will this let us search the external data source?  For example, In Field "Customer Name", search for customers that begin with "ABC", show ABC Co, ABC Inc, ABC Partners, select the name we want, and fill multiple fields on the Trello card.

@Ron McClellan 

The http request calls an endpoint and returns the result to Butler. At the endpoint, depending on your platform you can do all the data retrieval and manipulation you need. It can even call Zapier and use python programs to retrieve the data. I used py-trello because it has all the capabilities to work with all the components of a card like labels, custom fields, checklist etc. Unlike power up and I include custom power, it is not interactive aka it cannot , as far as I am aware, present you with a dropdown list for you to select. 

I used http request to provide a Butler add on for things you cannot do with automation natively e.g. return CF following a lookup of a card. 

My profile has my contact details should you want to have a chat.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Trello

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend  B...

2,361 views 28 40
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you