Unanswered

Improving performance on a "do until" http request

(0) Share

Report

Posted on by RIchRenshaw

Hi,

I'm relatively new to Power Automate so I really hope there is a method to improve the performance of a flow I have created.

Problem: I need to query an API for address data, this limits the results to 100 max. I need to loop over the results, using an offset until I reach the maximum, then return the full data set in a response.

My solution:

Receive http request

query address API

if <100 return result

else loop over results until I reach the desired amount - return result

It's all really contained in a "do until" function with some variables to control the offset & capture results

If there are <100 results performance is doable - usually ~2 seconds.

If there are more the performance suffers terribly - 2 minutes and over isn't uncommon. I need to get this under 30 seconds, ideally much less.

I'd really appreciate some input / different methods that will make this perform faster. I did browse for some solutions but nothing I read so far seems to fit my requirement 😞

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

fchopo 8,003 Moderator on at

Like (0)

Report

Hi @RIchRenshaw

Have you tried to activate "Pagination" in the HTTP action and define a threshold of items to return?

Hope that helps!

Ferran

Was this reply helpful? Yes No
RIchRenshaw 2 on at

Like (0)

Report
Hi thank you for the tip off, I want aware of that in settings! Will keep that in mind

Looking at the config and guidance - I would need a continuation token in the response, which I don't seem to have.

e.g
{ "header" : { "uri" : "https://api.os.uk/search/places/v1/postcode?postcode=example", "query" : "postcode=example", "offset" : 0, "totalresults" : 40, "format" : "JSON", "dataset" : "DPA", "lr" : "EN,CY", "maxresults" : 100, "epoch" : "97", "lastupdate" : "2022-12-16", "output_srs" : "EPSG:27700" }, "results" : [ { "DPA" : { "UPRN" : "", "UDPRN" : "", "ADDRESS" : "", "BUILDING_NUMBER" : "", "THOROUGHFARE_NAME" : "", "POST_TOWN" : "", "POSTCODE" : "", "RPC" : "", "X_COORDINATE" : , "Y_COORDINATE" : , "STATUS" : "", "LOGICAL_STATUS_CODE" : "", "CLASSIFICATION_CODE" : "", "CLASSIFICATION_CODE_DESCRIPTION" : "", "LOCAL_CUSTODIAN_CODE" : , "LOCAL_CUSTODIAN_CODE_DESCRIPTION" : "", "COUNTRY_CODE" : "", "COUNTRY_CODE_DESCRIPTION" : "", "POSTAL_ADDRESS_CODE" : "", "POSTAL_ADDRESS_CODE_DESCRIPTION" : "", "BLPU_STATE_CODE" : "", "BLPU_STATE_CODE_DESCRIPTION" : "", "TOPOGRAPHY_LAYER_TOID" : "", "LAST_UPDATE_DATE" : "", "ENTRY_DATE" : "", "BLPU_STATE_DATE" : "", "LANGUAGE" : "", "MATCH" : , "MATCH_DESCRIPTION" : "", "DELIVERY_POINT_SUFFIX" : "" } ...etc }] }

Was this reply helpful? Yes No