Add support for searching

[syrnick]

This is more of a heads up that we pushed out new API capabilities. Airtable/airtable.js@08e6e76

We now accept a formula to filter records and an array of fields/direction pairs to sort by.

The limit is deprecated in favor of pageSize and maxRecords.

[nesquena]

Nice! Had been hoping to see implement for a while, thanks!

[sbauch]

I'd be happy to work on this as I currently need this feature set.

@syrnick I'm having trouble finding docs on the formulas for filtering.

Something like Order > 4 is easy enough, but right now I'm looking to find multiple records by ID with one lookup.

So something like id IS rec12343 OR id IS rec56789 throws an error -

{
  "error": {
    "type": "INVALID_FILTER_BY_FORMULA",
    "message": "The formula for filtering records is invalid: please check your formula text."
  }
}

Where can I find the docs that dictate a valid formula?

[syrnick]

Here's a few pointers:
https://support.airtable.com/hc/en-us/articles/202576519-Guide-to-formula-lookup-count-and-rollup-fields

https://support.airtable.com/hc/en-us/articles/203255215-Formula-Field-Reference

You should also be able to do something like this

AND(RECORD_ID() = 'recXYZ1', RECORD_ID() = 'recXYZ2', RECORD_ID() = 'recXYZ3', RECORD_ID() = 'recXYZ4')

Depending on performance, we'll eventually add a separate endpoint for something like this or optimize this specific call or add a different operator to check record ID against an array.

[sbauch]

Great, thanks @syrnick

Looks like the official JS lib only checks that the formula is in fact a string and depends on the API for validating the formula itself, so I'll take that same approach here.

[syrnick]

This was done by @sbauch .