Retrieve Data Extension Rows

Use the Get method to return data from existing data extension rows.

Specify Which Fields to Return

You must set the props property when using the Get method in order to specify the columns returned. The values that can be specified for props vary by data extension. If the column names are not known, use the ET_DataExtension_Column SDK object to return those names:

Ruby

PHP

Python

CSharp

Java

Documentation for the Fuel Java SDK can be found at http://salesforce-marketingcloud.github.io/FuelSDK-Java/

Filtering Get Requests

Optionally, you can set the filter property to limit the number of results returned. If you don't define the props property, the call returns all fields. A filter consists of three key/value pairs:

  1. Property: Any of the columns that exist in the data extension row

  2. SimpleOperator: Valid simple operators include the following:

    • equals
    • notEquals
    • greaterThan
    • lessThan
  3. Value/DateValue: Use DateValue to match values when using a Date datatype. Otherwise, use Value.

Ruby

PHP

Python

CSharp

Java

Documentation for the Fuel Java SDK can be found at http://salesforce-marketingcloud.github.io/FuelSDK-Java/