[SalesForce] Simple Exact Target API Request: Retrieve Subscriber info from list specified by list ID and subscriber key

Tech support sent me here to ask this question.

I would like to set up an ET API call that would return subscriber information (i.e., attributes) for a specific user (using subscriberkey) from a specific list (i.e, NOT all subscribers). I've tried various permutations of using Subscriber and ListSubscriber without any success.

Can anybody direct me to some specific documentation about how to do this?

Thanks.

Best Answer

A lot of it depends on what you intend to do with this data. There is an unsubEvent REST route that supports GET, but doesnt appear to have a listid property(which would be strange, since unsubs are cardinally list-subscriber level data): https://code.exacttarget.com/apis-sdks/fuel-sdks/tracking/unsubscribe-tracking.html#rubyget . I cant help much with that, but might be worth trying.

Its not really API, but we actually do already track unsub date per list in the Unsubscribe Data view: https://help.exacttarget.com/en-US/documentation/exacttarget/interactions/activities/query_activity/data_view_unsubscribe/

That data view has eventDate(the date of the unsub event) and listid. You could write some simple sql and place in a query activity:

SELECT subscriberkey, eventDate, listid FROM _unsubsubscribe
WHERE eventDate > dateadd(day,datediff(day,1,GETDATE()),0) 
AND eventDate < dateadd(day,datediff(day,0,GETDATE()),0)

You could join in _listSubscribers on subscriberid to get a human-readable list name instead of the listID.

As has been mentioned previously, Profile attributes are at an account level (shared across all lists), so that wouldnt be the place to store unsubscribe data. Subscription status ETC are really system attributes and are stored per list.

Related Solutions

[SalesForce] exact target import data vs sending Subscribers using API create documet

This may help. It is how we get data into Data Extensions from an FTP site. So long as all your logic is done on your side to generate a CSV, this would work. The steps would be (from within your ET account) 1. Create a File Transfer activity to bring the file into our data warehouse. 2. Create an Import Activity to import said file into your data extension of choice. 3. Create an Automation from with AutomationStudio to run 1&2 sequentially, either at set times or by an API trigger.

See http://help.exacttarget.com/en/documentation/exacttarget/interactions/activities/file_transfer_activity/

And

http://help.exacttarget.com/en/documentation/exacttarget/interactions/activities/import_activity/

Hope this helps... Good luck!

[SalesForce] Get all automations that exist using SOAP using C#

I have coded it with the same result, but I have found some interesting thing, you can call Retrieve method filtering by "isActive" parameter and "true" value, and after repeat the call filtering by "isActive" parameter and "false" value, and you will have the full set result of automations. The only thing is that I have to do in Async mode because of .Net Core 2.1 version only shows me Async calls once I associate the WFC service.

My code working:

List<Automation> AutomationList = new List<Automation>();

RetrieveRequest rr = new RetrieveRequest();
rr.ObjectType = "Automation";
rr.Properties = new String[] { "Name", "Description", "CustomerKey", "IsActive" };

SimpleFilterPart sfp = new SimpleFilterPart();
sfp.SimpleOperator = SimpleOperators.equals;
sfp.Property = "IsActive";
sfp.Value = new String[] { "true" };
rr.Filter = sfp;

RetrieveResponse rResp = await soapClient.RetrieveAsync(new RetrieveRequest1(rr));

for (int i = 0; i < rResp.Results.Length; i++)
{ 
    AutomationList.Add((Automation) rResp.Results[i]);
}

sfp.Value = new String[] { "false" };
rr.Filter = sfp;

// Add inactive automations
rResp = await soapClient.RetrieveAsync(new RetrieveRequest1(rr));
for (int i = 0; i < rResp.Results.Length; i++)
{
    AutomationList.Add((Automation)rResp.Results[i]);
}

return AutomationList;

I hope it will be useful :)

Best Answer

Related Solutions

[SalesForce] exact target import data vs sending Subscribers using API create documet

[SalesForce] Get all automations that exist using SOAP using C#

Related Topic