Retrieve Data Extension Column Details

Use the Get method to return information about existing data extension columns.

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

Optionally, you can set the props property when using the Get method in order to limit the number of fields returned. If you don't define the props property, the call returns all fields. You can provide the props property as an array containing any combination of the following values:

  • ObjectID
  • PartnerKey
  • Name
  • DefaultValue
  • MaxLength
  • IsRequired
  • Ordinal
  • IsPrimaryKey
  • FieldType
  • CreatedDate
  • ModifiedDate
  • Scale
  • Client.ID
  • CustomerKey

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 properties that can be returned for a data extension column

  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.