Retrieve a list of opportunity import definitions
get
/api/bulk/2.0/opportunities/imports
Retrieves a list of opportunity import definitions. For more information about using these endpoints, see, using the opportunities endpoints.
Request
Supported Media Types
- application/json
- text/csv
Query Parameters
Back to Top
Response
Supported Media Types
- application/json
200 Response
OK.
Root Schema : OpportunityImportSearchResponse
Type:
objectTitle:
Show Source
OpportunityImportSearchResponse-
count(optional):
integer
Title:
count -
hasMore(optional):
boolean
Title:
hasMore -
items(optional):
array items
Title:
items -
limit(optional):
integer
Title:
limit -
offset(optional):
integer
Title:
offset -
totalResults(optional):
integer(int64)
Title:
totalResults
Nested Schema : Import
Type:
objectTitle:
Show Source
Import-
autoDeleteDuration(optional):
string
Title:
autoDeleteDuration -
createdAt(optional):
string(date-time)
Title:
createdAt -
createdBy(optional):
string
Title:
createdBy -
dataRetentionDuration(optional):
string
Title:
dataRetentionDuration -
externalSystemId(optional):
integer
Title:
externalSystemId -
fields(optional):
object fields
Title:
fields -
identifierFieldName(optional):
string
Title:
identifierFieldName -
importPriorityUri(optional):
string
Title:
importPriorityUri -
isSyncTriggeredOnImport(optional):
boolean
Title:
isSyncTriggeredOnImport -
isUpdatingMultipleMatchedRecords(optional):
boolean
Title:
isUpdatingMultipleMatchedRecords -
kbUsed(optional):
integer(int64)
Title:
kbUsed -
name(optional):
string
Title:
name -
nullIdentifierFieldName(optional):
boolean
Title:
nullIdentifierFieldName -
syncActions(optional):
array syncActions
Title:
syncActions -
updatedAt(optional):
string(date-time)
Title:
updatedAt -
updatedBy(optional):
string
Title:
updatedBy -
updateRule(optional):
string
Title:
RuleTypeDefault Value:alwaysAllowed Values:[ "always", "ifNewIsNotNull", "ifExistingIsNull", "useFieldRule" ] -
updateRuleByField(optional):
object updateRuleByField
Title:
updateRuleByField -
uri(optional):
string
Title:
uri
Nested Schema : fields
Type:
objectTitle:
fieldsNested Schema : syncActions
Type:
arrayTitle:
Show Source
syncActions-
Array of:
object SyncAction
Title:
SyncAction
Nested Schema : updateRuleByField
Type:
objectTitle:
updateRuleByFieldNested Schema : SyncAction
Type:
objectTitle:
Show Source
SyncAction-
action(optional):
string
Title:
SyncActionTypeDefault Value:addAllowed Values:[ "add", "remove", "setStatus" ] -
destination(optional):
string
Title:
destination -
status(optional):
string
Title:
MemberStatusDefault Value:bouncedAllowed Values:[ "bounced", "subscribed", "unsubscribed", "active", "complete", "pending", "errored", "yes", "no", "invalid", "permission" ] -
updateAll(optional):
boolean
Title:
updateAll
400 Response
Bad request. See Status Codes for information about other possible HTTP status codes.
401 Response
Unauthorized. See Status Codes for information about other possible HTTP status codes.
403 Response
Forbidden. See Status Codes for information about other possible HTTP status codes.
404 Response
The requested resource was not found. See Status Codes for information about other possible HTTP status codes.
409 Response
There was a conflict. See Status Codes for information about other possible HTTP status codes.
410 Response
The requested resource is no longer available. See Status Codes for information about other possible HTTP status codes.
412 Response
The resource you are attempting to delete has dependencies, and cannot be deleted. See Status Codes for information about other possible HTTP status codes.
413 Response
Storage space exceeded. See Status Codes for information about other possible HTTP status codes.
500 Response
The service has encountered an internal server error. See Status Codes for information about other possible HTTP status codes.
503 Response
There was a timeout processing the request. See Status Codes for information about other possible HTTP status codes.
Examples
The following examples demonstrate how to retrieve a list of opportunity import definitions using an HTTP request and cURL. For more information on requests, see API requests.
HTTP Request Example
Retrieve the first 2 opportunity import definitions in your database:
GET /opportunities/imports?limit=2
Content-Type: application/json
Response:
{
"items": [
{
"isIdentifierFieldCaseSensitive ": false,
"name": "Opportunity Import",
"fields": {
"OpportunityID": "{{Opportunity.Id}}",
"OpportunityName": "{{Opportunity.Field(Name)}}",
"AccountName": "{{Opportunity.Field(AccountName)}}",
"CreatedDate": "{{Opportunity.CreatedAt}}",
"Amount": "{{Opportunity.Field(Amount)}}",
"CloseDate": "{{Opportunity.Field(CloseDate)}}",
"Currency": "{{Opportunity.Field(Currency)}}",
"ForecastToCloseDate": "{{Opportunity.Field(ForecastToCloseDate)}}",
"Stage": "{{Opportunity.Field(Stage)}}",
"Territory": "{{Opportunity.Field(Territory)}}"
},
"identifierFieldName": "OpportunityID",
"syncActions": [],
"isSyncTriggeredOnImport": false,
"dataRetentionDuration": "P7D",
"uri": "/opportunities/imports/16",
"createdBy": "API.User",
"createdAt": "2018-02-08T14:54:52.5770000Z",
"updatedBy": "API.User",
"updatedAt": "2018-02-08T14:54:52.5770000Z"
},
{
"isIdentifierFieldCaseSensitive ": false,
"name": "Another Opportunity Import",
"fields": {
"OpportunityID": "{{Opportunity.Id}}",
"OpportunityName": "{{Opportunity.Field(Name)}}",
"AccountName": "{{Opportunity.Field(AccountName)}}",
"Amount": "{{Opportunity.Field(Amount)}}",
"Stage": "{{Opportunity.Field(Stage)}}"
},
"identifierFieldName": "OpportunityID",
"syncActions": [],
"isSyncTriggeredOnImport": false,
"dataRetentionDuration": "P7D",
"uri": "/opportunities/imports/17",
"createdBy": "API.User",
"createdAt": "2018-02-08T14:56:13.9170000Z",
"updatedBy": "API.User",
"updatedAt": "2018-02-08T15:06:25.9900000Z"
}
],
"totalResults": 5,
"limit": 2,
"offset": 0,
"count": 2,
"hasMore": true
}
cURL Example
Here is the same example in cURL given an instance with the name APITest, username API.User, and POD of 3.
curl --user "APITest\API.User" --request GET https://secure.p03.eloqua.com/api/bulk/2.0/opportunities/imports?limit=2