Skip to main content
Solved

Retrieve all data from table without any filters

M

I am trying to retrieve all records from a table. The master view has filters on it that have to stay there for other business users, but I would like to retrieve all records without the filters with the API. More specifically, the table is filtered to records added in the last week, but I need all of the records from the beginning of the table.

Is there a way to use the API to get all records even if the table in the browser has filters on it?

Best answer by cor

Sure - just dont include the view in the parameters. This will only respond with 100 records at a time but you can use offset and basic pagination to access all records.

View original
Did this topic help you find an answer to your question?

2 replies

C
  • cor
  • Inspiring
  • 52 replies
  • Answer
  • June 3, 2020

Sure - just dont include the view in the parameters. This will only respond with 100 records at a time but you can use offset and basic pagination to access all records.

kuovonne
1 person likes this
  • kuovonne
    kuovonne
M
  • Mark_Hamilton
  • Author
  • New Participant
  • 1 reply
  • June 3, 2020

Your solution was correct, thank you! I found out that the error was in the data table itself.

C
1 person likes this

Reply


Most helpful members this week

Terms & Conditions