Summary

POST advancedSetting/category

Updates the list of categories.

Request

An array of DataSourceCategory objects

Response

An OperationResult object with success field true if the update is successful

Samples

POST/api/advancedSetting/categoryHTTP/1.1

With an existing empty category list, this request payload will add two categories ABC and XYZ:

[{"id":null,"name":"ABC","tenantId":null},{"id":null,"name":"XYZ","tenantId":null}]

Sample response:

{"success":true,"messages":[]}

User needs to reload the category list to have the server-generated ids by calling GET advancedSetting/category/(tenant_id). User will get:

[{"id":"0eac7266-4150-4b45-b6f7-6c40d95b6a37","name":"ABC","tenantId":null},{"id":"45c747c5-a11a-48f4-b966-14819a07450f","name":"XYZ","tenantId":null}]

Right after that, assuming user have renamed ABC category to ABCDEF, removed XYZ and added QRS, the update request payload will be:

[{"id":"0eac7266-4150-4b45-b6f7-6c40d95b6a37","name":"ABCDEF","tenantId":null},{"id":null,"name":"QRS","tenantId":null}]

GET advancedSetting/category/(tenant_id)

Returns an array of categories (filtered by tenant_id if provided).

Request

No payload

Response

An array of DataSourceCategory objects

Samples

GET/api/advancedSetting/categoryHTTP/1.1

Sample response:

[{"id":"45c747c5-a11a-48f4-b966-14819a07450f","name":"ABC","tenantId":null,"modified":"2016-03-20T04:47:09.1170000+07:00","deleted":false},{"id":"cda0ef9a-7fc0-4f9b-96ed-b1c33ea624b1","name":"DEF","tenantId":null,"modified":"2016-03-20T04:47:09.1330000+07:00","deleted":false},{"id":"868e6176-530f-4e8a-bef4-fb14d50e1882","name":"QRS","tenantId":null,"modified":"2016-03-20T04:47:09.1330000+07:00","deleted":false}]

DELETE advancedSetting/category/{category_id}

Deletes the category specified by category_id.

Request

No payload

Response

An OperationResult object with success field true if the deletion is successful

Samples

DELETE/api/advancedSetting/category/cda0ef9a-7fc0-4f9b-96ed-b1c33ea624b1HTTP/1.1

Sample response:

{"success":true,"messages":null}

GET advancedSetting/performance/(tenant_id)

Returns the settings in Performance group (filtered by tenant_id if provided).

Request

No payload

Response

A PerformanceSetting object

Samples

GET/api/advancedSetting/performanceHTTP/1.1

Sample response:

{"queryTimeoutValue":3600,"queryTimeoutDefaultValue":3600,"useNoLockValue":true,"useNoLockDefaultValue":true,"dataSourceLimitValue":1000,"dataSourceLimitDefaultValue":1000,"tenantId":null}

POST advancedSetting/performance

Updates the settings in Performance group.

Request

A PerformanceSetting object

Response

An OperationResult object with success fied true if the update is successful

Samples

POST/api/advancedSetting/performanceHTTP/1.1

Request payload to update Query Timeout to 360:

{"queryTimeoutValue":360,"useNoLockValue":true,"dataSourceLimitValue":1000,"tenantId":null}

Sample response:

{"success":true,"messages":null}

GET advancedSetting/security/(tenant_id)

Returns the settings in Security group (filtered by tenant_id if provided).

Request

No payload

Response

A SecuritySetting object

Samples

GET/api/advancedSetting/securityHTTP/1.1

Sample response:

{"tenantFieldValue":"TenantID;UserID","tenantFieldDefaultValue":"","showTenantFieldValue":true,"showTenantFieldDefaultValue":true,"setAdditiveFieldAutoVisibleValue":false,"setAdditiveFieldAutoVisibleDefaultValue":false,"setAdditiveFieldAutoFilterableValue":false,"setAdditiveFieldAutoFilterableDefaultValue":false,"tenantId":null,"tenantFields":[{"name":"TenantID","isSystem":true},{"name":"UserID","isSystem":true}],"allowShowTenant":true,"modified":"2017-02-15T06:31:15"}

POST advancedSetting/security

Updates the settings in Security group.

Request

A SecuritySetting object

Response

An OperationResult object with success field true if the update is successful

Samples

POST/api/advancedSetting/securityHTTP/1.1

Request payload to set Additive Fields Auto Visible:

{"showTenantFieldValue":true,"setAdditiveFieldAutoVisibleValue":true,"setAdditiveFieldAutoFilterableValue":false,"tenantId":null}

Sample response:

{"success":true,"messages":null}

GET advancedSetting/miscSetting/(tenant_id)

Returns the settings in Others group (filtered by tenant_id if provided).

Request

A Entity object

Response

An OtherSetting object

Samples

GET/api/advancedSetting/miscSettingHTTP/1.1

Sample response:

