4

Is there a way to use the API to select (using a simple filter) and retrieve records residing in data extension (DE A) and update them into another data extension (DE B). I need to perform this action a couple of hundred times, so creating query activities in the UI doesn't seem like my best option. I have all of the names, keys and objectIds for the target DEs stored in a table so I was hoping to loop through the process. I can't seem to find anything in the documentation or code samples that addresses this type of scenario so I'm hoping someone here might have done something similar.

Thanks -

Mark

  • 2
    Hello, user6880, I'd love to help but unfortunately I am not very familiar with the Fuel SDK. Since ExactTarget is now part of salesforce.com, please promote the idea for an ExactTarget Developer Edition so that we can build a stronger ExactTarget presence here on Stack Exchange: success.salesforce.com/ideaView?id=08730000000l1yFAAQ – Marty C. Feb 16 '14 at 5:16
  • This is something I am pushing for @MartyC. In the meantime, I will continue getting other experts involved to answer questions. Thanks again for your interest in helping! – Kelly J Andrews Feb 16 '14 at 18:34
  • Are you basically trying to merge some DE's into one DE? Not sure exactly what the end goal is. – Kelly J Andrews Feb 17 '14 at 1:59
  • Hi Kelly - I have a master subscriber DE where each subscriber has been assigned an identifier tied to a store location. For each store location I have built a DE to use within a Distributed Send instance. What I now need to do is get a copy of the subscribers that reside in the master DE into the appropriate DE for their location. As I mentioned in my initial post, there are many of these so I really don't want to create an individual query activity for each. I was hoping to figure out a way to accomplish this either directly through the API or through the use of AmpScript and API objects. – Mark P Feb 17 '14 at 2:29
  • Any feedback on the answer below? Did you get it working? – Kelly J Andrews Feb 19 '14 at 15:30
1

Mark,

This would be possible using the API.

Retrieve: https://code.exacttarget.com/sdks/fuel-sdk-interacting-data-extension-rows#Retrieving

Update: https://code.exacttarget.com/sdks/fuel-sdk-interacting-data-extension#Updating

It would also be possible to filter Subscribers with the Distributed Sending account settings. I am assuming that there is a specific reason that you are not using the Subscriber model, but it is very simple to set up.

If there is data you needed to protect about subscribers you can have that held by Subscriber Key in a DE at the Enterprise level. AMP Script can access those DEs with "ent.DE_NAME" in a lookup function.

  • Thanks for the feedback and information, Caleb. Not exactly sure what you meant by Subscriber Model though. We have several child BUs under a parent BU (which is a child of the enterprise level account). However, within those child business units we will be using distributed sending. I know that we can filter subscribers from the enterprise into specific BUs but that isn't the use case here and I'm not sure of how you would filter subscribers within Distributed Sending itself? As far as I know Distributed Sending is really just a UI and user role modification that sits on top of a BU? – Mark P Feb 19 '14 at 20:34
  • Caleb, the link you provided for Updating will update the actual DE info, such as the name. I believe what Mark P needs to do is actually insert new rows into a DE based on the results of the retrieve. Creating a new row: code.exacttarget.com/sdks/… – Jon Sakas Apr 23 '14 at 19:21

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.