This article is for the latest version of the Flatfile Data Exchange Platform.
Flatfile offers a custom query language that can be used to filter data in sheets, allowing for you to quickly and painlessly get to the specific records you need to review.
We offer an in-depth overview of how to compose your queries in our developer documentation here. Check it out!
When you're in your space, you will be able to access the search bar by clicking on the magnifying glass icon to the top left of your sheet. This will expand the search bar and allow you to start composing your query.
In the search bar, all queries should start with the filter: operator, and can search on the full table or a specific column
//To search across all fields and columns for a record that equals the word "Bender"
filter: eq Bender
//To search in the "First Name" field for a record containing the word "Bender"
filter: "First Name" like "%Bender%"
Flatfile's Query Language can also be used via the API using our Get Records endpoint, and an example of how to do that is located here in our documentation.
Things to be aware of:
searches must be composed on a sheet-level, meaning you will not be able to compose searches across multiple sheets in your workbook from this search bar.
the
eqoperator is case-sensitive, so searches should take that into consideration.