We are excited to announce that Topliners is moving to Cloud Customer Connect! The migration will be complete in July, at which time you can access Oracle Marketing discussions, knowledge and events via Cloud Customer Connect. There will be no changes to your login/profile, content you've authored, nor bookmarks in your followed categories. Redirect links will ensure you quickly and easily find your way to product categories you follow. In addition, you will have access to other Oracle CX-related content.

Please note Topliners will be read only beginning July 25, 2 PM PDT to July 27 9 AM PDT.
Get started

Discussions

Categories

Eloqua Bulk Contact Export - Subscription info

Simon Roggeman
Simon Roggeman Posts: 2 Blue Ribbon
edited Jul 18, 2019 5:40PM in Developer Tools

We've got a request from our business to provide an export of all contact's subscription information (email group level). Purpose: they want to import it in their BI solution to analyze certain scenarios.

What's the best way of retrieving this info from Eloqua in bulk? Anybody ever attempted such thing?

Post edited by Unknown User on
Tagged:
· Share on FacebookShare on Twitter

Answers

  • kevin.woessner
    kevin.woessner Posts: 17 Bronze Medal
    edited Apr 25, 2017 12:37PM

    Simon - have you looked into the Bulk API?  I haven't used the API for email groups, but the documentation is here: REST API for Oracle Eloqua Marketing Cloud Service - Retrieve an email group

    ~Kevin

    · Share on FacebookShare on Twitter
  • Ignotas Petrulis
    Ignotas Petrulis Posts: 1
    edited Aug 11, 2017 3:41AM

    Hi Simon,

    I have the same question as you do.

    It seems that it is not possible to get subscription information using BULK API. However, REST API has an endpoint /data/contact/<contactId>/email/groups/subscription that you could use as a last resort (depending on the number of contacts you have). If you called this endpoint asynchronously with different contactId you would get contact subscription information pretty quickly.

    · Share on FacebookShare on Twitter
  • Lou Patrick
    Lou Patrick Posts: 169 Bronze Trophy
    edited Aug 17, 2017 7:14PM

    One way to retrieve email group subscriptions via the Bulk API would be creating shared filters, then using the EXISTS operator with the shared filter id in the Bulk API export definition filter.

    First you'd need to create Shared Filters using the "Subscribed To Groups" filter criteria for each email group.

    email-group-shared-filter.png

    To retrieve the shared filter id, you'd use the Retrieve a list of contact filters endpoint, where you'd also be able to search by name.

    Request:

    GET /api/bulk/2.0/contacts/filters?q=name=Subscribed*

    Response:

    {    "items": [        {            "name": "Subscribed - Newsletter",            "count": 0,            "statement": "{{ContactFilter[100072]}}",            "uri": "/contacts/filters/100072",            "createdBy": "Lou.Patrick",            "createdAt": "2017-08-17T22:50:24.8700000Z",            "updatedBy": "Lou.Patrick",            "updatedAt": "2017-08-17T22:50:24.8700000Z"        }    ],    "totalResults": 1,    "limit": 1000,    "offset": 0,    "count": 1,    "hasMore": false}

    Next you'd create the export definition to retrieve the contacts subscribed to the email group:

    POST /api/bulk/2.0/contacts/exports{    "name": "Contact Export - Subscribed to Newsletter",    "fields": {        "EmailAddress": "{{Contact.Field(C_EmailAddress)}}"    },    "filter": "EXISTS('{{ContactFilter[100072]}}')"}

    Then you'd just sync, and retrieve the contacts that are subscribed to the email group indicated by the filter, then repeat for each email group.

    For more information about the EXISTS operator see:

    · Share on FacebookShare on Twitter
  • claudiazoglmann
    claudiazoglmann Posts: 46 Gold Medal
    edited Aug 22, 2017 6:10PM

    The older API documentation including the developer changelog seems to be unavailable since last weekend. All links return a 404.

    Will this be reestablished, @Lou Patrick?

    Post edited by Unknown User on
    · Share on FacebookShare on Twitter
  • Tom Schreurs
    Tom Schreurs Posts: 11 Blue Ribbon
    edited Aug 23, 2017 3:34AM

    It's not just me , I also couldn't get the documentation anymore since this week.

    · Share on FacebookShare on Twitter
  • Simon Roggeman
    Simon Roggeman Posts: 2 Blue Ribbon
    edited Aug 23, 2017 4:58AM

    That's how we are currently dealing with it, indeed. Shared filters with a name prefix, then run exports of all contacts per filter.

    · Share on FacebookShare on Twitter
  • Syed R
    Syed R Posts: 36 Red Ribbon
    edited Jun 27, 2019 8:02PM

    Hi Lou - Any ideas on how to also get the Email Group Subscription Date returned via the API? We not only want to retrieve the Email Group status for contacts in bulk, but also the Subscription or Unsubscription Date/Time associated with it. Thoughts?

    SR

    · Share on FacebookShare on Twitter
  • Syed R
    Syed R Posts: 36 Red Ribbon
    edited Jun 27, 2019 8:03PM

    Hi Lou - Any ideas on how to also get the Email Group Subscription Date returned via the API? We not only want to retrieve the Email Group status for contacts in bulk, but also the Subscription or Unsubscription Date/Time associated with it. Thoughts?

    SR

    · Share on FacebookShare on Twitter
  • Lou Patrick
    Lou Patrick Posts: 169 Bronze Trophy
    edited Jul 18, 2019 5:40PM

    Currently there is not a way to retrieve the date/times. I'd suggest voting up this idea, which would enable retrieving date/times for email group subscriptions.

    · Share on FacebookShare on Twitter