Unanswered

Improve response time from API call

(0) Share

Report

Posted on by MikeAA

Hi everybody. In my power automate flow I need to call an external API. As you can see in the pictures, the API call is made for each symbol in an Apply to each loop. The results of that API call are emptied into a Dataverse table where the fields are filled according to the condition of each symbol. The answers are different according to the established condition.

In a request of approximately 250 symbols the flow can take between 4 to 7 minutes.

Is there a way to make the flow much faster? Thanks in advance.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Linn Zaw Win 2,996 on at

Like (0)

Report
Copy link

Link copied!

By any chance, filling up the answer fields for those ~250 records be independent and can this Apply to Each run in parallel? If so, you can turn Concurrency control of the Apply to Each step to On and provide Degree of Parallelism as mentioned in the blog post below.
https://www.c-sharpcorner.com/article/understand-concurrency-control-in-apply-to-each-loop-in-power-automate/

If it cannot run in parallel, one of the things that you can do it to retrieve all the unique symbols from the external API call and cache it in an object array variable. Then, in the Apply to Each loop, retrieve the data from the cached array by Filter.

Was this reply helpful? Yes No
MikeAA 42 on at

Like (0)

Report
Copy link

Link copied!

Hi @LinnZawWin effectively, the Apply to each loop has the concurrency condition applied.

I show the screenshot for the Apply to each loop and the conditions applied in the API call

Thanks

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report
Copy link

Link copied!

Apply to each loop has the concurrency condition applied with max 50 Degree of Parallelism, I don't think you can optimise further in that part.

So, let's talk about option 2, out of ~250 records, how many symbol values are unique? If there are a lot of duplicate records, you can retrieve all the unique symbols from the external API call and cache those in an object array variable. Then, in the Apply to Each loop, retrieve the data from the cached array by Filter.

Was this reply helpful? Yes No
MikeAA 42 on at

Like (0)

Report
Copy link

Link copied!

how many symbol values are unique? Everyone is unique

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report
Copy link

Link copied!

In that case, I don't see any room for optimisation unless one more operation can be added to the external API to allow the bulk request with all symbol values.

Was this reply helpful? Yes No
MikeAA 42 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for your responses

Was this reply helpful? Yes No