Insert 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

All fields defined in the schema must be present in the request payload. This condition holds regardless of whether the Value Required is set to true or not. If there’s no data available for a certain field on a record, send in a blank value.

Note

curl --location --request POST
'https://{instance_url}/api/v1/ingest/sources/ntotest/exercises_734a9fa2' \
--header 'Authorization: Bearer {access_token}' \
--header 'Content-Type: application/json' \
--data-raw '{
"data": [
{"maid":1,"first_name":"Rachel","last_name":"Rodriquez","email":"rachel@nto.com","gender":"Female","city":"New York City","state":"NY","created":"2020-04-27T02:48:33Z"}
]
}
'
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

{
"accepted": true
}

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.

Note