Dokumentation der API-Endpunkte
| id required | integer <int32> |
| type required | string Enum: "DOMAIN" "CATEGORY" "TABLE" "QS_RULE" "COMMAND" "DEPLOYMENT_SET" "TASK" |
| uuid required | string <uuid> |
| includeRequired | boolean Default: true |
| includeRelated | boolean Default: false |
| id required | integer <int32> |
| type required | string Enum: "DOMAIN" "CATEGORY" "TABLE" "QS_RULE" "COMMAND" "DEPLOYMENT_SET" "TASK" |
| uuid required | string <uuid> |
| includeRequired | boolean Default: true |
| includeRelated | boolean Default: false |
| id required | integer <int32> |
| id | integer <int32> |
| name | string |
| uuid | string <uuid> |
{- "id": 0,
- "name": "string",
- "uuid": "095be615-a8ad-4c33-8e9c-c7612fbf6c9f"
}| taskId required | integer <int32> |
| id | integer <int32> |
| uuid | string <uuid> |
| name | string |
object | |
QsMailTaskParameters (object) | |
| type required | string |
{- "id": 0,
- "uuid": "095be615-a8ad-4c33-8e9c-c7612fbf6c9f",
- "name": "string",
- "options": {
- "commandId": 0
}, - "defaultParameters": {
- "type": "string",
- "recipients": [
- "string"
]
}, - "type": "string"
}| taskId required | integer <int32> |
| triggerId required | integer <int32> |
| id | integer <int32> |
| taskId | integer <int32> |
| name | string |
QsMailTaskParameters (object) | |
object | |
| type required | string |
{- "id": 0,
- "taskId": 0,
- "name": "string",
- "taskParameters": {
- "type": "string",
- "recipients": [
- "string"
]
}, - "options": {
- "cronExpression": "string"
}, - "type": "string"
}| id | integer <int32> |
| uuid | string <uuid> |
| name | string |
object | |
QsMailTaskParameters (object) | |
| type required | string |
{- "id": 0,
- "uuid": "095be615-a8ad-4c33-8e9c-c7612fbf6c9f",
- "name": "string",
- "options": {
- "commandId": 0
}, - "defaultParameters": {
- "type": "string",
- "recipients": [
- "string"
]
}, - "type": "string"
}| taskId required | integer <int32> |
| id | integer <int32> |
| taskId | integer <int32> |
| name | string |
QsMailTaskParameters (object) | |
object | |
| type required | string |
{- "id": 0,
- "taskId": 0,
- "name": "string",
- "taskParameters": {
- "type": "string",
- "recipients": [
- "string"
]
}, - "options": {
- "cronExpression": "string"
}, - "type": "string"
}| commandId required | integer <int32> |
| commandId | integer <int32> |
| uuid | string <uuid> |
| tableId | integer <int32> |
| commandName | string |
| commandExec | string |
| commandType | string Enum: "EXEC" "DB_PROCEDURE" "WEBSERVICE" |
| qsRuleViolationPolicy | string Enum: "NEVER_DENY" "DENY_ON_ERROR" "DENY_ON_WARNING" "DENY_ON_INFO" "DENY_ON_ANY" |
| qsRuleTimeoutSeconds | integer <int32> |
{- "commandId": 0,
- "uuid": "095be615-a8ad-4c33-8e9c-c7612fbf6c9f",
- "tableId": 0,
- "commandName": "string",
- "commandExec": "string",
- "commandType": "EXEC",
- "qsRuleViolationPolicy": "NEVER_DENY",
- "qsRuleTimeoutSeconds": 0
}| commandId | integer <int32> |
| uuid | string <uuid> |
| tableId | integer <int32> |
| commandName | string |
| commandExec | string |
| commandType | string Enum: "EXEC" "DB_PROCEDURE" "WEBSERVICE" |
| qsRuleViolationPolicy | string Enum: "NEVER_DENY" "DENY_ON_ERROR" "DENY_ON_WARNING" "DENY_ON_INFO" "DENY_ON_ANY" |
| qsRuleTimeoutSeconds | integer <int32> |
{- "commandId": 0,
- "uuid": "095be615-a8ad-4c33-8e9c-c7612fbf6c9f",
- "tableId": 0,
- "commandName": "string",
- "commandExec": "string",
- "commandType": "EXEC",
- "qsRuleViolationPolicy": "NEVER_DENY",
- "qsRuleTimeoutSeconds": 0
}| tableId required | integer <int32> |
| uuid | string <uuid> |
| attributes | object (Attributes) |
| categoryId | integer <int32> |
| tableName | string |
| sortOrder | integer <int32> |
| hasDataPermissions | boolean |
| inMemory | boolean |
object (TableGrants) |
{- "uuid": "095be615-a8ad-4c33-8e9c-c7612fbf6c9f",
- "attributes": { },
- "categoryId": 0,
- "tableName": "string",
- "sortOrder": 0,
- "hasDataPermissions": true,
- "inMemory": true,
- "grants": {
- "allowInsert": true,
- "allowUpdate": true,
- "allowDelete": true,
- "allowImport": true,
- "allowExport": true,
- "allowInlineEdit": true,
- "allowTruncate": true
}
}| tableId required | integer <int32> |
| columnId required | integer <int32> |
| uuid | string <uuid> |
| attributes | object (Attributes) |
| columnName | string |
| dataType | string |
| dataPrecision | integer <int32> |
| dataScale | integer <int32> |
| primaryKey | boolean |
| visible | boolean |
| writable | boolean |
| domainId | integer <int32> |
| domainInput | string |
| sortDir | string |
| sortOrder | integer <int32> |
{- "uuid": "095be615-a8ad-4c33-8e9c-c7612fbf6c9f",
- "attributes": { },
- "columnName": "string",
- "dataType": "string",
- "dataPrecision": 0,
- "dataScale": 0,
- "primaryKey": true,
- "visible": true,
- "writable": true,
- "domainId": 0,
- "domainInput": "string",
- "sortDir": "string",
- "sortOrder": 0
}object (GenericTableInput) | |
Array of objects (GenericColumnInput) |
{- "table": {
- "uuid": "095be615-a8ad-4c33-8e9c-c7612fbf6c9f",
- "attributes": { },
- "categoryId": 0,
- "tableName": "string",
- "sortOrder": 0,
- "hasDataPermissions": true,
- "inMemory": true,
- "grants": {
- "allowInsert": true,
- "allowUpdate": true,
- "allowDelete": true,
- "allowImport": true,
- "allowExport": true,
- "allowInlineEdit": true,
- "allowTruncate": true
}
}, - "columns": [
- {
- "uuid": "095be615-a8ad-4c33-8e9c-c7612fbf6c9f",
- "attributes": { },
- "columnName": "string",
- "dataType": "string",
- "dataPrecision": 0,
- "dataScale": 0,
- "primaryKey": true,
- "visible": true,
- "writable": true,
- "domainId": 0,
- "domainInput": "string",
- "sortDir": "string",
- "sortOrder": 0
}
]
}| tableId required | integer <int32> |
| uuid | string <uuid> |
| attributes | object (Attributes) |
| columnName | string |
| dataType | string |
| dataPrecision | integer <int32> |
| dataScale | integer <int32> |
| primaryKey | boolean |
| visible | boolean |
| writable | boolean |
| domainId | integer <int32> |
| domainInput | string |
| sortDir | string |
| sortOrder | integer <int32> |
[- {
- "uuid": "095be615-a8ad-4c33-8e9c-c7612fbf6c9f",
- "attributes": { },
- "columnName": "string",
- "dataType": "string",
- "dataPrecision": 0,
- "dataScale": 0,
- "primaryKey": true,
- "visible": true,
- "writable": true,
- "domainId": 0,
- "domainInput": "string",
- "sortDir": "string",
- "sortOrder": 0
}
]| file required | string <binary> |
object (FileParserParameters) |
{- "file": "string",
- "parserParameters": {
- "separator": "string",
- "skipHeaderLines": 0,
- "skipFooterLines": 0,
- "noHeader": true
}
}| tableId required | integer <int32> |
| file required | string <binary> |
required | object (FileParserParameters) |
{- "file": "string",
- "parserParameters": {
- "separator": "string",
- "skipHeaderLines": 0,
- "skipFooterLines": 0,
- "noHeader": true
}
}| tableId required | integer <int32> |
| fileId required | integer <int32> |
required | object (FileParserParameters) | ||||||||
| |||||||||
{- "parserParameters": {
- "separator": "string",
- "skipHeaderLines": 0,
- "skipFooterLines": 0,
- "noHeader": true
}
}| tableId required | integer <int32> |
| fileId required | integer <int32> |
required | object (FileParserParameters) |
| sheetName | string |
required | object (SheetImportParameters) |
{- "parserParameters": {
- "separator": "string",
- "skipHeaderLines": 0,
- "skipFooterLines": 0,
- "noHeader": true
}, - "sheetName": "string",
- "importParameters": {
- "importMode": "INSERT",
- "mappingByTargetColumn": {
- "property1": {
- "mode": "UNMAPPED",
- "staticValue": "string",
- "sourceColumn": "string"
}, - "property2": {
- "mode": "UNMAPPED",
- "staticValue": "string",
- "sourceColumn": "string"
}
}
}
}| tableId required | integer <int32> |
required | object (FileParserParameters) | ||||||||
| |||||||||
{- "parserParameters": {
- "separator": "string",
- "skipHeaderLines": 0,
- "skipFooterLines": 0,
- "noHeader": true
}
}| tableId required | integer <int32> |
| sheetName | string |
required | object (SheetImportParameters) |
{- "sheetName": "string",
- "importParameters": {
- "importMode": "INSERT",
- "mappingByTargetColumn": {
- "property1": {
- "mode": "UNMAPPED",
- "staticValue": "string",
- "sourceColumn": "string"
}, - "property2": {
- "mode": "UNMAPPED",
- "staticValue": "string",
- "sourceColumn": "string"
}
}
}
}| includeLocalObjects | boolean Default: true |
| skipDdl | boolean Default: false |
| allowDrop | boolean Default: false |
| file required | string <binary> |
{- "file": "string"
}| includeLocalObjects | boolean Default: true |
| skipDdl | boolean Default: false |
| allowDrop | boolean Default: false |
| repositoryUrlWithCredentials | string |
| branchOrTag | string |
| pathInRepository | string |
{- "repositoryUrlWithCredentials": "string",
- "branchOrTag": "string",
- "pathInRepository": "string"
}| includeLocalObjects | boolean Default: true |
| skipDdl | boolean Default: false |
| allowDrop | boolean Default: false |
| repositoryUrlWithCredentials | string |
| branchOrTag | string |
| pathInRepository | string |
{- "repositoryUrlWithCredentials": "string",
- "branchOrTag": "string",
- "pathInRepository": "string"
}| incremental | boolean Default: false |
| deploymentSetId | integer <int32> |
| repositoryUrlWithCredentials | string |
| branch | string |
| pathInRepository | string |
| targetBranch | string |
| authorName | string |
| authorEmail | string |
| forcePush | boolean |
{- "repositoryUrlWithCredentials": "string",
- "branch": "string",
- "pathInRepository": "string",
- "targetBranch": "string",
- "authorName": "string",
- "authorEmail": "string",
- "forcePush": true
}