Oracle Web Services On Demand Guide > Web Services On Demand API Calls > Data Loader API Calls >
BulkOpImportCreateRequest
Creates a bulk import request. Usage
Use the BulkOpImportCreateRequest method to create a bulk import request. The arguments taken by the method correspond to elements in the WSDL file, as described in Table 189. The xsdLocal1:ImportOptions argument specifies the import options, which are similar to the options available in the Import Wizard in the Oracle CRM On Demand application:
- CSVDelimiter. The type of CSV delimiter used in the file: comma (,) or semi-colon (;).
- DateTimeFormat. The date and time format used in the CSV file: usa, can, eur, uk, other.
- DuplicateCheckOption. Whether the Row Id (rowid) or external ID (externalid) are used for duplicate checking.
- ErrorLogLevel. The level of error logging:
- all. All messages
- errors. Error messages only.
- errorswarnings. Error messages and warning messages only.
Typical customer import data is contained in a CSV file with the following format: ColumnName1, ColumnName2, ...
Data1, Data2, ...
Data1, Data2, ...
...
The xsdLocal1:ListOfFieldMappings element specifies the mapping of CSV column names to field names in Oracle CRM On Demand. For example: <ns1:ListOfFieldMappings>
<ns1:FieldMapping>
<ns1:CSVColumnName>
Web Site
</ns1:CSVColumnName>
<ns1:FieldName>
Home Page
</ns1:FieldName>
</ns1:FieldMapping>
</ns1:ListOfFieldMappings>
CSVColumnHeaders specifies the list of CSV column names, for example: <ns0:CSVColumnHeaders>
"Account Name","External Unique Id","Web Site","Account Location"
</ns0:CSVColumnHeaders>
The mappings are validated and if everything is correct, the import request is created. Arguments
Table 189 describes the arguments taken by the BulkOpImportCreateRequest method.
Table 189. Arguments Taken by the BulkOpImportCreateRequest Method
|
|
|
|
|
DataFileName |
The name of the data file to be imported, for example, account1.csv |
Yes |
Not applicable |
Input |
RecordType |
The record type to be imported. |
Yes |
Not applicable |
Input |
xsdLocal1:ImportOptions |
The list of import options. |
No |
Not applicable |
Input |
xsdLocal1:ListOfFieldMappings |
The mapping of CSV file column names and their corresponding fields. |
Yes |
Not applicable |
Input |
CSVColumnHeaders |
The list of column names from the CSV file. |
Yes |
Not applicable |
Input |
EnableImportAudit |
Enables or disables auditing of record creation/update during import requests. This setting takes effect only if the user has the privilege Manage Record Auditing for Imports, otherwise it is ignored. Accepted values are true or false. |
No |
true |
Input |
EnableMailNotification |
Enables or disables email notifications for import requests. Accepted values are true or false. |
No |
true |
Input |
SendUserLogFile |
Whether the user log file is attached to the email notification for import requests. If email notification is disabled, SendUserLogFile is ignored. Accepted values are true or false. |
No |
false |
Input |
CSVRowCount |
The number of data records in the data file to be imported. |
Yes |
Not applicable |
Input |
Operation |
The operation for the current request, such as insert, update. |
Yes |
Not applicable |
Input |
ClientVersion |
The current Data Loader client version number. |
No |
Not applicable |
Input |
RequestId |
The ID of the request created. |
Not applicable |
Not applicable |
Output |
Status |
The status of this Web service request. |
Not applicable |
Not applicable |
Output |
ErrorMessage |
Any error message from this Web service request, or a message indicating success. |
Not applicable |
Not applicable |
Output |
Return Value of the Call
The request ID, status, and any error message are returned.
|