---
schema_version: "1"
id: 9149673a2001fc14902da5b93033ea65601e58946718085fd9d9af14b3fce311
title: Retrieve Data from a Data Extension
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/marketing-cloud/guides/mc-apis/retrieving_data_from_a_data_extension.md
canonical_url: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/retrieving_data_from_a_data_extension.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: d93ee6ca11aea5635cd5ee782e19880090e2c8165286e2b5cb9044e8baea9e39
products:
  - Marketing Cloud Engagement APIs and Programmatic Languages
  - Marketing Cloud
---
# Retrieve Data from a Data Extension

Use the [retrieve](https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/retrieve.md) method to get data from a data extension. You can retrieve up to 2,500 records per request.

Keep these considerations in mind when you use SOAP API to retrieve data from data extensions.

- If you issue one or fewer calls per hour, you can achieve better performance and efficiency by using a data extract activity to deliver the data to your Enhanced FTP location.
- The data extension object doesn’t support `LIKE` operators in filters for the `retrieve` method.
- When you retrieve a column that contains the `Date` data type, SOAP API returns a value that’s rounded to the nearest second, followed by AM or PM. This behavior occurs even when the source timestamp contains millisecond data. As a result, if you use a `Date` column as a primary key, it can prevent you from retrieving unique rows. For this reason, we recommend against using `Date` values as primary keys.

## Sample SOAP Request

This sample SOAP envelope represents a request to retrieve several fields from a data extension based on the value of the `MemberId` column.

```xml
<s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope"
  xmlns:a="http://schemas.xmlsoap.org/ws/2004/08/addressing"
  xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
  <s:Header>
    <a:Action s:mustUnderstand="1">Retrieve</a:Action>
    <a:To s:mustUnderstand="1">
      https://YOUR_SUBDOMAIN.soap.marketingcloudapis.com/Service.asmx</a:To>
    <fueloauth xmlns="http://exacttarget.com">YOUR_ACCESS_TOKEN</fueloauth>
  </s:Header>
  <s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
      <RetrieveRequest>
        <ObjectType>DataExtensionObject[MembershipRewardsProgramme]</ObjectType>
        <Properties>FirstName</Properties>
        <Properties>Surname</Properties>
        <Properties>Area</Properties>
        <Properties>RewardsPoints</Properties>
        <Filter xsi:type="SimpleFilterPart">
          <Property>MemberId</Property>
          <SimpleOperator>equals</SimpleOperator>
          <Value>dc415965-f672-4381-993f-1ffd00a9dab6</Value>
        </Filter>
      </RetrieveRequest>
    </RetrieveRequestMsg>
  </s:Body>
</s:Envelope>
```

## Sample SOAP Response

If the information from the request is found in the data extension, the response contains that information.

```xml
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema"
  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">
  <env:Header xmlns:env="http://www.w3.org/2003/05/soap-envelope">
    <wsa:Action>RetrieveResponse</wsa:Action>
    <wsa:MessageID>urn:uuid:a8496aed-18c2-4eaf-b10b-0784aa6f8fd4</wsa:MessageID>
    <wsa:RelatesTo>urn:uuid:67ab5548-912e-4c51-9d53-d9f68d0370e6</wsa:RelatesTo>
    <wsa:To>http://schemas.xmlsoap.org/ws/2004/08/addressing/role/anonymous
    </wsa:To>
    <wsse:Security>
      <wsu:Timestamp wsu:Id="Timestamp-faa7151b-48c9-498d-b690-8035c5202d95">
        <wsu:Created>2024-07-10T19:03:56Z</wsu:Created>
        <wsu:Expires>2024-07-10T19:08:56Z</wsu:Expires>
      </wsu:Timestamp>
    </wsse:Security>
  </env:Header>
  <soap:Body>
    <RetrieveResponseMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
      <OverallStatus>OK</OverallStatus>
      <RequestID>4f7cc213-3b96-4c5c-9684-f23f0d7c1fcd</RequestID>
      <Results xsi:type="DataExtensionObject">
        <PartnerKey xsi:nil="true" />
        <ObjectID xsi:nil="true" />
        <Type>DataExtensionObject</Type>
        <Properties>
          <Property>
            <Name>FirstName</Name>
            <Value>Pooja</Value>
          </Property>
          <Property>
            <Name>Surname</Name>
            <Value>Chatterjee</Value>
          </Property>
          <Property>
            <Name>Area</Name>
            <Value>Hammersmith</Value>
          </Property>
          <Property>
            <Name>RewardsPoints</Name>
            <Value>201042</Value>
          </Property>
        </Properties>
      </Results>
    </RetrieveResponseMsg>
  </soap:Body>
</soap:Envelope>
```