I am very happy to build a workflow to fetch order api from selling platform and save it to database, and show it on the the chart component.
It's so awesome, This used to take a lot of time.
Here is my demo showing.
First, use a resetApi to get an Access Token
Get all order and iterate all pages(if exists NextToken) and put them in one array. You can define a sleep function here to slow down the query speed to pass rate limit for some selling platform.
Get all orderItem for the orders
What surprise me here is workflow support
Retry per literation which means if the query fails in that loop it will retry the single loop alone. it's so convinient.
add response block and save it to database
Click run workflow. And you can see in running time in run history
After the running is finish, all the data is upserted.
And the chart is automatically updated.
I could image what I can do with retool workflow in the future. it's so great tool. thanks.