Batch macro Setup

Have you used batch macro? If not, it's not a necessity for this use case. You can just attach the download tool after prep the data like below (attachment in the previous post)

Screenshot 2024-10-24 173219.png

The approach you are trying to use is very complicated 😅

All comments

You can prep the data before itself like below using append tool and later pass it through batch macro.

Screenshot 2024-10-24 164835.png

Hope this helps : )

Batch URL.yxmd

OllieClarke

@akvsachin
From your description, you may not need a batch macro. You can parameterise the download tool, so if you create these fields before hand, then you can just feed them through, no batch macro required

True, but maybe create batches of 25 or so (based on the download speed) and use batch macro so that workflow doesn't get stuck in perpetual running mode 😂

Hi @OllieClarke @atcodedog05

so, I'll describe my task.

That was to get the oauth2 token then through access token fetch the c_ids through /v3/c_id/ api endpoint.

Then I need to use /v3/c_ids/{Id} endpoint to have all workflow ids under the collection.
On the final output I need the collection name where applicable and null in case workflow is not assigned to any collection.

So, as iteration is required there, which could be done using control parameter, i.e., through batch macro setup.
Am I going the wrong road ?

Suggestion would be prep endpoints like above to pass through the download tool.

Batch macro is not mandatory you can directly use it to. But if the download is huge and slow it might impact the runtime of workflow. Hence, in that case you can batch endpoints into batch size of 10 (you need to select batch size which works best for you through trial and error).

This is suggested can improve the runtime speed if you run in chunks.

Hi @atcodedog05

there are 600+ records.

If you can please tell me how to proceed.
As I have all the records from /v3/c_id/ api endpoint, now I don't know how to proceed further

Please help me with this as I thought Batch macro would be the easiest way. WhatsApp Image 2024-10-24 at 17.25.31_4d49e387.jpg

Have you used batch macro? If not, it's not a necessity for this use case. You can just attach the download tool after prep the data like below (attachment in the previous post)

Screenshot 2024-10-24 173219.png

The approach you are trying to use is very complicated 😅

Hi @ atcodedog05

For every Collection ID there are numerous Workflow_ids and they are in numerous headers (workflowid_1, workflowid_2 .... workflowid_256).

How can I get them for one, so that I can generate a sheet by joining these workflow_ids(from c_id sheet) to ids ( workflow api endpoint sheet)

Although there are workflows with no Collection name and I need them as well.

Basically, the final output should be as workflow_ID, workflow_name, collection_name ( where null should be displayed as null)