Skip navigation

1) (optional) Initiate a Get inquiry to get Site ID, site name, URIs, and user details

     URI to initiate the action GET https://login.eloqua.com/id

       9-19-2013 6-04-21 PM.png

Response as it appears in Fiddler - JSON format:
9-19-2013 6-06-03 PM.png

2) Initiate a POST request to create an Export definition:

URI to initiate the export: POST https://secure.eloqua.com/API/Bulk/1.0/contact/export?format=json
This time you have to provide the details of the fields and the data that you want to include in the export:

This could look something like this:

{"name":"Tarek.Naim",

"fields":{"ID":"{{Contact.Id}}",

"filter":{"filterRule":"VALUEEQUALSCOMPARISONVALUE",

"value":"{{Contact.Field(C_EmailAddress)}}","comparisonValue":"tarek.naim@oracle.com"},

  "secondsToRetainData":

14400,"secondsToAutoDelete":14400,"kbUsed":0}

9-19-2013 6-10-55 PM.png


Response status should be 201 and should look something like:

9-19-2013 6-19-57 PM.png



3) Initiate a POST request to create a SYNC

POST https://secure.eloqua.com/API/Bulk/1.0/sync

Request Body: {"syncedInstanceUri":"/contact/export/14"}

9-19-2013 6-27-12 PM.png

Response would look something like this:

9-19-2013 6-27-01 PM.png
4) You can Poll the sync to make sure it's been created successfully:

URI: https://secure.eloqua.com/API/Bulk/1.0/sync/syncID

9-19-2013 6-29-25 PM.png
Response should indicate a success status

9-19-2013 6-29-51 PM.png


5) Initiate a Get request to get the data from the staging area:

GET https://secure.eloqua.com/API/Bulk/1.0/contact/export/EPORTID/data?page=1&pageSize=10&format=json

Response would show the data in the staging area

The REST API provides access to create, retrieve, update and delete External Assets.

 

Accessing External Asset Types

  • GET :  /assets/external/types?depth=complete

 

Accessing External Assets

  • GET :  /assets/external/{id}?depth={depth}

 

Response

The response for this call looks as follows :

 

{
  "elements": [
    {
      "type": "ExternalAssetType",
      "id": "2",
      "createdAt": "1256486517",
      "depth": "complete",
      "name": "Tradeshow Sample",
      "updatedAt": "1369168490",
      "updatedBy": "23",
      "activityTypes": [
        {
          "type": "ExternalActivityType",
          "id": "1017",
          "createdAt": "1369168490",
          "createdBy": "23",
          "depth": "complete",
          "name": "Attended",
          "updatedAt": "1369168490",
          "updatedBy": "23"
        },
        {
          "type": "ExternalActivityType",
          "id": "1016",
          "createdAt": "1369168490",
          "createdBy": "23",
          "depth": "complete",
          "name": "Registered",
          "updatedAt": "1369168490",
          "updatedBy": "23"
        },
        {
          "type": "ExternalActivityType",
          "id": "1003",
          "createdAt": "1256486517",
          "depth": "complete",
          "name": "Viewed Demo",
          "updatedAt": "1369168490",
          "updatedBy": "23"
        },
        {
          "type": "ExternalActivityType",
          "id": "1002",
          "createdAt": "1256486517",
          "depth": "complete",
          "name": "Visited Booth",
          "updatedAt": "1369168490",
          "updatedBy": "23"
        }
      ]
    },
    {
      "type": "ExternalAssetType",
      "id": "3",
      "createdAt": "1347550426",
      "createdBy": "146",
      "depth": "complete",
      "name": "Direct Mail",
      "updatedAt": "1371612452",
      "updatedBy": "14",
      "activityTypes": [
        {    …   }
   }

 

Properties

 

 

Name

Type

Description

Notes

Validation

type

“ExternalAsset”

 

 

 

id

integer

The unique identifier for the External Assset

ReadOnly

 

name

string

 

 

 

createdAt

long

 

 

 

createdBy

integer

 

 

 

updatedAt

long

 

 

 

updatedBy

integer

 

 

 

 

Related Operations

  • SEARCH :  /assets/externals?depth={depth}&count={count}&page={page}&search={search}&orderBy={orderBy}&lastUpdatedAt={lastUpdatedAt}
  • POST :  /assets/external
  • PUT :  /assets/external/{id}
  • DELETE :  /assets/external/{id}

 

 

We hope that you find this helpful and please let us know if you need more information.

 

Thanks,

Fred

TJ Fields-Oracle

New Code It Badges

Posted by TJ Fields-Oracle Sep 5, 2013

Attention developers...

 

We now have our own Topliners badges!!!!

 

As we all know, the only way to make a development community work is to have members share their insight, and assist fellow developers by participating in discussions.  As a way of recognizing those who regularly contribute, we've come up with two badges specific to Code It.

 

Here are the details:

 

By answering 5 questions, you can earn 75 points and become a Code It Professor.

 

To become a Code It Guru, you will need to answer 20 questions, but you will get 200 points.

 

"Answering" a question means having them marked either Correct or Helpful by the community.

 

You will see the Missions, as well as your own progress for each, displayed on the right hand side of the main Code it page for easy tracking!

 

Let the gaming begin :-)

The REST API provides access to create, retrieve, update and delete Email Folders.

 

Accessing Email Folders

  • GET :  /assets/email/folders?depth={depth}&count={count}&page={page}&search={search}&orderBy={orderBy}&lastUpdatedAt={lastUpdatedAt}

 

Response

The response for this call looks as follows :

 

{
  "elements": [
    {
      "type": "Folder",
      "id": "42",
      "createdAt": "1172514464",
      "depth": "complete",
      "description": "Root",
      "name": "Email Group Root",
      "updatedAt": "1378173465",
      "updatedBy": "116",
      "isSystem": "true"
    },
    {
      "type": "Folder",
      "id": "43",
      "createdAt": "1172514464",
      "depth": "complete",
      "folderId": "250",
      "name": "My Emails",
      "updatedAt": "1336754427",
      "updatedBy": "28",
      "isSystem": "false"
    },
    {
      "type": "Folder",
      "id": "44",
      "createdAt": "1172514464",
      "depth": "complete",
      "folderId": "250",
      "name": "Newsletter",
      "updatedAt": "1335871832",
      "updatedBy": "46",
      "isSystem": "false"
    },
  ],
  "page": 1,
  "pageSize": 10,
  "total": 301
}
 

 

Properties

 

Name

Type

Description

Notes

Validations

type

Folder

 

 

 

id

integer

The unique identifier of the Folder

ReadOnly

IdRequirement

isSystem

boolean

Identifies a system generated Folder

ReadOnly

 

name

string

The Folder’s name

 

 

 

Related Operations :

GET :  /assets/email/folder/{id}?depth={depth}

POST :  /assets/email/folder

PUT :  /assets/email/folder/{id}

DELETE :  /assets/email/folder/{id}

 

We hope this helps and please let us know if you have any questions.

 

Thanks,

Fred

Filter Blog

By date: By tag: