< Back
Update-Record
Post
NAME Update-Record
SYNOPSIS
Updated an AirTable table record field value(s).
SYNTAX
Update-Record -Fields <Hashtable> [-PassThru] [-WhatIf] [-Confirm] [<CommonParameters>]
Update-Record -InputObject <PSObject> -Fields <Hashtable> [-PassThru] [-WhatIf] [-Confirm] [<CommonParameters>]
Update-Record -Id <String> -BaseIdentity <String> -Table <String> -Fields <Hashtable> [-PassThru] [-WhatIf]
[-Confirm] [<CommonParameters>]
DESCRIPTION
PARAMETERS
-InputObject <PSObject>
A pscustomobject value representing the record to update. This is typically used via the pipeline.
Required? true
Position? named
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false
-Id <String>
A string value representing the record ID of the record to update.
Required? true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-BaseIdentity <String>
Required? true
Position? named
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? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Fields <Hashtable>
A hashtable value representing all of the record's fields to update. Each key in the hashtable is the
field name and each corresponding value is the value to update the field to.
Required? true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-PassThru [<SwitchParameter>]
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Required? false
Position? named
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
void
-------------------------- EXAMPLE 1 --------------------------
PS>Find-Record -BaseName foo -Table bar -Name 'old' | Update-Record -Fields { 'Name' = 'new' }
Updates any records in the 'bar' table with a field Name value of 'old' to 'new'.
-------------------------- EXAMPLE 2 --------------------------
PS>Update-Record -BaseName foo -Table bar -Id recXXXXXXXXX -Fields { 'Name' = 'new' }
Updates any records in the 'bar' table with a field Name value of 'old' to 'new'.
RELATED LINKS
SYNOPSIS
Updated an AirTable table record field value(s).
SYNTAX
Update-Record -Fields <Hashtable> [-PassThru] [-WhatIf] [-Confirm] [<CommonParameters>]
Update-Record -InputObject <PSObject> -Fields <Hashtable> [-PassThru] [-WhatIf] [-Confirm] [<CommonParameters>]
Update-Record -Id <String> -BaseIdentity <String> -Table <String> -Fields <Hashtable> [-PassThru] [-WhatIf]
[-Confirm] [<CommonParameters>]
DESCRIPTION
PARAMETERS
-InputObject <PSObject>
A pscustomobject value representing the record to update. This is typically used via the pipeline.
Required? true
Position? named
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false
-Id <String>
A string value representing the record ID of the record to update.
Required? true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-BaseIdentity <String>
Required? true
Position? named
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? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Fields <Hashtable>
A hashtable value representing all of the record's fields to update. Each key in the hashtable is the
field name and each corresponding value is the value to update the field to.
Required? true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-PassThru [<SwitchParameter>]
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Required? false
Position? named
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
void
-------------------------- EXAMPLE 1 --------------------------
PS>Find-Record -BaseName foo -Table bar -Name 'old' | Update-Record -Fields { 'Name' = 'new' }
Updates any records in the 'bar' table with a field Name value of 'old' to 'new'.
-------------------------- EXAMPLE 2 --------------------------
PS>Update-Record -BaseName foo -Table bar -Id recXXXXXXXXX -Fields { 'Name' = 'new' }
Updates any records in the 'bar' table with a field Name value of 'old' to 'new'.
RELATED LINKS