REST API for Oracle Eloqua Marketing Cloud Service

Retrieve an activity export's synced data

get

/api/bulk/2.0/activities/exports/{id}/data

Retrieves an activity export's synced data.

Request

Supported Media Types

application/json
text/csv

Path Parameters

id(required): integer

Part of the uri used to identify the activity export.

Query Parameters

limit: integer

A URL parameter that specifies the maximum number of records to return. This can be any positive integer between 1 and 50,000 inclusive. If not specified, the default is 1000. Example: ?limit=5.
links: string

The links section in a resource return all the links by default. The client side might be only interested in a particular link. To satisfy that requirement, a "links" query parameter might be supported. The value of this query parameter is a list of relations separated by comma ",". For example, ?links=canonical, next will only return the links with "rel" property be canonical or next.
offset: integer

Specifies an offset that allows you to retrieve the next batch of records. Any positive integer. For example, if your limit is 1000, specifying an offset of 1000 will return records 1000 through 2000. If not specified, the default is 0. Example: ?offset=1000.
totalResults: boolean

Whether or not the total results are shown, and factored into the hasMore property in the response. When set to false, the totalResults property will not be returned, and the hasMore property will be determined based on returned events that match the criteria specified in the URL parameters. If not specified, the default is true.

Response

Supported Media Types

application/json

200 Response

OK.

Root Schema : ActivityExportDataQueryResponse

Type: object

Title: ActivityExportDataQueryResponse

The response body contains information about the synced data.

Show Source

count: integer

Title: count

Number of results returned in the request.
hasMore: boolean

Title: hasMore

Indicates if there are more results.
items: array items

Title: items

The collection of items that match the search.
limit: integer

Title: limit

The maximum number of records returned. Set with the limit URL parameter, and defaults to 1000 if not specified.
offset: integer

Title: offset

The requested index from which records are returned. Set with the offset URL parameter, and defaults to 0 if not specified.
totalResults: integer(int64)

Title: totalResults

Number of total results. Returned when the totalResults URL parameter is not set to false.

{
    "title":"ActivityExportDataQueryResponse",
    "description":"The response body contains information about the synced data.",
    "properties":{
        "count":{
            "title":"count",
            "description":"Number of results returned in the request.",
            "type":"integer"
        },
        "hasMore":{
            "title":"hasMore",
            "description":"Indicates if there are more results.",
            "type":"boolean"
        },
        "items":{
            "title":"items",
            "description":"The collection of items that match the search.",
            "type":"array",
            "items":{
                "type":"object"
            }
        },
        "limit":{
            "title":"limit",
            "description":"The maximum number of records returned. Set with the <code>limit</code> URL parameter, and defaults to 1000 if not specified.",
            "type":"integer"
        },
        "offset":{
            "title":"offset",
            "description":"The requested index from which records are returned. Set with the <code>offset</code> URL parameter, and defaults to 0 if not specified.",
            "type":"integer"
        },
        "totalResults":{
            "format":"int64",
            "title":"totalResults",
            "description":"Number of total results. Returned when the <code>totalResults</code> URL parameter is not set to <code>false</code>.",
            "type":"integer"
        }
    }
}

Nested Schema : items

Type: array

Title: items

The collection of items that match the search.

Show Source

Array of: object items

{
    "title":"items",
    "description":"The collection of items that match the search.",
    "type":"array",
    "items":{
        "type":"object"
    }
}

Nested Schema : items

Type: object

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 the data for an activity export definition using an HTTP request and cURL. For more information on requests, see API requests.

HTTP Request Example

Retrieves the data for the activity export with ID = 21585:


GET /activities/exports/21585/data

Response:


{
  "totalResults": 13,
  "limit": 1000,
  "offset": 0,
  "count": 13,
  "hasMore": false,
  "items": [
    {
      "ActivityId": "224",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Fall 2016 Fashion Show Form",
      "AssetId": "3"
    },
    {
      "ActivityId": "225",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Summer 2016 Hotdog Eating Contest Form",
      "AssetId": "3"
    },
    {
      "ActivityId": "226",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Kraft Dinner Feedback Form",
      "AssetId": "3"
    },
    {
      "ActivityId": "227",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Cookie Feedback Form",
      "AssetId": "3"
    },
    {
      "ActivityId": "222",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Green Juice Survey Form",
      "AssetId": "5"
    },
    {
      "ActivityId": "223",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Vegetable Smoothie Feedback Form",
      "AssetId": "5"
    },
    {
      "ActivityId": "214",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Breakfast Form",
      "AssetId": "8"
    },
    {
      "ActivityId": "215",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Example Form for Notifications",
      "AssetId": "13"
    },
    {
      "ActivityId": "216",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Example Form for Notifications",
      "AssetId": "13"
    },
    {
      "ActivityId": "217",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Example Form for Notifications",
      "AssetId": "13"
    },
    {
      "ActivityId": "218",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Example Form for Notifications",
      "AssetId": "13"
    },
    {
      "ActivityId": "219",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Example Form for Notifications",
      "AssetId": "13"
    },
    {
      "ActivityId": "221",
      "ActivityType": "FormSubmit",
      "AssetType": "Form",
      "AssetName": "Example Form for Notifications",
      "AssetId": "13"
    }
  ]
}

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/activities/exports/21585/data