Copy DataSet

The DataSet Name

A description of this DataSet

A code for this DataSet

Flag whether to copy all the row data from the original dataSet

The dataSetId

The dataSet Name

The dataSet description

The userId of the User that owns this DataSet

Timestamp indicating the date/time this DataSet was edited last

The user name of the User that owns this DataSet

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

A code for this Data Set

Flag to indicate whether this DataSet is a lookup table

Flag to indicate whether this DataSet is Remote

Flag to indicate whether this DataSet is Real time

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

Method to fetch the Data, can be GET or POST

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.

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

Authentication method, can be none, digest, basic

Username to authenticate with

Corresponding password

Comma separated string of custom HTTP headers

Custom User agent

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

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

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

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

Last Synchronisation Timestamp

Last Clear Timestamp

Root-Element form JSON where the data are stored in

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

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

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

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

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

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

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

The id of the Folder this DataSet belongs to

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