Data connection: Create
This API is extremely reliable and will not be broken unless absolutely necessary.
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
-