Insert Records

Load new objects into your Salesforce CDP data lake table.

All fields must be provided in the request payload as defined in the schema regardless of whether Value Required is true or not. The Value Required is applicable to the value of the fields only. We recommend entering a blank value for fields not set as required.

Note

Syntax

URI

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

Available since release

Salesforce CDP v1.0, Salesforce v51.0

Formats

JSON

HTTP methods

POST

Authentication

Authorization: Bearer access_token

Request body

1curl --location --request POST
2'https://{instance_url}/api/v1/sources/ntotest/exercises_734a9fa2' \
3--header 'Authorization: Bearer {access_token}' \
4--header 'Content-Type: application/json' \
5--data-raw '{
6"data": [
7{"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"}
8]
9}
10'

Request parameters

Parameter	Description
Content-Type	application/json
name	Name of the Ingest API data connector.
object-name	Name of the resource type to send to Salesforce CDP.

Response body

1{
2"accepted": true
3}

None. Returns a status code of 202 (Accepted), which indicates that Request was accepted and will be processed asynchronously.

Salesforce CDP API Developer Guide

Insert Records

Syntax