Hi,
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?