SF Wave Upload
The SF Wave Upload activity is used for uploading data into Salesforce.com Einstein Analytics. It provides three operations Upsert, Append, and Overwrite.
Upsert - Inserts rows in a data set if the row does not exist or it updates the row if the row already exists. It creates a data set if the data set does not exist. Each row to be upserted can contain one (and only one) ID field as an unique identifier.
Append - Appends all data to the data set. Creates a data set if it does not exist.
Overwrite - Creates a data set with the given data. Replaces the data set if it exists.
Configuration
The Configuration tab has the following fields that identify which Salesforce.com connection to use and the type of object to create.
| Field | Description |
|---|---|
| Connection Name | Salesforce.com connection name. If you have created multiple Salesforce.com connections, select the one you want to use from the drop down menu for this field. |
| Operation | Select one of the following: Upsert, Append or Overwrite. |
| Metadata Json | Provide the metadata for the data that you would like to upload. Refer to the Salesforce documentation for details. |
Input
| Field | Description |
|---|---|
| Dataset | Name of the data set to which you want to upload the data |
| AppName | Name of the app in which the data set exists or needs to be created. This app must exist in Salesforce.com Einstein Analytics. |
| Records | Array of records. Each record contains fields available in the metadata.json |
Output
| Field | Description |
|---|---|
| hasErrors | Displays True if request was not successful and returned errors. |
| results | Result of the upload request. |
| results -> id | ID of the submitted Job |
| results -> referenceId | Reference ID of the Job |
The output of an activity is displayed for informational purposes only in this tab and cannot be modified or altered. The information in this schema varies depending on the operation that you selected in the Configuration tab. The elements that you see in the schema can be mapped as input to the activities which follow this activity in the flow.