Jump to

• Request
• Response
• Examples

Retrieve a list of campaign response export definitions

get

/api/bulk/2.0/campaignResponses/exports

Retrieves a list of campaign response export definitions. See Using the campaign response endpoints in the Oracle Eloqua Developer Help Center for more complete information about these endpoints.

Request

Supported Media Types

• application/json
• text/csv

Query Parameters

• limit: integer
• links: string
• offset: integer
• orderBy: string
• q: string
• totalResults: boolean

Back to Top

Response

Supported Media Types

• application/json

200 Response

OK.

Body ()

Root Schema : CampaignResponseExportSearchResponse

Type: object

Title: CampaignResponseExportSearchResponse

Show Source

• count: integer
  Title: count
• hasMore: boolean
  Title: hasMore
• items: array items
  Title: items
• limit: integer
  Title: limit
• offset: integer
  Title: offset
• totalResults: integer(int64)
  Title: totalResults

{
    "title":"CampaignResponseExportSearchResponse",
    "description":"",
    "properties":{
        "count":{
            "title":"count",
            "description":"",
            "type":"integer"
        },
        "hasMore":{
            "title":"hasMore",
            "description":"",
            "type":"boolean"
        },
        "items":{
            "title":"items",
            "description":"",
            "type":"array",
            "items":{
                "$ref":"#/definitions/Export"
            }
        },
        "limit":{
            "title":"limit",
            "description":"",
            "type":"integer"
        },
        "offset":{
            "title":"offset",
            "description":"",
            "type":"integer"
        },
        "totalResults":{
            "format":"int64",
            "title":"totalResults",
            "description":"",
            "type":"integer"
        }
    }
}

Nested Schema : items

Type: array

Title: items

Show Source

• Array of: object Export
  Title: Export

{
    "title":"items",
    "description":"",
    "type":"array",
    "items":{
        "$ref":"#/definitions/Export"
    }
}

Nested Schema : Export

Type: object

Title: Export

Show Source

• areSystemTimestampsInUTC: boolean
  Title: areSystemTimestampsInUTC
• autoDeleteDuration: string
  Title: autoDeleteDuration
• createdAt: string(date-time)
  Title: createdAt
• createdBy: string
  Title: createdBy
• crmAccountIdField: string
  Title: crmAccountIdField
• dataRetentionDuration: string
  Title: dataRetentionDuration
• externalSystemId: integer
  Title: externalSystemId
• fields: object fields
  Title: fields
• filter: string
  Title: filter
• kbUsed: integer(int64)
  Title: kbUsed
• maxRecords: integer
  Title: maxRecords
• name: string
  Title: name
• productIdField: string
  Title: productIdField
• syncActions: array syncActions
  Title: syncActions
• updatedAt: string(date-time)
  Title: updatedAt
• updatedBy: string
  Title: updatedBy
• uri: string
  Title: uri

{
    "title":"Export",
    "description":"",
    "properties":{
        "areSystemTimestampsInUTC":{
            "title":"areSystemTimestampsInUTC",
            "description":"",
            "type":"boolean"
        },
        "autoDeleteDuration":{
            "title":"autoDeleteDuration",
            "description":"",
            "type":"string"
        },
        "createdAt":{
            "format":"date-time",
            "title":"createdAt",
            "description":"",
            "type":"string"
        },
        "createdBy":{
            "title":"createdBy",
            "description":"",
            "type":"string"
        },
        "crmAccountIdField":{
            "title":"crmAccountIdField",
            "description":"",
            "type":"string"
        },
        "dataRetentionDuration":{
            "title":"dataRetentionDuration",
            "description":"",
            "type":"string"
        },
        "externalSystemId":{
            "title":"externalSystemId",
            "description":"",
            "type":"integer"
        },
        "fields":{
            "title":"fields",
            "description":"",
            "type":"object"
        },
        "filter":{
            "title":"filter",
            "description":"",
            "type":"string"
        },
        "kbUsed":{
            "format":"int64",
            "title":"kbUsed",
            "description":"",
            "type":"integer"
        },
        "maxRecords":{
            "title":"maxRecords",
            "description":"",
            "type":"integer"
        },
        "name":{
            "title":"name",
            "description":"",
            "type":"string"
        },
        "productIdField":{
            "title":"productIdField",
            "description":"",
            "type":"string"
        },
        "syncActions":{
            "title":"syncActions",
            "description":"",
            "type":"array",
            "items":{
                "$ref":"#/definitions/SyncAction"
            }
        },
        "updatedAt":{
            "format":"date-time",
            "title":"updatedAt",
            "description":"",
            "type":"string"
        },
        "updatedBy":{
            "title":"updatedBy",
            "description":"",
            "type":"string"
        },
        "uri":{
            "title":"uri",
            "description":"",
            "type":"string"
        }
    }
}

