Get opens details

  • 0
  • 1
  • Question
  • Updated 1 year ago
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: EOL Clean up

Hello, I am new to using the Emma api and still wrapping my head around it, can someone shed some light on how will I get the info of all the opens and the email addresses who opened in a mailing list from the api? 
Photo of Medicus Partners

Medicus Partners

  • 4 Posts
  • 0 Reply Likes

Posted 1 year ago

  • 0
  • 1
Photo of LexisNexis

LexisNexis

  • 20 Posts
  • 2 Reply Likes
I you are coding in .NET and using EMMASharp, I can give you a hand.  I have routines that return the data that you are looking for.
Photo of Medicus Partners

Medicus Partners

  • 4 Posts
  • 0 Reply Likes
We are not using .net using coldfusion.
Photo of Kyle Gregory | Lipscomb University

Kyle Gregory | Lipscomb University, Champion

  • 99 Posts
  • 69 Reply Likes
Hey @Medicus Partners,

I don't know of a coldfusion library, but you can build your own calls to the API for your needs. Assuming you know the mailing ID, you would first get the response summary (opened) for the mailing:
GET /#account_id/response/#mailing_id

Then you would get the opens and iterate through the users that opened:
GET /#account_id/response/#mailing_id/opens

Note the opens will likely have more than 500 records, so you'll need to understand about record pagination in the Emma API. When you run your pagination count call for opens, you might be able to get your total number of opens (if that's all you're needing from the summary call), but I would test that against the info in summary to make sure they match.

Hope that gets you started.

Kyle
Photo of Grey Stepp

Grey Stepp, Support Team Manager

  • 1700 Posts
  • 135 Reply Likes
Thanks Kyle!!
Photo of Medicus Partners

Medicus Partners

  • 4 Posts
  • 0 Reply Likes
Thanks for the detailed information. I am trying to get started to use the search filters. I am trying to get all members whose last_modified_dt was in last 30 days. Can someone shed some light on how the request should look like. I am guessing it has to be passed in Json format making a GET http call to https://api.e2ma.net/XXXX/members
Photo of Kyle Gregory | Lipscomb University

Kyle Gregory | Lipscomb University, Champion

  • 99 Posts
  • 69 Reply Likes
Hey @Medicus Partners,

You'll need to create the search before retrieving it. You'll do that by doing a POST to  /#account_id/searches then retrieve it from /#account_id/searches/#search_id/members

As far as the actual criteria for the search, you might need to do some testing. I would start at:
["last_modified_at", "in last", {"day": 30}]
I'm not sure you can ping the last modified at field from a search, but it's worth a go. Let us know how it works.

Kyle