Help with woocommerce API

Hi, I’m not really new to bubble, but new on the forum, pleasure to meet you all.

I’m stuck with an API problem, the woocommerce API to be exact.
I manage to do my whole app (preparing order, stats) with it except one thing, having my orders “full” list. Apparently, woocommerce Api limitate the calls to 100 responses. And I can’t figure out how to use pagination. There is a “page” parameters (and per_page : with max 100)
page integer Current page of the collection. Default is 1.

I add the parameter in the API connector I also tried directly in the url… but finally I think I just do understand how to use it inside bubble.

My goal is to get a repeating group with “all my order → curently 9000+” → and mostly I need to be able to search in that list by order number or customer name.
(I tried … and failed, to get all orders from the API and fill in a Bubble data tab, but i would much prefer use an Api call. )
I’m fine with displaying only 100 orders, if I can search inside “all” (because I probably won’t use it to scroll down 9000 orders ah ah ^^

So If anyone have an idea how to achieve this ? :slight_smile:
:pray: :pray:

Woocommerce APi doc

UPDATE : I easily manage to make a search box out of an input, but I can only search among the 100 first orders (which is kind of stupid :slight_smile: )

Theo