Build a batch macro that runs for each value in a field

Hi everyone!

I am trying to build a batch macro that is updated with a value from an excel file but I dont know how it is done...

Just as "simple" as this... hehe

Inside the macro

I have previously done batch macros updating a file but never cells in a field... (in this example only two values but it is expected to be hundreds)

Then it call an API, thats why I need a Batch macro (not related with the issue)

Thanks!

Custom Tools

Macros

Batch Macro

Help

Accepted answers

jbqrn

Hi @danilang it is true that the API makes single calls but in my case I needed that the workflow works as a Batch macro because of the way it is designed.

I finally reached this solution:

update the value CIF inside the API to use the values in the excel that I load.

Thanks!

All comments

Qiu

@jbqrn
Can you give us sample input and output for use to better understand the issue?

jbqrn

Hi @Qiu

I want to introduce several rows in a batch macro to make one call to an API for each row.

Data INPUT:

NIF

A123456789

B123456789

C987654321

With these values added to an excel, I want to make the call (I realized that it is not necessary the APPEND FIELDS tool if I do a macro)

I need that data contained in the column [NIF] to be updated each time the macro runs.

1st run: call API with A123456789

2nd run: call API with B123456789

3rd run: call API with C987654321

And so on...

Is it clear now? If there is any doubt ask me!

Thank you!

jbqrn

Hi @danilang it is true that the API makes single calls but in my case I needed that the workflow works as a Batch macro because of the way it is designed.

I finally reached this solution:

update the value CIF inside the API to use the values in the excel that I load.

Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703