0

I'm trying to retrieve rows from a Synchronized DE using the SOAP API with the REST API Access Token:

I've seen this: Cannot retrieve fields from a Shared Data Extension using the SOAP API

And this: http://www.kellyjandrews.com/2014/02/20/using-fuel-oauth-with-the-soap-api.html

I am able to retrieve a Data Extension Object and Folders, but no rows from a DE.

Here's my request:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <soapenv:Header>
      <fueloauth xmlns="http://exacttarget.com">{{Access Token}}</fueloauth>
  </soapenv:Header>
   <soapenv:Body>
      <RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
         <RetrieveRequest>
            <ObjectType>DataExtensionObject[Contact_Salesforce]</ObjectType>
            <Properties>Email</Properties>
         </RetrieveRequest>
      </RetrieveRequestMsg>
   </soapenv:Body>
</soapenv:Envelope>

I get this error: Error: API Permission Failed.

I'm wondering if it could have something to do with the Package/API Integration that was set-up.

1

Weird. In the API Integration permission settings, I had to set Read and Write Permissions for Data Extensions in order to do a Retrieve on a Data Extension.

  • OMG WOW. Thank you for saving me a lot of time. – k.. Feb 27 at 21:34

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.