Find Record
AI-generatedSummary
Find records in an AppSheet table
Inputs
- region — The AppSheet region domain to use in the API URL.
- tableName (required) — Name of the AppSheet table (URL-encoded if needed).
- selector — Enter a valid AppSheet selector expression (e.g., FILTER(People, [Age]>=21)). If provided, the "Records" input is ignored.
- records — Record must include the key field values of the record to read.
- options — Optional settings that apply to AppSheet requests.
Output shape
an array of record objects matching the selector
Returns the found records; shape may include additional metadata but is generally an array.
Examples
Example 1: Lookup a customer by email in the EU region
Region = eu.appsheet.com, Table Name = Customers, Selector = Email = $email
Example 2: Check if any order has status 'Pending'
Region = www.appsheet.com, Table Name = Orders, Selector = STATUS = 'Pending'
Example 3: Find all active users
Region = www.appsheet.com, Table Name = Users, Selector = STATUS = 'Active'