Nested Schema : fields

Type: object

Title: fields

Nested Schema : syncActions

Type: array

Title: syncActions

Show Source

• Array of: object SyncAction
  Title: SyncAction

{
    "title":"syncActions",
    "description":"",
    "type":"array",
    "items":{
        "$ref":"#/definitions/SyncAction"
    }
}

Nested Schema : SyncAction

Type: object

Title: SyncAction

Show Source

• action: string
  Title: SyncActionType

  Default Value: add

  Allowed Values: [ "add", "remove", "setStatus" ]
• destination: string
  Title: destination
• status: string
  Title: MemberStatus

  Default Value: bounced

  Allowed Values: [ "bounced", "subscribed", "unsubscribed", "active", "complete", "pending", "errored", "yes", "no", "invalid", "permission" ]
• updateAll: boolean
  Title: updateAll

{
    "title":"SyncAction",
    "description":"",
    "properties":{
        "action":{
            "$ref":"#/definitions/SyncActionType"
        },
        "destination":{
            "title":"destination",
            "description":"",
            "type":"string"
        },
        "status":{
            "$ref":"#/definitions/MemberStatus"
        },
        "updateAll":{
            "title":"updateAll",
            "description":"",
            "type":"boolean"
        }
    }
}

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.

Back to Top

Examples

The following examples demonstrate how to retrieve a list of campaign response export definitions using an HTTP request and cURL. For more information on requests, see API requests.

HTTP Request Example

Retrieve a list of campaign response export definitions:

GET /campaignResponses/exports
Content-Type: application/json 
			

Response:

{
  "items": [
    {
      "name": "Example Campaign Response Export",
      "fields": {
        "CampaignResponseId": "{{CampaignResponse.Id}}",
        "MemberStatus": "{{CampaignResponse.Field(MemberStatus)}}",
        "CampaignMembershipId": "{{CampaignResponse.Field(IntegrationReturnValue)}}",
        "CreatedAt": "{{CampaignResponse.CreatedAt}}",
        "CRMCampaignId": "{{CampaignResponse.Campaign.Field(CRMCampaignId)}}",
        "EloquaCampaignId": "{{CampaignResponse.Campaign.Id}}",
        "EloquaCampaignName": "{{CampaignResponse.Campaign.Field(CampaignName)}}",
        "LeadId": "{{CampaignResponse.Contact.Field(C_OracleFusionLeadID)}}",
        "ContactId": "{{CampaignResponse.Contact.Field(C_OracleFusionContactID)}}",
        "EmailAddress": "{{CampaignResponse.Contact.Field(C_EmailAddress)}}"
      },
      "filter": "STATUS('{{ActionInstance(7BE704D3AF604775AD416E8D0A5AB212).Execution[12345]}}') = 'pending'",
      "syncActions": [
        
      ],
      "dataRetentionDuration": "PT12H",
      "uri": "/campaignResponses/exports/1836",
      "createdBy": "API.User",
      "createdAt": "2017-11-21T17:20:07.9830000Z",
      "updatedBy": "API.User",
      "updatedAt": "2017-11-21T17:20:07.9830000Z"
    }
  ],
  "totalResults": 1,
  "limit": 1000,
  "offset": 0,
  "count": 1,
  "hasMore": false
}
			

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/campaignResponses/exports
			

Back to Top