It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Introducing Trellinator: Automate Trello with Google Apps Script

37 comments

Iain Dooley Community Leader Nov 19, 2019

@Camiel_Wieme_SA the error "Getting Trello member ID invalid token" means that you haven't pasted your api key and token properly into the configuration sheet. The rest of the errors are caused by that as well.

Hi Ian, 

Thanks for helping out. 

I managed to get the helloWorld script working.

Now I'm trying to move on, but it has been a while since I did some programming in Java(script). Are there anymore example of functions and stuff?

I would like to create a script that count the cards with a specific label in a pipeline. So if a pipeline has 5 cards with label "must" and 3 with "nice", I would like to automatically create a card with a sort of report saying:

Must : 5 

Nice: 3

The trigger can be adding a new card or preferably a Butler Board Button. 

Hopefully you can help me again. 

 

regards, 

 

Camiel 

Iain Dooley Community Leader Nov 20, 2019

@Camiel_Wieme_SA firstly if you want to trigger this with a butler board button, then you'll maybe need to add a label using the button then use that as the trigger to execute your function (then you can remove the label from the function to reset it). You could also use the ExecutionQueue to do a recurring trigger in Trellinator:

https://www.theprocedurepeople.com/trellinator-automate-trello/docs/module-TrellinatorCore.ExecutionQueue.html

There's a reference API for Trellinator:

https://www.theprocedurepeople.com/trellinator-automate-trello/docs/

But if you want to get a feel for how to solve typical problems and a sense of "idiomatic" Trellinator with lots of examples just browse through all the gists I've made while posting comments here on the community, there are hundreds of examples:

https://gist.github.com/iaindooley

With the combination of those examples and the reference documentation you should be able to get a handle on it.

To give you a head start the function to do what you want executed hourly would look like this:

https://gist.github.com/iaindooley/adcdbcda0eaf4c634b9bf4127f445f88

Hi there!

@Iain Dooley listen, I'm facing a bit of trouble with a new installation, followed exactly your steps here but keep getting an unknown error, look:

["helloWorld executing from queue...","Error executing function: Exception: Invalid argument: https://api.trello.com/1/tokens/58397c7961017570ed9127475e7055da397cbe3c29e21d06bf9fc71c83e3d0fd\r/member?key=d7678894c4045f2aa42e6e9c81f3e541&token=58397c7961017570ed9127475e7055da397cbe3c29e21d06bf9fc71c83e3d0fd","helloWorld executing from queue...","Error executing function: Exception: Invalid argument: https://api.trello.com/1/tokens/58397c7961017570ed9127475e7055da397cbe3c29e21d06bf9fc71c83e3d0fd\r/member?key=d7678894c4045f2aa42e6e9c81f3e541&token=58397c7961017570ed9127475e7055da397cbe3c29e21d06bf9fc71c83e3d0fd"]

This invalid argument is troubling me. Can you shed any light?

Ian, I can't get it to work with a new account. It says invalid argument to very request, even the simplest one, this Hello World example you posted here. Can you help? 

@Lucas Fogolin see that "\r" at the end of the token before "/member" in the URL? My guess is wherever you copied the token from snuck a carriage return in there, you just need to delete that from the configuration tab

@Iain Dooley actually no, there's no '\' in any part of the key nor the token, but doing some digging In this new account, I realized that,different from my previous one, when I generate the API key the whitelisted URLs do not have the wildcard "*" and I can't add it there. Would, maybe its something to do with this issue? I took a print:
trello.png

Iain Dooley Community Leader Nov 28, 2019

@Lucas Fogolin that origins thing is only for OAuth2 authorisation flows afaik. It's not relevant to Trellinator setup, I've never used it before. Have a look at this screenshot:

2019-11-29 at 10.35 am.png

Yes, I understand what you're saying, but I've checked the keys and they don t have this added there, no '\r'. I've  tried twice, following the setup here from scratch, but it generated the same results both times. Won't you try it from scratch with a new account just so you can see what I'm talking about?

Iain Dooley Community Leader Nov 28, 2019

@Lucas Fogolin I've set it up from scratch like 6 times today ;) If you share your spreadsheet with iain@benkoboard.com I can take a look for you

Dear Colleagues, when I try to Initialize utilities I have to give permissions to App, and then I receive notification "sign in with Google is temporarily disabled for that app. This ass has not yet been verified yes with Googe..." Same warning I receive when I publish script as an app.... 

Had anyone experienced that?

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Distribute and track teams' work in a smart way and gain visibility

  Plan and track how teams spend their time and effort may represent a rocket science for many team leaders. Not rarely they need to deal with a considerable amount of variables to “hit the tar...

94 views 0 2
Read article

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