Looking for a faster solution to download data extension data. Currently we have a solution similar to this ...


The number of rows we are downloading has increased significantly so we are looking for a faster solution.

As the above page states, performance can be increased by delivering the data to an Enhanced FTP Location.

It links to this page... https://help.exacttarget.com/en/technical_library/web_service_guide/technical_articles/creating_a_data_extract_activity_with_the_soap_web_service_api/

...however I am not sure what parameters need to be specified for the ExtractRequest to return the Data Extension rows?

So if anyone could outline this process and the parameters needed that would be a huge help.

  • How often are you looking to get the data? – Timothy Jun 13 '14 at 17:09
  • Frequency can vary from daily to weekly. Which raises another question, following the first down load is it possible to return only persisted rows? – bhattamer Jun 13 '14 at 17:20

I would recommend set this up within the ET application itself. It would be much easier than doing it in the API. What you would do:

  1. Set up a query activity to grab the persisted data and put it in a new data extension (using overwrite, so you can reuse it)

  2. Set up an data extract activity to extract the data.

  3. Set up a file transfer activity to moved the extract to the FTP server.

  4. Set up an automation in Automation Studio to do these steps in order. This will allow you schedule the frequency.

Hope this helps!

  • I do like your approach to gather the persisted data, however I need the entire routine done through the API. – bhattamer Jun 13 '14 at 18:16
  • Could you please share your use case? The only case I can possibly see is that you need to change the steps dynamically. And you would still be able to do that part dynamically. I've done it both ways, and I obviously prefer the one I have in my answer, so I'd like to know. Thanks! – Timothy Jun 13 '14 at 18:52
  • It is just not appropriate for us to use the Exact Target UI to automate this process for customers. Have you setup a data extract for a Data Extension via the API? – bhattamer Jun 13 '14 at 19:12
  • Fair enough. Have a look at help.exacttarget.com/en-US/technical_library/web_service_guide/… – Timothy Jun 13 '14 at 19:41
  • Maybe I am not understanding completely, but can't you set up the automation and use the API to run the automation via your chosen input? help.exacttarget.com/en-US/technical_library/web_service_guide/… – Gortonington Nov 19 '15 at 15:14

This url has been updated with an example of how to export/extract a DE to the related "Enhanced FTP Export Directory", near the bottom of the page titled "How to Create a Data Extention Data Extract".

update for 2018...

See the following link: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/creating_a_data_extract_activity_with_the_soap_web_service_api.htm

If using an Extract Request to get data from a DE, ensure that the extract ID = bb94a04d-9632-4623-be47-daabc3f588a6, use the DECustomerKey parameter to specify the DE and include all other required parameters.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.