Upsert
Insert or update rows, optionally deleting/zeroing ‘leftover’ rows.
Special support for UDEF, as well as optional extensive information return. Traveltransactionlog and WebHooks are supported NsApiSlow threshold: 5000 ms.
Headers
Convert string references and multi-language values into a specified language (iso2) code.
Convert string references and multi-language values into a specified language (iso2) code. Overrides Accept-Language value.
Number, date formatting in a specified culture (iso2 language) code. Partially overrides SO-Language/Accept-Language value. Ignored if no Language set.
Specify the timezone code that you would like date/time responses converted to.
The application token that identifies the partner app. Used when calling Online WebAPI from a server.
Query Parameters
Optional comma separated list of properties to include in the result. Other fields are then nulled out to reduce payload size: "Name,department,category". Default = show all fields.
Body
TableName, Columns, Keys, Data, NomatchAction, ReturnRowStatus
Upsert: Insert or update rows, optionally deleting/zeroing 'leftover' rows. Special support for UDEF, as well as optional extensive information return. Traveltransactionlog and WebHooks are supported
Response
OK
Information about the results of a mass-update operation Carrier object for MassOperationResult. Services for the MassOperationResult Carrier is available from the DatabaseTable Agent.
Did the operation succeed
Any message from the method, including timing data
Number of rows inserted
Number of rows updated
Number of rows deleted / zeroed
Array of statuses and primary keys for all rows that were specified. Populated if the 'ReturnRowStatus' parameter of 'Upsert' is set, otherwise null
Wraps a table right together with an explanatory reason. Code can indicate why access is restricted.
Field property dictionary mapping field names to field access rights.
Related topics
Working with UpsertUpsert Recent NavigationEnum UpsertNomatchActionEnum UpsertRowActionStatusDatabase mirroringTruncate