topic Re: Tutorials in Workato Pros Discussion Board

Tutorials

roland-daane — Tue, 02 Nov 2021 23:59:21 GMT

Hi, I'm looking for some tutorials bcause i'm running into some difficulties.

I need to loop through the output of a call,and for each project call one of the retrieved API endpoints.

For example in the attached output I pickup project Name (TEST 1 ISO Naming), and call the Issues api path (https://developer.api.autodesk.com/issues/v1/containers/00699bbc-ea32-4451-8bb9-6c8962ebfee3/issues)

I can't seem to get the creation of the list, and then pupulating the list and then in a for each call the retrieved API key

Re: Tutorials

mitchel — Wed, 03 Nov 2021 00:09:51 GMT

If the output of the call is always a similar data structure could you not provide an example json to workato's inbuilt json parser app?

Re: Tutorials

vishwanathgouri — Wed, 03 Nov 2021 00:10:21 GMT

Hi Roland can I know what errors did you get while creating the recipe

Re: Tutorials

anthony-oconnor — Wed, 03 Nov 2021 00:27:46 GMT

I don't think you want the second loop nested in the first one.

I think that's your only issue here?

Re: Tutorials

info — Wed, 03 Nov 2021 00:44:15 GMT

Hi Roland, probably you want to create the full list first. Afterwards, you can take the list and - while iterating through it - call the respective API endpoints (synchronously or asynchronously depending on your use case logic). Most likely, you will do that in a separate callable recipe to keep your logic simple and clean.

Additionally, your usage of batch operations needs a closer look. If you wish, we can have a talk about this and see, how your solution can look like. Kind regards, Gernot

Re: Tutorials

info — Wed, 03 Nov 2021 00:45:19 GMT

BTW: There is a product hour on Workato lists. It might be some years old but is still valid although the user interface new looks differently. But this does not matter.

Re: Tutorials

roland-daane — Wed, 03 Nov 2021 01:13:05 GMT

Thenks for all the help!

In Step 2 I grab all the project data.

Step 3 and 4 are a test to see if the call will produce data.

Step 5 is create repeater help list

Step 6 is the for each which runs in batches of 10

Step 7 acumulates the list from step 5 and takes Name and Link from step 2.

If I put this into Sharepoint, I see the same data for each for each loop.

(See attached images)

I did try the parse to Json but couldn't figure out what the document should be.....

Re: Tutorials

roland-daane — Wed, 03 Nov 2021 02:34:55 GMT

Vivek just pointed me in the direction that i can query the output of step 2 directly in a loop.

This works!