Get a datasource connection for given ID
GET {{baseUrl}}/api/datasources/connections/:id?fields=Excepteur Lorem
Get a datasource connection for given id. You obtain the authorization token needed to execute the request using POST /auth/login. You pass the authorization token in the request header. You specify the database source ID in the path of the request; you obtain the datasource login ID using GET /datasources/connections
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
fields | string | Comma separated top-level field whitelist. This allows client to selectively retrieve part of the response model. If specified, extra filtering will be applied, and for top-level object (if root model is an array, each array element), only the listed fields will be kept in the response. e.g. "id,elements" means to keep only the "id" field and the whole "elements" array field, omitting all other fields of top-level response model. |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
X-MSTR-AuthToken | string | (Required) Authorization token |
RESPONSES
status: OK
{"name":"fugiat ut quis","id":"in enim","description":"labore est dolor","acg":36112950,"executionMode":"synchronous","maxCancelAttemptTime":60,"maxQueryExeTime":0,"maxConnectionAttemptTime":60,"connectionLifetime":36000,"connectionIdleTimeout":60000,"charEncodingWindows":"multibyte","charEncodingUnix":"utf8","tablePrefix":"pariatur quis sint","connectionString":"officia","parameterizedQueries":false,"extendedFetch":false,"database":{"type":"search_engine","version":"oracle_8003","connection":{"id":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"name":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}},"primaryDatasource":{"id":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"name":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}},"dataMartDatasource":{"id":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"name":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}}},"driverType":"odbc","oauthParameter":"sunt culpa exercitation amet"}