This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to figure out requirement for my project.
Based on feedback from the community, if it takes more than 230 seconds, it is better to use Durable function than using a regular HTTP Trigger.
My requirement is just pulling data from other third party API using HTTP, store data inside Azure SQL and use the data for reporting (Power BI) at the end.
Honestly, I am not sure how long it would take to pull data, but I guess I would just start with a safer (Durable function) approach.
So, I thought diving into Durable would be a better option. Is it?
From Youtube that I watched, it appears that it is more like "Http-based Async Long-running APIs" from scenarios of Durable function.
Am I on the right approach?
Thank you.
An Azure service that provides an event-driven serverless compute platform.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 87%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Hello @KingJava - You're absolutely on the right approach. Durable Functions is for long-running, stateful workflows and you can utilize the Function Chaining pattern to organize the workflow where each Activity can be: Pull data from API, load data to SQL, etc.
@Mike Urnun Thanks for your response.
I am actually still very lost on my architecture.
So, basically, I am trying to pull data from a third party thru web service only once day.
After discussing with my manager, I think I am currently leaning toward using Timer Trigger (due to smaller size of data) instead of using Durable, but if the coding is not too complicated, maybe using durable is not a bad idea.