7.7.3 Import any external Delivery Data

^Feature

^{ADvendio__Feature__c}

Selects the interface function/feature

To import pls enter „GenericDataPushImport“

^Source

^{ADvendio__Source__c}

Name of data source out of your CSV file header

If not in imported csv this field gets ignored

^Target

^{ADvendio__Target__c}

API name to the field in which the

data gets written into

^{Target Object}

^{ADvendio__TargetObject__c}

Object to be filled

You can set up multiple import mappings for more than one object, but one CSV will always fill only one object at a time.

^Required

^{ADvendio__Required__c}

If checked the import verified that the csv header contains this field otherwise an error is reported and the upload is cancelled.

^{Unique Key}

^{ADvendio__UniqueKey__c}

Marks this field as a unique key

If checked the import can be handled by a Salesforce UPSERT instead of an import.

^Comment

^{ADvendio__Comment__c}

Comment, no function for the interface.

^Label

^MasterLabel

Salesforce default - not used

Data Import Mapping Name

^{DeveloperName}

Salesforce default - not used

^endpoint

^{String (URL)}

salesforce login - end point or session end point

^password

^String

Salesforce password (not necessary for if you use session)

^username

^String

Salesforce user name (not necessary for if you use session)

^token

^String

Salesforce login token (not necessary for if you use session)

^sessionId

^String

Salesforce SessionId (not necessary for if you use password, username and token)

^orgId

^String

Salesforce Organisation ID

^dataType

^String

here only CSV allowed

^operation

^String

"GenericDataPushImport"

^objectName

^String

Pls use the „Data Import Mapping“ Target Object you like to import data into.

^fmail

^{String (; separierte email)}

Email address for error messages, if empty Email of field smail is used.

^smail

^{String (; separierte email)}

Email address for success messages.

After process has finished a Link to the result page will be sent.

^jobId

^Integer

ID

^status

^Integer

0 = queued, 1 = in progress, 2 = completed, 3 = failed

^message

^String

Description

^progress

^Float

0 - 1 showing the progress

^start

^DateTime

start time of job

^end

^DateTime

end time of job

^request

^String

Used JobConfiguration

^orgId

^String

Salesforce Org (JobConfiguration)

^operation

^String

refer to JobConfiguration

^jobId

^Integer

refer to JobStatus

^orgId

^String

refer to JobConfiguration and JobStatus

status

JobStatus

refer to JobStatus

results

List<JobResult>

refer to JobResult

^data

^Object

Data of the typ dataType

^dataType

^String

Typ of data (e.g. GenericDataPushImportLineResult, ForceBulkJobInfoResult)

^created

^DateTime

created date

^lineNr

^Integer

Position in CSV File including header

^success

^Boolean

false if error (successful lines will not be recorded)

^message

^String

Error message or other information for that line

id

String

refer: Setup - Jobs - Bulk Data Load Jobs - Job ID