Sign in
dataset

DataSet Search

Search this users DataSets

get/dataset

Query parameters

dataSetIdinteger

Filter by DataSet Id

dataSetstring

Filter by DataSet Name

codestring

Filter by DataSet Code

isRealTimeinteger

Filter by real time

userIdinteger

Filter by user Id

embedstring

Embed related data such as columns

folderIdinteger

Filter by Folder ID

sortBy'dataSetId' | 'dataSet' | 'code' | 'isRemote' | 'isRealTime' | 'owner' | 'lastSync' | 'dataLastModified' | 'groupsWithPermissions'

Specifies which field the results are sorted by. Used together with sortDir

sortDir'asc' | 'desc'

Sort direction

Response

successful operation

dataSetIdinteger

The dataSetId

dataSetstring

The dataSet Name

descriptionstring

The dataSet description

userIdinteger

The userId of the User that owns this DataSet

lastDataEditinteger

Timestamp indicating the date/time this DataSet was edited last

ownerstring

The user name of the User that owns this DataSet

groupsWithPermissionsstring

A comma separated list of Groups/Users that have permission to this DataSet

codestring

A code for this Data Set

isLookupinteger

Flag to indicate whether this DataSet is a lookup table

isRemoteinteger

Flag to indicate whether this DataSet is Remote

isRealTimeinteger

Flag to indicate whether this DataSet is Real time

dataConnectorSourcestring

Indicates the source of the data connector. Requires the Real time flag. Can be null, user-defined, or a connector.

methodstring

Method to fetch the Data, can be GET or POST

uristring

URI to call to fetch Data from. Replacements are {{DATE}}, {{TIME}} and, in case this is a sequencial used DataSet, {{COL.NAME}} where NAME is a ColumnName from the underlying DataSet.

postDatastring

Data to send as POST-Data to the remote host with the same Replacements as in the URI.

authenticationstring

Authentication method, can be none, digest, basic

usernamestring

Username to authenticate with

passwordstring

Corresponding password

customHeadersstring

Comma separated string of custom HTTP headers

userAgentstring

Custom User agent

refreshRateinteger

Time in seconds this DataSet should fetch new Datas from the remote host

clearRateinteger

Time in seconds when this Dataset should be cleared. If here is a lower value than in RefreshRate it will be cleared when the data is refreshed

truncateOnEmptyinteger

Flag whether to truncate DataSet data if no new data is pulled from remote source

runsAfterinteger

DataSetID of the DataSet which should be fetched and present before the Data from this DataSet are fetched

lastSyncinteger

Last Synchronisation Timestamp

lastClearinteger

Last Clear Timestamp

dataRootstring

Root-Element form JSON where the data are stored in

summarizestring

Optional function to use for summarize or count unique fields in a remote request

summarizeFieldstring

JSON-Element below the Root-Element on which the consolidation should be applied on

sourceIdinteger

The source id for remote dataSet, 1 - JSON, 2 - CSV

ignoreFirstRowinteger

A flag whether to ignore the first row, for CSV source remote dataSet

rowLimitinteger

Soft limit on number of rows per DataSet, if left empty the global DataSet row limit will be used.

limitPolicystring

Type of action that should be taken on next remote DataSet sync - stop, fifo or truncate

csvSeparatorstring

Custom separator for CSV source, comma will be used by default

folderIdinteger

The id of the Folder this DataSet belongs to

permissionsFolderIdinteger

The id of the Folder responsible for providing permissions for this DataSet

Changes

Changed in 5 of the 52 revisions of this API.136

  • fe497e811c7f2See the full diff
    • ○

      added the new optional query request parameter sortBy

      new-optional-request-parameter

    • ○

      added the new optional query request parameter sortDir

      new-optional-request-parameter

  • 41c04de98ec51See the full diff
    • ○

      added the media type application/json for the response with the status 200

      response-media-type-added

    This revision also has 2 changes that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog

  • b23641df295f1See the full diff
    • ○

      added the new optional query request parameter isRealTime

      new-optional-request-parameter

  • 9ddbdc81e86a2See the full diff
    • ○

      added the new optional query request parameter folderId

      new-optional-request-parameter

    • ○

      added the new optional query request parameter userId

      new-optional-request-parameter

  • 8e127539510413See the full diff
    • ▲

      removed the media type application/json for the response with the status 200

      response-media-type-removed

    • ●

      deleted the query request parameter folderId

      request-parameter-removed

    • ●

      deleted the query request parameter isRealTime

      request-parameter-removed

    • ●

      deleted the query request parameter userId

      request-parameter-removed

    This revision also has 77 changes that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog