We are trying to export the subscribers from a list. We can see that the list has 1.4 million subscribers:
curl -X POST -k -H "Content-Type: application/json" -H "Authorization: Bearer udxcbspxxbtng27vvx8pthz4" --data-binary @getListSizes.json https://www.exacttargetapis.com/email/v1/lists/subscribercounts
where the getListSizes.json file is
{"listIdsSubscriberCounts":
[
{"listId":1048647},
{"listId":975390},
{"listId":969054},
{"listId":1007526}
]
}
yields these results
[{"listId":1048647,"subscriberCount":1240259},
{"listId":975390, "subscriberCount":1473780},
{"listId":969054, "subscriberCount":1473780},
{"listId":1007526,"subscriberCount":1251534}]
So we know that the list with ID = 975390 has 1,473,780 subscribers in it. But when we execute this request...
<Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Header>
<fueloauth xmlns="http://exacttarget.com">csb7juxf5jg2rkjytqvh8khb</fueloauth>
</Header>
<Body>
<RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
<RetrieveRequest>
<ObjectType>ListSubscriber</ObjectType>
<Properties>CreatedDate</Properties>
<Properties>Client.ID</Properties>
<Properties>SubscriberKey</Properties>
<Properties>Status</Properties>
<Properties>UnsubscribedDate</Properties>
<Properties>ID</Properties>
<Properties>Client.PartnerClientKey</Properties>
<Filter xsi:type="SimpleFilterPart">
<Property>ListID</Property>
<SimpleOperator>equals</SimpleOperator>
<Value>975390</Value>
</Filter>
</RetrieveRequest>
</RetrieveRequestMsg>
</Body>
</Envelope>
will give this result after a minute or 10...
<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/08/addressing" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soap:Header>
<wsa:Action>RetrieveResponse</wsa:Action>
<wsa:MessageID>urn:uuid:6576c6f7-f7af-4611-b2e7-4ed31c012cd0</wsa:MessageID>
<wsa:RelatesTo>urn:uuid:59d9554d-4e48-415c-8b04-f17df686de23</wsa:RelatesTo>
<wsa:To>http://schemas.xmlsoap.org/ws/2004/08/addressing/role/anonymous</wsa:To>
<wsse:Security>
<wsu:Timestamp wsu:Id="Timestamp-9bba2a37-7d89-4644-ae9c-4305a8998953">
<wsu:Created>2015-03-08T03:48:13Z</wsu:Created>
<wsu:Expires>2015-03-08T03:53:13Z</wsu:Expires>
</wsu:Timestamp>
</wsse:Security>
</soap:Header>
<soap:Body>
<RetrieveResponseMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
<OverallStatus>OK</OverallStatus>
<RequestID>b99068a1-f5d0-4eed-aa12-94e7a61483ef</RequestID>
</RetrieveResponseMsg>
</soap:Body>
</soap:Envelope>
This is cracked. How can you return OK when clearly something is wrong? Note that we have seen this query succeed on occasion, but not since last night. We have a major media push for our client on Monday, who is on the verge of dumping ExactTarget for just this reason. We can't reliably export the data. Something will invariably fail well before we get to the end of this list. What can we do differently?
Also, note that the access tokens are valid when we do this, we refresh them every 50 minutes or so. That's not the problem.
Finally, please don't suggest the FTP route, our client wants their email campaigns automatically merged with their social campaigns. It has to be programmatic.
Any help at all would be appreciated.