Update-SAPByDesign Cmdlet
Updates SAP ByDesign data.
Syntax
Update-SAPByDesign [parameters]
Remarks
The Update-SAPByDesign cmdlet allows you to use a syntax similar to SQL UPDATE statements to update SAP ByDesign data.
$conn = Connect-SAPByDesign -URL 'https://my999999.businessbydesign.cloud.sap' -User 'username' -Password 'password' -ServiceType 'AnalyticsService' -ServiceName 'servicename'
Update-SAPByDesign -Connection $conn -Table "Account" -Columns @("Name") -Values @("Jon Doe") -Id "1"
The Where parameter can also be used to specify the primary key of the table:
Update-SAPByDesign -Connection $conn -Table "Account" -Columns @("Name") -Values @("Jon Doe") -Where "Id = '1'"
The primary key can also be passed to the cmdlet along the pipeline:
Select-SAPByDesign -Connection $conn -Table Account -Where "Industry = 'Floppy Disks'" | Update-SAPByDesign -Columns @("Industry") -Values @("Floppy Disks 2")