Batch macro Setup

[akvsachin]

Hi I'm stuck at the point. I need my api, key and secret to run for multiple ids with an access token for those api to fetch the workflows name/id those Collection_Ids are associated with.
That would be needed to done iteratively through batch macro, but how to use those id in formula tool in batch macro workflow.

Batch Macro Text Input Tool : URL, KEY, SECRET
Batch Macro Input Anchor : ID, OWNER_ID, DATE_MODIFIED, C_ID(Grouped By)
Batch Macro Formula Tool : I need is URL/ID/

[atcodedog05]

Hi @akvsachin 

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

Hope this helps : )

[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

[atcodedog05]

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 😂

[akvsachin]

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 ?

[atcodedog05]

Hi @akvsachin 

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.

[akvsachin]

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.

[atcodedog05 · Accepted solution]

Hi @akvsachin 

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)

The approach you are trying to use is very complicated 😅

[atcodedog05]

Happy to help : ) @akvsachin 

Cheers and have a nice day!

[akvsachin]

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)