The InsightsExternalData Object
With the InsightsExternalData object, you can configure and control external data uploads. You can use it to provide metadata, trigger the start of the upload process, check status, and request cancellation and cleanup.
The InsightsExternalData object is used with the InsightsExternalDataPart object, which holds the parts of the data to be uploaded. Together, they provide a programmatic way to upload a large file in parts and trigger a dataflow into a dataset. The first step is to insert a row into the InsightsExternalData object. Data parts are then uploaded to InsightsExternalDataPart objects. The Mode field is used to enable faster uploads. The Action field of the InsightsExternalData object is updated to start processing and request cancellations. After the Action field is updated to request processing, no user edits are allowed on the objects, except to request cancellation.
The standard system fields (CreatedById, CreatedDate, LastModifiedById, LastModifiedDate, and SystemModstamp) are documented in System Fields in the Salesforce Object Reference.
The InsightsExternalData object is available in API version 31 and later.
create(), delete(), describeSObjects(), query(), retrieve(), update(), upsert()
Use the following fields with the InsightsExternalData object.
Type: Picklist
Properties: Create, Filter, Group, Sort, Update
Description: Action to perform on this data. Values: Abort, Delete, None, Process.
Type: Int
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: Length of the compressed metadata JSON file. This is a system field.
Type: String
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: Dataflow ID used to create the dataset (API v34+). This is a system field.
Type: String
Properties: Create, Filter, Nillable, Sort, Update
Description: Description of the dataset used during dataset creation.
Type: String
Properties: Create, Filter, Group, Sort, Update
Description: Unique dataset alias (maximum 80 characters).
Type: String
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: App developer name or app ID that contains the dataset.
Type: String
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: Dataset display name (maximum 255 characters).
Type: String
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: External data file identifier (maximum 255 characters).
Type: Picklist
Properties: Create, Filter, Group, Sort, Update
Description: Uploaded data format. Values: Csv, Binary.
Type: Boolean
Properties: Create, Defaulted on create, Filter, Group, Sort, Update
Description: Reserved for future use.
Type: Boolean
Properties: Create, Defaulted on create, Filter, Group, Sort, Update
Description: Reserved for future use; indicates whether parts can be processed independently.
Type: Picklist
Properties: Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description: License type of the external data file. Default: EinsteinAnalytics.
Type: Int
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: Length of metadata JSON file. This is a system field.
Type: Blob (Base64-encoded string)
Properties: Create, Nillable, Update
Description: Metadata JSON that describes uploaded file structure.
Type: Picklist
Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description: Upload mode. Values: Incremental, None.
Type: String
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: Email address used for upload notifications.
Type: Picklist
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: Notification condition for upload events. Default: WarningsFailures.
Type: Picklist
Properties: Create, Filter, Group, Sort, Update
Description: Dataset load operation. Values: Append, Delete, Overwrite, Upsert.
Type: Picklist
Properties: Create, Filter, Group, Sort, Update
Description: Data upload job status. Default value: New.
Type: String
Properties: Create, Nillable, Update
Description: Error or warning reason for the upload status.
Type: String
Properties: Create, Filter, Nillable, Sort, Update
Description: Time when upload was submitted or set to Process. This is a system field.
Type: Picklist
Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description: Target for external data. Valid value: Dataset.