Get info for all database sources
GET {{baseUrl}}/api/datasources?id=Excepteur Lorem&database.type=generic&fields=Excepteur Lorem
Get information for all database sources. You obtain the authorization token needed to execute the request using POST /auth/login; you pass the authorization token in the request header. You can use query parameters to specify the datasource idsand the database types in form of list.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
id | string | Comma-separated string of datasources id | |
database.type | string | Comma-separated string of database types | |
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
[{"datasources":[{"name":"nulla do esse occaecat fugiat","id":"do dolor","description":"nisi mollit reprehe","dateCreated":"2006-09-26T04:35:58.686Z","dateModified":"2011-03-20T23:41:12.083Z","acg":-39928990,"datasourceType":"data_import","database":{"type":"google_big_query","version":"infobright_33","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"}}},"tablePrefix":"Du","odbcVersion":"version2x","intermediateStoreDbName":"occaecat commodo ad","intermediateStoreTableSpaceName":"dolor nulla id Ut nisi","dbms":{"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"}},"owner":{"name":"qu","id":"labore cillum ullamco"}},{"name":"consequat anim deserunt sit consectetur","id":"exercitation voluptate minim","description":"ad sed in incididun","dateCreated":"1972-09-16T01:24:01.740Z","dateModified":"1945-10-30T16:38:33.808Z","acg":46565285,"datasourceType":"data_import_primary","database":{"type":"netezza","version":"greenplum_3x","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"}}},"tablePrefix":"dolore do commodo","odbcVersion":"version2x","intermediateStoreDbName":"consequat irure","intermediateStoreTableSpaceName":"cillum labore quis Excepteur sint","dbms":{"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"}},"owner":{"name":"ipsum tempor magna aliqua","id":"id deserunt proident"}}]},{"datasources":[{"name":"cu","id":"eu voluptate et nulla","description":"aliqua mollit est esse","dateCreated":"1972-06-21T16:26:38.987Z","dateModified":"2019-09-04T10:08:30.729Z","acg":49330401,"datasourceType":"reserved","database":{"type":"metamatrix","version":"paypal","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"}}},"tablePrefix":"deserunt irure tempor","odbcVersion":"version3x","intermediateStoreDbName":"non deserunt aute","intermediateStoreTableSpaceName":"aliqua in Duis anim","dbms":{"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"}},"owner":{"name":"fugiat aliquip","id":"in reprehenderit dolor consectet"}},{"name":"velit","id":"deserunt Duis anim","description":"esse","dateCreated":"1960-04-07T02:54:54.640Z","dateModified":"1959-01-31T15:40:59.461Z","acg":17732355,"datasourceType":"reserved","database":{"type":"tm1","version":"sql_server_azure","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"}}},"tablePrefix":"do eiusmod","odbcVersion":"version2x","intermediateStoreDbName":"incididunt deserunt","intermediateStoreTableSpaceName":"dolor Duis","dbms":{"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"}},"owner":{"name":"laboris sit","id":"cupidatat si"}}]}]