Data connection: Create

Method

POST

Path

/qrs/dataconnection/

Description

Data connections enable you to select and load data from a data source and provide a way to save shortcuts to the data sources you commonly use such as databases, local files, or remote files.

Body

{
    "name": "ExcelTest",
    "connectionstring": "C:\\Users\\abc\\Downloads\\CreateSimpleApp_ExampleFiles\\",
    "type": "folder",
    "username": "",
    "privileges": null
}

In this example, the connectionstring property points to a folder containing a data file.

Return value

{
    "id": "2972ab89-c008-4fd4-8777-cb95e5483d5f",
    "createdDate": "2021-12-09T14:21:04.547Z",
    "modifiedDate": "2021-12-09T14:21:04.547Z",
    "modifiedByUserName": "INTERNAL\\sa_repository",
    "customProperties": [],
    "owner": {
        "id": "9709bf4f-5ccb-4e88-9374-963fcfedb82a",
        "userId": "sa_repository",
        "userDirectory": "INTERNAL",
        "name": "sa_repository",
        "privileges": null
    },
    "name": "ExcelTest",
    "connectionstring": "C:\\Users\\abc\\Downloads\\CreateSimpleApp_ExampleFiles\\",
    "type": "folder",
    "engineObjectId": "",
    "username": "",
    "password": "",
    "logOn": 0,
    "architecture": 0,
    "tags": [],
    "privileges": null,
    "schemaPath": "DataConnection"
}

Optional parameters

-