REST API for Oracle Eloqua Marketing Cloud Service

Upload data for an opportunity import definition

post

/api/bulk/2.0/opportunities/imports/{id}/data

Uploads data for an opportunity import definition. For more information about using these endpoints, see, using the opportunities endpoints. When uploading data, Eloqua expects that data to be encoded with UTF-8.

Request

Supported Media Types

application/json
text/csv

Path Parameters

id(required): integer

Root Schema : OpportunityImportData

Type: array

Title: OpportunityImportData

Show Source

Array of: object OpportunityImportDataItem

Title: OpportunityImportDataItem

{
    "title":"OpportunityImportData",
    "type":"array",
    "items":{
        "title":"OpportunityImportDataItem",
        "type":"object",
        "items":{
            "type":"string"
        }
    }
}

Nested Schema : OpportunityImportDataItem

Type: object

Title: OpportunityImportDataItem

Show Source

Array of: string

{
    "title":"OpportunityImportDataItem",
    "type":"object",
    "items":{
        "type":"string"
    }
}

Response

Supported Media Types

application/json

201 Response

OK.

Root Schema : OpportunityImportDataResponse

Type: object

Title: OpportunityImportDataResponse

Show Source

callbackUrl: string

Title: callbackUrl
createdAt: string(date-time)

Title: createdAt
createdBy: string

Title: createdBy
status: string

Title: SyncStatusType

Default Value: pending

Allowed Values: [ "pending", "active", "success", "warning", "error" ]
syncedInstanceUri: string

Title: syncedInstanceUri
syncEndedAt: string(date-time)

Title: syncEndedAt
syncStartedAt: string(date-time)

Title: syncStartedAt
uri: string

Title: uri

{
    "title":"OpportunityImportDataResponse",
    "description":"",
    "properties":{
        "callbackUrl":{
            "title":"callbackUrl",
            "description":"",
            "type":"string"
        },
        "createdAt":{
            "format":"date-time",
            "title":"createdAt",
            "description":"",
            "type":"string"
        },
        "createdBy":{
            "title":"createdBy",
            "description":"",
            "type":"string"
        },
        "status":{
            "$ref":"#/definitions/SyncStatusType"
        },
        "syncedInstanceUri":{
            "title":"syncedInstanceUri",
            "description":"",
            "type":"string"
        },
        "syncEndedAt":{
            "format":"date-time",
            "title":"syncEndedAt",
            "description":"",
            "type":"string"
        },
        "syncStartedAt":{
            "format":"date-time",
            "title":"syncStartedAt",
            "description":"",
            "type":"string"
        },
        "uri":{
            "title":"uri",
            "description":"",
            "type":"string"
        }
    }
}

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 upload data to an opportunity import definition using an HTTP request and cURL. For more information on requests, see API requests.

HTTP Request Example

Upload data to an opportunity import definition with Id#18:


POST /opportunities/imports/18/data
Content-Type: application/json

Request body:


[
  {
    "OpportunityID": "1",
    "OpportunityName": "ABC Company",
    "AccountName": "ABC",
    "CreatedDate": "2017-10-05 1:15",
    "Amount": "1000000",
    "CloseDate": "",
    "Currency": "USD",
    "ForecastToCloseDate": "",
    "Stage": "Prospecting",
    "Territory": "West"
  },
  {
    "OpportunityID": "2",
    "OpportunityName": "XYZ Company",
    "AccountName": "XYZ",
    "CreatedDate": "2017-10-05 1:25",
    "Amount": "1000000",
    "CloseDate": "",
    "Currency": "USD",
    "ForecastToCloseDate": "",
    "Stage": "Prospecting",
    "Territory": "West"
  }
]

Response:


204 No Content

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" --header "Content-Type: application/json" --request POST --data '[{"OpportunityID":"1","OpportunityName":"ABC Company","AccountName":"ABC","CreatedDate":"2017-10-05 1:15","Amount":"1000000","CloseDate":"","Currency":"USD","ForecastToCloseDate":"","Stage":"Prospecting","Territory":"West"},{"OpportunityID":"2","OpportunityName":"XYZ Company","AccountName":"XYZ","CreatedDate":"2017-10-05 1:25","Amount":"1000000","CloseDate":"","Currency":"USD","ForecastToCloseDate":"","Stage":"Prospecting","Territory":"West"}]' https://secure.p03.eloqua.com/api/bulk/2.0/opportunities/imports/18/data