Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

HTTP ELEMENT

Value

URI

/rest/crud/1.0/table/column/field-name/distinct

METHOD

GET

Content-Type

application/json

Query Strings

exclude - list of excluded field names to not included on the returned list

RESPONSE

HTTP STATUS CODE

BODY

200

Array of Json String

400

Code Block
{ "key": "name-one", //required, must be unique "name": "Name One", //required "description": "description", "hidden" : "true", //default: false "inactiveFlag": "true", //default false "fields": [{ "key": "field-one", //required, unique within the Table "name": "Field One", //required "type": "ForeignKey", //enum: Currency, Date, Number, Checkbox, Text, IpAddress, Password, TextArea, Hyperlink, List, Option, Percent, ForeignKey, Integer //default: Text "required: "false" //default: false "relation": "name-one", //required if type = ForeignKey - the Table.key "listValues": [ //ignored if type is not List "Possible1", "Possible2", "Possible3" ] }] }

error - main category of the error

message - error message

SCENARIO AND RESPONSE

Scenario

Response

POSITIVE

Code Block
[
    "Client Test Two",
    "Healthcare Related Computers Restricted Purposes Notes",
    "WWW IP Address",
    "User Authorized Access Limited Notes",
    "Ship To Company",
    "Unsubscribe Flag",
    "Healthcare Related Computers Restricted Purposes Compliant",
    "Installation Date"
]