DataSource

[GET] /datasources/create

Response

Status Code: 200

Success

[GET] /api/datasource/provider/{provider}/userguide

Parameters

Name	Type	Located In
providerRequired	string	path

Response

Status Code: 200

Success

[GET] /datasources/edit/{id}

Parameters

Name	Type	Located In
id	string	query

Response

Status Code: 200

Success

[GET] /api/datasource/image/{filename}

Parameters

Name	Type	Located In
filenameRequired	string	path

Response

Status Code: 200

Success

binary

[GET] /api/datasource/edition

Response

Status Code: 200

Success

[POST] /api/datasource/mappingData

Parameters

Name	Type	Located In
edition	string	query

Response

Status Code: 200

Success

any

[GET] /api/datasource/schemas

Parameters

Name	Type	Located In
ids	string	query

Response

Status Code: 200

Success

[POST] /api/datasource/tableCollectionSchema

Request Schema

TableSchemaQueryViewModel

Response

Status Code: 200

Success

any

[GET] /api/datasource/tableSchema

Parameters

Name	Type	Located In
datasourceId	string	query
type	string	query
schema	string	query
tableName	string	query
version	string	query

Response

Status Code: 200

Success

ColumnViewModel

[POST] /api/datasource/schemas/sqltable

Request Schema

CustomSqlTablesSchemaViewModel

Response

Status Code: 200

Success

[POST] /api/datasource/databases

Request Schema

GetDatabasesRequestModel

Response

Status Code: 200

Success

[GET] /api/datasource/download/{id}

Parameters

Name	Type	Located In
idRequired	string	path

Response

Status Code: 200

Success

binary

[POST] /api/datasource/validateSqlExpression

Request Schema

ValidateSqlExpressionViewModel

Response

Status Code: 200

Success

ColumnViewModel

[POST] /api/datasource/evaluate-expression

Request Schema

ExpressionsViewModel

Response

Status Code: 200

Success

ExpressionsResultViewModel

[POST] /api/datasource/sqlexpressionGroupBy

Parameters

Name	Type	Located In
expression	string	query

Request Schema

DataSourceController+ChechGroupExpressionModel

Response

Status Code: 200

Success

ColumnViewModel

[POST] /api/datasource/sqlexpressionAggregation

Parameters

Name	Type	Located In
expression	string	query

Request Schema

DataSourceController+ChechGroupExpressionModel

Response

Status Code: 200

Success

ColumnViewModel

[POST] /api/datasource/schemadefinition

Request Schema

GetSchemaDefinitionViewModel

Response

Status Code: 200

Success

GetSchemaDefinitionReturnModel

[POST] /api/datasource/preQueryPreview

Request Schema

GetSchemaDefinitionViewModel

Response

Status Code: 200

Success

PreQueryPreviewResult

[GET] /api/datasource/mappingFileTemplate

Parameters

Name	Type	Located In
edition	string	query

Response

Status Code: 200

Success

binary

Models

Ƭ TableSchemaQueryViewModel

Name	Type	Description	Example
dataSourceIdNullable	string
schemaNullable	string
tableNameNullable	string
typeNullable	string
fullNameNullable	string

Ƭ ColumnViewModel

Name	Type	Description	Example
nameNullable	string
aliasNullable	string
dataTypeNullable	string
allowDBNull	Boolean
descriptionNullable	string
isContainTimeZone	Boolean

Ƭ CustomSqlTablesSchemaViewModel

Name	Type	Description	Example
tablesNullable	CustomSqlTableViewModel
parametersNullable	QueryParameterViewModel

Ƭ CustomSqlTableViewModel

Name	Type	Description	Example
datasourceNullable	string
nameNullable	string
queryType	QueryType
sqlCommandNullable	string
querySchemaNullable	string
procedureSchemaNullable	string
procedureNameNullable	string
procedureParametersNullable	CustomTableProcedureParameterViewModel

Ƭ QueryParameterViewModel

