API call with more than 500 records

Hi,

I am recording customer contact details in our app and need to query database to send API call to sms provider for bulk SMS. SMS provider has limitations of maximum 500 record (contacts) per call.

Thus, I am creating a dashboard that queries contacts based on filters and send it via an API call.

e.g In case I have 25,000 record - How do I break it in multiple API calls of 500 each?

This will sort out lot of manual work being done right now.

Thanks in advance :slight_smile:

add multiple api call actions and specify like so:

call 1, only when list of numbers > 0. send to list items from #1 , items until #500.
call 2, only when list of numbers > 500. send to list items from #500 , items until #1000.
call 3, only when list of numbers > 1000. send to list items from #1000 , items until #1500.
and so onโ€ฆ

1 Like

Thanks jarrad - will try as you suggested. Is there a way I can do xml api call in bubble?

no worries, you should be able to change your api callโ€™s type to xml in the top right of the call setup area. then you can put xml in the post body.