Jump to

• Request
• Response
• Examples

Retrieve an export sync's data

get

/api/bulk/2.0/syncs/{id}/data

Retrieves an export sync's data. This endpoint allows you to retrieve data from an export that you have sync'd more than once. This endpoint will not return any information for import syncs: if the specified sync is an import Eloqua will return a 400 HTTP error code.

Request

Supported Media Types

• application/json
• text/csv

Path Parameters

• id(required): integer
  Id of the sync.

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
  Total number of sync results found.

Back to Top

Response

Supported Media Types

• application/json

200 Response

OK

Body ()

Root Schema : SyncDataQueryResponse

Type: object

Title: SyncDataQueryResponse

The response body includes information about the synchronization definition.

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":"SyncDataQueryResponse",
    "description":"The response body includes information about the synchronization definition.",
    "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.

Back to Top

Examples

The following examples demonstrate how to retrieve a sync using an HTTP request and cURL. For more information on requests, see API requests.

HTTP Request Example

Retrieve the sync with ID = 1444:

GET /syncs/1444/data?limit=2
			

Response:

{
	"totalResults": 10,
	"limit": 2,
	"offset": 0,
	"count": 0,
	"hasMore": true,
	"items": [
		{
			"ID": "123456789 ([e-mail])",
			"email": "[e-mail]",
			"name": "Zafar Manal"
		},
		{
			"ID": "789456123 ([e-mail])",
			"email": "[e-mail]",
			"name": "Joana Mendes"
		}
	]
}
			

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/syncs/1444/data?limit=2
			

Back to Top