How can I apply filters on paginated rest api

I need help applying table filters to a paginated REST API.
I have a REST API: “http://ip/records?page=1” This paginated API shows data without any filters initially and works fine on tables.

Now I want to filter the data. My API takes parameters like:
Let's say I want to show names that contain 'John', then my API call will be “http://ip/records?page=1&name=john”.

How can I get the column “name” and value “John” in Retool, so Retool can hit the API with these filters and show the data in tables?
I am using pageInput component for pagination.
Is this possible? If so, how can I do that?

Hi @Awais_Tahir, you could use a Text input component if you would like to take user input for the url params.

Here is a REST API with "page" and "name" url params and the value is set dynamically to the different inputs we have:

The endpoint I used just sends back the request:

As we can see, key-value pairs are part of the url.

@Paulo Thank you for response. I was looking for this

You are welcome! :slightly_smiling_face: