Need help with sending req to API mutliple times

How To
, , , ,
1

So I’m using HTTP to get data from API.

I have 300 accounts in that API. The API limit is 100 at a time.

This is my scenario:

HTTP (Get data from API) > Paste the data into google sheet.

I’m looking for a thing, after google sheet - it will send req to API again until all the data is fetched/written in google sheet.

What’s the best way to do it?

I’m using smartlead API to get my account data.

Check API documentation here
Check API Limit here

image
image757×498 51.3 KB

This is what it looks like at the moment. I’m doing each req with a 100 limit.

Right now I have done a total of 400, but in the future, it might be 1000 data I need.

I need the dynamic lopping mechanism if we can do it.

3

You can use a repeater to repeat the HTTP module 3 times:

Screenshot_2023-11-27_121146

Start from 0, and increment by 100

Screenshot_2023-11-27_121156

In the HTTP module, your offset parameter is set to the repeater value.

Screenshot_2023-11-27_121143

The repeater goes here

02ecfabd25188374ebbac7e3402e9c930fd45875
02ecfabd25188374ebbac7e3402e9c930fd45875757×498 52.2 KB

You can delete the additional routes.

3 Likes
4

image
image737×810 44.4 KB

Should I remove the offset and limit from HTTP req?

5

No, see my third screenshot.

1 Like
6

I have been trying to figure this out for the last 3 days.

You’re a life saver brother @samliew

I know that you have mentioned learning make.com from make.com academy.

I’m just curious where did you learn make.com and how much exp you?

The reason I asked cuz I’m impressed by your answer.

Once again thank you so much :pray::pray:

2 Likes
7

No problem, glad I could help!

In future, please create a new thread for each question. This makes it easier for others with the same problem to search for the answer. Thank you for your cooperation!

The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

  • others can save time when catching up with the latest activity here, and
  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

I learnt everything about Make from the Make Help Center. I also did the tutorials in the Make Academy, and completed the Make Partner Training.

I just got started with Make in August this year – you just gotta set aside some time to learn all there is from the links above!

4 Likes