Upsert a Data Service Entity Record

Upsert a Data Service Entity Record

Upsert a Data Service entity record by a unique key field.

1. Run a structured query against the entity for a record where the key field equals the supplied value, returning at most one match.
2. Update the matched record by its ID with the supplied field values.
3. Create a new entity record with the supplied field values when no existing record matched the key value.

What you'll need to have ready

• entityName: Name of the custom entity type as defined in the tenant schema.
• keyField: Field name used to detect an existing record (e.g. Email).
• keyValue: Value of the key field to match on.
• fields: Map of field name/value pairs to write to the record.

For your developer

Arazzo workflow uipath:upsert-entity-record, 3 operations: queryEntityRecords → updateEntityRecord → createEntityRecord. Specs on APIs.io.