I have built a flow where I have 2 questions.
I am pulling data from an API where 1 query parameter is changing with all the requests, since I was not able to find any solution to use 1 pull from API for 8 api calls with 1 changing query parameter, I have to use 8 different API calls right now, is there any solution for this?
Basically what I am trying to do is pull product-level data from API where it gives me a days data for product quantity and add that to sheets where I want to record day by day product quantity data in the same sheet. EX:
Product_name Qty-Sep-2 Qty-Sep-3 Qty-Sep-4 etc. (screenshot attached)
I am not able to figure this out that how can I use the same sheet to lookup the product id and create a new row for the new days updated quantity against that product id.
I guess I can do this with combine tables where 1 table would be my existing sheet data and another source would be pull data from API. But since right now I have 8 different pull from APIs so just can not figure out how to achieve this.
my current flow:
Would appreciate any help.