I have a Trello node that needs data from 2 different sources. The first one is a checklist ID within Trello. The second a list of calendar entries from Google Calendar that will get inserted into the specified checklist as checklist items. The checklist will be in a different card everyday, so the checklist ID needs to be passed in as a parameter.
What is the error message (if any)?
ERROR: Invalid expression under ‘Checklist ID’
The expression uses data in the node ‘Trello’ but there is no path back to it. Please check this node is connected to it (there can be other nodes in between).
@ckmoocow , does your “Trello” node ever get executed? The “Trello1” is set to use output of “Trello”. However, that cannot happen with your current workflow. The error you see is well justified.
To trigger execution of “Trello” node you can use Merge node as depicted below (just a fragment of the workflow to make my point clearer).
The configuration of Merge node depends on the data coming from Sort node (whether it outputs just one item or many).
Also note that if Sort node does not produce any data, “Trello” node will not run either. Conversely, if Sort node has an output, that will trigger execution of “Trello” node too (by means of Merge node engagement).
I’ve modified my workflow to include the merge, but I’m getting an error with the merge. What settings should I set on the Merge node so that I can still access data from Input 1 and Input 2?
I want the checklist ID to create checklistitems to come from Input 2 of the Merge
{{ $(‘Trello1’).item.json.id }})
and the data to be written in each checklistitem to come from the Input 1 calendar entries:
@ckmoocow , another role of Merge node is to prepare the combination of data you need for your final Trello call. You have not configured Merge1 node for that task. Once you done it right, you do not need to use data from nodes engaged prior to Merge1.
I’m guessing here as I have never worked with Calendar and Trello nodes and, hence, not sure what their output looks like. However, I think the below example can help you to finish building this workflow successfully.
I use Multiplex mode in Merge assuming you have 1 checklist ID from Trello and a few Calendar items to be added to the checklist. Multiplex provides a combination of items where each Calendar item is combined with the checklist ID. As a result, your checklist will be populated with the Calendar items.
