< Back

Update-Record

Sun Jan 19, 2020 5:57 pm

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