Skip to main content Skip to complementary content

Data connection: Create

Information noteLOCKED.

This API is extremely reliable and will not be broken unless absolutely necessary.






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.

Information noteInformation that is returned from an API request may contain references to properties and values where the meaning of the value may not be self-evident, for example, status: 2 or architecture: 0. These values typically belong to an enumeration that is associated with the entity type specified in the API request; in these cases, it may be helpful to call the /qrs/about/api/enums API to get a complete list of the enumerations, which can give you insight into the meaning of these values. See About API: Get enums.


{ "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


Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!