Repository navigation
Passing query result to next action? #18
Description
I am trying to integrate sql query in my Orquestra workflow:
--
version: 1.0
name: Daily report
description: Get daily stats
tasks:
task1:
action: sql.query
input:
connection: my_conn
query: "SELECT ...
<long running query>
"
next:
publish: data="<% result() %>"
do: task2
task2:
action: "reports.act1"
input:
data: "<% ctx(data) %>"
And I get error:
errors:
- message: The spec is not type of list.
What gives?
act1 is just a simple python action which accepts data parameter and prints out its type and contents.
Activity
bishopbm1 commentedon Jan 25, 2022
Can you share what your action file looks like also can you share what the execution tree looks like? Also as a test if you take away task2 does it run successfully?
ShawnHardwick commentedon Mar 31, 2022
The
nextkey is expecting alist, not adict.https://docs.stackstorm.com/orquesta/languages/orquesta.html#task-transition-model
Note that I added a hyphen to the
publishstatement.