Find-Record

NAME Find-Record



SYNOPSIS

Queries an AirTable table for one or more records.





SYNTAX

Find-Record [-BaseIdentity] <String> [-Table] <String> [[-FilterFormula] <String>] [[-View] <String>]

[[-MaxRecords] <Int32>] [[-SortDirection] <String>] [[-SortField] <String>] [<CommonParameters>]





DESCRIPTION





PARAMETERS

-BaseIdentity <String>



Required? true

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Table <String>

A string value representing the AirTable table containing the records to query.



Required? true

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



-FilterFormula <String>

A string value representing an AirTable-specific filter to limit the number of records returned. For

full explanation of this query language, refer to

https://support.airtable.com/hc/en-us/a ... -reference.



Required? false

Position? 3

Default value

Accept pipeline input? false

Accept wildcard characters? false



-View <String>

An optional string parameter representing a table view to limit results to.



Required? false

Position? 4

Default value

Accept pipeline input? false

Accept wildcard characters? false



-MaxRecords <Int32>



Required? false

Position? 5

Default value 100

Accept pipeline input? false

Accept wildcard characters? false



-SortDirection <String>



Required? false

Position? 6

Default value

Accept pipeline input? false

Accept wildcard characters? false



-SortField <String>



Required? false

Position? 7

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS

pscustomobject





-------------------------- EXAMPLE 1 --------------------------



PS>Find-Record -BaseName foo -Table bar



Returns all records in the bar table within the foo base.









-------------------------- EXAMPLE 2 --------------------------



PS>Find-Record -BaseName foo -Table bar -FilterFormula '{Name}="adam"'



Returns all records in the bar table within the foo base that have a Name value of 'adam'.











RELATED LINKS