topic Re: Returning a result from a callable recipe in Workato Pros Discussion Board

Returning a result from a callable recipe

edward-abrahams — Thu, 23 Dec 2021 18:41:17 GMT

Hey all, wondering if I could get some advice on using callable recipes. I've set one up where my result schema is a single object. I then have a Python script that also outputs an object (also defined in the Workato schema.) Problem is, when I try and set the result, I can't pick anything. See here:

I can't quite get my head around why it won't accept it seeing as it's all the same type. Any ideas?

Edit: I've found if I change the input schema to text, it will let me pick the data, seems to be the type causing the problem

Re: Returning a result from a callable recipe

kobi-sh — Thu, 23 Dec 2021 18:50:27 GMT

Hi, you need to change it from Text to Formula.

Then you'll be able to map "Data" to "Data".

Re: Returning a result from a callable recipe

edward-abrahams — Thu, 23 Dec 2021 18:55:09 GMT

Thanks Jacob Shmerkovich - that was my first thought, but the "Return" action doesn't give me the option to switch between text and formula

Re: Returning a result from a callable recipe

kkrivonos — Thu, 23 Dec 2021 18:56:48 GMT

Edward, just select the "Data" on the left side and drag it into "Data" to the right. You can drag the selection although there is no datapill shown!

Re: Returning a result from a callable recipe

roland-daane — Thu, 23 Dec 2021 19:38:03 GMT

Can you share the return snippet in the Python code?

Re: Returning a result from a callable recipe

edward-abrahams — Thu, 23 Dec 2021 19:40:14 GMT

This doesn't work for me, I can drag it like you've shown, but it doesn't do anything

Re: Returning a result from a callable recipe

edward-abrahams — Thu, 23 Dec 2021 19:41:39 GMT

Hi Roland, sure:

return {"data": {input["inspection_doc"]["audit_id"]: question_ref}}

question_ref is an array, input["inspection_doc"]["audit_id"] is a string so the output is soemthing like:

{"data": { "audit_123": []}}

Re: Returning a result from a callable recipe

roland-daane — Thu, 23 Dec 2021 21:56:13 GMT

Hi,
I thought I’d just play around a bit, because this is definitely something I’ll be using…..
but just a little python script won’t run….and the 2 examlpes in the Workato help also don’t work….

Re: Returning a result from a callable recipe

james-ng — Thu, 23 Dec 2021 22:10:56 GMT

hi, would you share the recipe?

Re: Returning a result from a callable recipe

edward-abrahams — Thu, 23 Dec 2021 22:26:21 GMT

Hi James, sure you should be able to access it here: https://app.workato.com/recipes/1959329?st=e6daac

Re: Returning a result from a callable recipe

edward-abrahams — Thu, 23 Dec 2021 22:26:56 GMT

It uses a custom connector as we're currently rolling out Workato so not sure if you'll be able to access it properly.

Re: Returning a result from a callable recipe

edward-abrahams — Thu, 23 Dec 2021 22:37:48 GMT

Thanks for the link. I had a look and it's because your Python script isn't taking any input. Your script needs to be in a function called main that has input as its parameter. If you change your script to this:

def main(input):

return {"parmRerurn": "Hello World!"}

It'll work fine - even though you haven't defined any inputs, it still passes it to the main function causing the error. Anything you want to get out, needs to be passed to the returned dictionary, named with whatever is in your schema. The inputs go into the input dict so you could reference those if needed.

Re: Returning a result from a callable recipe

tara1 — Tue, 28 Dec 2021 21:34:06 GMT

Edward Abrahamsen-Mills I'm following the progress of this thread, so if you vaildate the fix, could you please confirm it here? Many thanks!

Re: Returning a result from a callable recipe

edward-abrahams — Tue, 04 Jan 2022 22:56:38 GMT

Hi Tara, I am yet to resolve this issue however I'll definitely share the solution if I find one!