Get Data Extensions
post
/config/sim/v1/setup/getDataExtensions
Request
Supported Media Types
- application/json
- multipart/form-data
Data Extension Get Request Body
Root Schema : DataExtensionsGetRequestBody
Type:
Show Source
object-
include:
string
Example:
locations -
includeAll:
string
This can take 2 values: basic or detailed. If 'basic' is specified, The response contains all the properties of the object except
Ext values. If 'detailed' is specified, The response contains all the properties of the object. Example:detailed -
languages:
string
If specified, limits translated strings returned.Example:
en-US, de-DE, es-MX -
limit:
integer
Number of results returned in this page. Not required if paging parameters are not supported.Example:
10 -
offset:
integer
Starting resource record index. Not required if paging parameters are not supportedExample:
2 -
orderBy:
string
Sorts the response by the specified field name and sort order.Example:
objectNum:asc -
searchCriteria:
string
Search criteria to filter results based on field valueExample:
where equals(active,1)
Response
Supported Media Types
- application/json
200 Response
A collection of data extension objects of the organization
Root Schema : DataExtensionsGetResponse
Type:
Show Source
object-
count(required):
integer
Current response recount count.Example:
9 -
hasMore(required):
boolean
Flag indicating if there are more objects to fetch.Example:
true -
items(required):
array items
Array of data extension objects of the organization.
-
limit(required):
integer
Server page sizeExample:
10 -
offset(required):
integer
Starting resource record indexExample:
0 -
totalResults(required):
integer
Total number of rows (excluding the paging parameters)Example:
100
Nested Schema : items
Type:
arrayArray of data extension objects of the organization.
Show Source
-
Array of:
object DataExtensionResponseBody
Model for Data Extension Object
Nested Schema : DataExtensionResponseBody
Type:
objectModel for Data Extension Object
Show Source
-
dataConstraints:
object dataConstraints
Constraints on the values that can be inserted for this data extension property.
-
displayWidth:
integer
This value sets the width of the column when it is displayed in EMCExample:
150 -
extraColumnName:
string
name of the data extension property, cannot be empty.Example:
isKiosk -
isDownloadable:
boolean
boolean value to specify if the property is downloadable.Example:
true -
isEditable:
boolean
boolean value to specify if the property is editable.Example:
true -
isViewable:
boolean
boolean value to specify if the property is viewable.Example:
true -
objectNum:
integer
Object Number of the Data Extension property.Example:
1 -
sortPriority:
integer
sort priority of the property.Example:
1 -
tableName:
string
Name of the table.Example:
workstation -
tableNum:
integer
Object Number of the table.Example:
1 -
translatableHelp:
object translatableHelp
A string that contains translations of help for the property
-
translatableName:
object translatableName
A string that contains translations of column name for the property
-
type:
integer
Type of data that can be inserted for this data extension property. ** Below is a list of acceptable values for type |Type |Description | |-----|--------------| |0 |Text | |1 |Multiline Text| |2 |Number | |3 |Decimal | |4 |Boolean | |5 |Date | |6 |Time | |7 |Date/Time | |8 |Text List | |9 |Lookup List | |10 |Big Text List | |11 |XML Document | |12 |JSON |Example:
1
Nested Schema : dataConstraints
Type:
objectConstraints on the values that can be inserted for this data extension property.
Show Source
-
dateTimeFormat:
string
Valid Date/Time format. For types- Date, Time, Date/Time.Example:
yyyy/MM/dd hh:mm t -
lines:
integer
number of lines allowed. For types- Multiline TextExample:
2 -
lookupList:
object lookupList
List to choose data values from. For types- Lookup List, Text List, Big Text List
-
maxChars:
integer
maximum characters allowed. For types- Text and JSONExample:
128 -
maxValue:
number
maximum value for the allowed range. For types- Number, DecimalExample:
9999 -
minValue:
number
minimum value for the allowed range. For types- Number, DecimalExample:
0
Nested Schema : translatableHelp
Type:
objectA string that contains translations of help for the property
Example:
{
"en-US":"Property",
"de-DE":"Eigentum",
"es-MX":"Propiedad"
}Nested Schema : translatableName
Type:
objectA string that contains translations of column name for the property
Example:
{
"en-US":"Property",
"de-DE":"Eigentum",
"es-MX":"Propiedad"
}Nested Schema : lookupList
Type:
objectList to choose data values from. For types- Lookup List, Text List, Big Text List
Example:
{
"1":"Entry-1",
"2":"Entry-2",
"3":"Entry-3"
}400 Response
400 Bad Request
Root Schema : ErrorDetails
Type:
objectResponse body when the request returns an error.
Show Source
-
detail(required):
string
A short, human-readable summary of the problem.Example:
Specified Data is invalid -
errorDetails(required):
string
A human-readable explanation specific to this occurrence of the problem.Example:
Entity Does Not Exist -
o:errorCode(required):
integer
Error code of the problemExample:
55223 -
status(required):
integer
HTTP status code.Example:
400 -
title(required):
string
A short, human-readable summary of the problem type.Example:
VALIDATION ERROR -
type(required):
string
A URI reference that identifies the problem type. When this member is not present, its value is assumed to be "about:blank".Example:
http://www.abc.org/xyz.html
404 Response
404 Requested resource not found