Select Syntax

The select query parameter restricts the columns retrieved for matching records. By default all values in a record are returned. You can limit the columns returned using the select query parameter. The parameter takes a comma separated list of column names.

The column name is a fully qualified name including the envelope around a matching record. The envelope being:

{
  "id": "{id}",
  "version": {version},
  "data": {match}
}

For example to only return the id column and the record’s NamFirst and NamLast values the column list would be id,data.NamFirst,data.NamLast. Where there are nested columns a dot is used to separate each component. Note you must have permission to view a listed column otherwise an error is generated.