{"sortColumnNameValue":false,"sortColumnNameDefaultValue":false,"trimTimeInJoinsValue":true,"trimTimeInJoinsDefaultValue":true,"timezoneForDataOffsetValue":0,"timezoneForDataOffsetDefaultValue":0,"timezoneForTimestampOffsetValue":0,"timezoneForTimestampOffsetDefaultValue":0,"convertNullToEmptyStringValue":false,"convertNullToEmptyStringDefaultValue":false,"showSchemaNameValue":false,"showSchemaNameDefaultValue":false,"showIntroductionTextValue":false,"showIntroductionTextDefaultValue":false,"introductionTextValue":"","introductionTextDefaultValue":"","sendToDiskPathValue":"","sendToDiskPathDefaultValue":"","tenantId":null,"modified":"2017-02-15T07:29:25.3300651""hideReportHeaderAndFooterValue":true,"hideReportHeaderAndFooterDefaultValue":false}

POST advancedSetting/miscSetting

Updates the settings in Others group.

Request

An OtherSetting object

Response

An OperationResult object with success field true if the update is successful

Samples

POST/api/advancedSetting/miscSettingHTTP/1.1

Request payload to set Timezone Offset to -4:

{"sortColumnNameValue":false,"trimTimeInJoinsValue":true,"timezoneForDataOffsetValue":"-4","timezoneForTimestampOffsetValue":"0","convertNullToEmptyStringValue":false,"showSchemaNameValue":false,"showIntroductionTextValue":false,"introductionTextValue":"","sendToDiskPathValue":"","sortColumnNameDefaultValue":false,"trimTimeInJoinsDefaultValue":true,"timezoneForDataOffsetDefaultValue":0,"timezoneForTimestampOffsetDefaultValue":0,"convertNullToEmptyStringDefaultValue":false,"showSchemaNameDefaultValue":false,"showIntroductionTextDefaultValue":false,"introductionTextDefaultValue":"","sendToDiskPathDefaultValue":"","tenantId":null,"modified":"2017-02-15T07:29:25.3300651","hideReportHeaderAndFooterValue":true}

Sample response:

{"success":true,"messages":null}

POST advancedSetting/defaultImageUrl

Updates the default image url setting.

Request

Payload: an AdvancedSetting object

Response

The saved AdvancedSetting object with name field value “DefaultImageUrl”

Samples

POST/api/advancedSetting/defaultImageUrlHTTP/1.1

Payload:

{"value":"http://localhost/img/default.png","tenantId":null}

Response:

{"id":"c8ecf9fd-196d-44a3-90ec-97f393ebfc0c","name":"DefaultImageUrl","value":"http://localhost/img/default.png","defaultValue":null,"type":null,"tenantId":null,"deleted":false,"modified":"2017-04-12T16:55:11.4884228Z"}

GET advancedSetting/defaultImageUrl(?tenantId=tenant_id)

Returns the default image url setting.

Request

No payload

Optional querystring: ?tenantId=<the id of the tenant>

Response

An AdvancedSetting object

Samples

GET/api/advancedSetting/defaultImageUrlHTTP/1.1

Response:

{"id":"c8ecf9fd-196d-44a3-90ec-97f393ebfc0c","name":"DefaultImageUrl","value":"http://localhost/img/default.png","defaultValue":null,"type":null,"tenantId":null,"deleted":false,"modified":"2017-04-12T16:55:11.4900000+07:00"}

GET api/advancedSetting/defaultTheme(?tenantId=tenant_id)

Returns the default theme setting.

Request

No payload

Optional querystring: ?tenantId=<the id of the tenant>

Response

An AdvancedSetting object

Samples

GET/api/advancedSetting/defaultThemeHTTP/1.1

Response:

{"id":"04d46221-24e0-4363-b2f6-99370d85ebe6","name":"DefaultTheme","value":"Monte Carlo","defaultValue":null,"type":"Others","tenantId":null,"deleted":false,"modified":"2018-05-22T06:43:56.0000000+07:00"}

GET/api/advancedSetting/defaultTheme/c39a4500-b902-4e5b-ae86-901c09b71516HTTP/1.1

Response:

{"id":"06a83a57-39c0-44d4-841d-aa56e2d15ba7","name":"DefaultTheme","value":"Morning Sky","defaultValue":null,"type":"Others","tenantId":"c39a4500-b902-4e5b-ae86-901c09b71516","deleted":false,"modified":"2018-05-22T10:20:07.2700000+07:00"}

POST api/advancedSetting/defaultTheme

Add or update default theme for system or tenant.

Request

Payload: an AdvancedSetting object

Response

The saved AdvancedSetting object with name field value is “DefaultTheme”

Samples

POST/api/advancedSetting/defaultThemeHTTP/1.1

Response:

{"id":"04d46221-24e0-4363-b2f6-99370d85ebe6","name":"DefaultTheme","value":"Monte Carlo","defaultValue":null,"type":"Others","tenantId":null,"deleted":false,"modified":"2018-05-22T10:38:41.5779097Z"}