Upsert Records

Load new objects and update existing objects into your Data Cloud data lake table.

URI

/api/v1/ingest/sources/{name}/{object-name}

Available since release

Data Cloud v1.0, Salesforce v51.0

Formats

JSON

HTTP methods

POST

Authentication

Authorization: Bearer {access_token}

Request body

You can perform partial updates on records. To update a previously ingested record using streaming Ingestion API, include the record’s Primary Key in your request, provide a value for the Record Modified field, and specify the fields that need updating. Data Cloud updates only the fields included in the payload and leaves the other fields unchanged as long as the value of the Record Modified field is more recent than the current value. To enable Partial Record Updates for a data stream, select Partial from the Refresh Mode menu available when creating a Data Stream of type Profile or Other.
Request parameters

Parameter Description
Content-Type application/json
name Name of the Ingest API data connector.
object-name Name of the object configured in Ingest API data connector for payload.
Response body

Returns a status code of 202 (Accepted), which indicates that the request is accepted and gets processed asynchronously.

For more information on status codes, refer to Status Codes and Error Responses section in Get Started with Ingestion API.