I want to write into excel when API Job status turn into "Completed"

I want to write into excel when the status changes into Completed what should be the condition for this and want to write in-process only once no matter how many times it loops.

If it breaks in middle the status should be In Process

MicrosoftTeams-image (52)

Hi @Bhushan_Nagaonkar ,

For understanding this, we would also require to have a view of the Steps done in your workflow. How is the Process implemented ?


This is the do while condition where it will run until the status turns into Completed

@Bhushan_Nagaonkar ,

We could use a counter variable for this case, as you are using the While loop activity. Create an integer variable called counter. Intialize it to 0 using an Assign Activity before the While loop Activity.

After the call to the API, Check if the counter =0 using an If Condition activity. Get the Status and update the Status in Excel/Datatable.

Increment the counter to counter+1 using an Assign Activity.

This should help to avoid multiple updation of In Process Status.

Let us know if you are able to implement this.

1 Like

Can you please show me in ss and I’m using do-while activity. Thanks

@Bhushan_Nagaonkar ,
The Outline should be in the below manner (Just the sequence and not the actual flow method)
image

Let us know if you are facing any issues and what exactly it is.

1 Like

Ok, I will let you know

1 Like

It worked Thankyou so much

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.