Name	Type	Description	Example
nameNullable	string
parameterTypeNullable	string
parameterValueNullable	string
parameterDefaultValueNullable	string
dataTypeNullable	string
multivalue	Boolean
tableNullable	string

Ƭ QueryType

Enum:

• Text
• StoredProcedure

Ƭ CustomTableProcedureParameterViewModel

Name	Type	Description	Example
parameterNameNullable	string
parameterTypeNullable	string
parameterModeNullable	string
parameterPositionNullable	string
parameterDefaultValueNullable	string
parameterValueTypeNullable	string
isOutResultSet	Boolean

Ƭ GetDatabasesRequestModel

Name	Type	Description	Example
providerNullable	string
connectionStringNullable	string

Ƭ ValidateSqlExpressionViewModel

Name	Type	Description	Example
datasourceIdNullable	string
selectedTableNameNullable	string
selectedTableSchemaNullable	string
expressionNullable	string
parametersNullable	QueryParameterViewModel

Ƭ ExpressionsResultViewModel

Name	Type	Description	Example
dataNullable	any
dataTypeNullable	string

Ƭ ExpressionsViewModel

Name	Type	Description	Example
expressionNullable	string

Ƭ DataSourceController+ChechGroupExpressionModel

Name	Type	Description	Example
expressionNullable	string
useCache	Boolean
parametersNullable	QueryParameterViewModel
commandModel	TableJoinQueryViewModel

Ƭ TableJoinQueryViewModel

Name	Type	Description	Example
firstTable	TableViewModel
joinRelationsNullable	JoinRelationViewModel

Ƭ TableViewModel

Name	Type	Description	Example
idNullable	string
tableTypeNullable	string
tableNameNullable	string
sqlNullable	string
querySchemaNullable	string
dataSourceIdNullable	string
unionTypeNullable	string
unionMapNullable	Array<object>
filtersNullable	FilterExpression
sQlExpressionsNullable	FieldViewModel
tablesNullable	TableViewModel

Ƭ JoinRelationViewModel

Name	Type	Description	Example
joinTypeNullable	string
table	TableViewModel
conditionsNullable	JoinConditionViewModel

Ƭ FilterExpression

Name	Type	Description	Example
typeNullable	string
tableNullable	string
columnNullable	string
expressionNullable	string
operatorNullable	string
valueNullable	Array
valueTypeNullable	string
targetTypeNullable	string
multivalue	Boolean

Ƭ FieldViewModel

Name	Type	Description	Example
tableNullable	string
columnNullable	string
aliasNullable	string
descriptionNullable	string
dataTypeNullable	string
dataVizAIHintNullable	string
formatNullable	string
fieldTypeNullable	string
aggregationNullable	string
rawTypeNullable	string
msDescriptionNullable	string
clrTypeNullable	string
isContainTimeZoneNullable	Boolean

Ƭ JoinConditionViewModel

Name	Type	Description	Example
leftColumn	JoinColumnViewModel
operatorNullable	string
rightColumn	JoinColumnViewModel

Ƭ JoinColumnViewModel

Name	Type	Description	Example
columnNameNullable	string
tableNameNullable	string

Ƭ GetSchemaDefinitionReturnModel

Name	Type	Description	Example
columnNamesNullable	Array<string>
rowsNullable	Array<array>

Ƭ GetSchemaDefinitionViewModel

Name	Type	Description	Example
providerNullable	string
connectionStringNullable	string

Ƭ PreQueryPreviewResult

Name	Type	Description	Example
tablesNullable	PreQueryPreviewResultTable

Ƭ PreQueryPreviewResultTable

Name	Type	Description	Example
tableNameNullable	string
schemaNameNullable	string
columnsNullable	PreQueryPreviewResultColumn
rowsNullable	RowData

Ƭ PreQueryPreviewResultColumn

Name	Type	Description	Example
columnNameNullable	string

Ƭ RowData

Name	Type	Description	Example
dataNullable	Array