Retrieve Data
This operation returns the data for a data source.
Request Parameters
Name | Description |
slevel_Url_0 | Root level directory |
slevel_Url_1 | One folder level deep |
json.facet | Unicode Encoded Value |
Response Parameters
Name | Description |
Sum_Size | Value in Bytes |
Path Parameters
- datasourceId string required
Query Parameters
- wt string
- q string
- rows int32
Responses
- 200
OK
- application/json
- Schema
- Example (from schema)
- Retrieve Data
Schema
responseHeader object
response object
{
"responseHeader": {
"status": 0,
"QTime": 0,
"params": {
"q": "string",
"rows": "string",
"wt": "string"
}
},
"response": {
"numFound": 0,
"start": 0,
"docs": [
{
"Status": 0,
"Description": "string",
"Attribute": 0,
"CreateTime": "string",
"DataSourceGuid": "string",
"ModifiedBy": 0,
"OwnerUserID": 0,
"ModifiedTime": "string",
"DataSourceName": "string",
"DataSourceType": 0,
"CoreId": 0,
"DataSourceId": 0,
"contentid": "string",
"sea_push_counter": 0,
"data_source_type": "string",
"data_source_name": "string",
"data_source": "string",
"_version_": 0,
"timestamp": "string"
}
]
}
}
{
"responseHeader": {
"status": 0,
"QTime": 0,
"params": {
"q": "*:*",
"rows": "10",
"wt": "json"
}
},
"response": {
"numFound": 44,
"start": 0,
"docs": [
{
"Status": 0,
"Description": "",
"Attribute": 0,
"CreateTime": "2017-02-06 21:36:50.097",
"DataSourceGuid": "F26E21D4-0191-4E2E-87BE-9070A34DAB23",
"ModifiedBy": 2,
"OwnerUserID": 2,
"ModifiedTime": "2017-02-06 21:36:52.28",
"DataSourceName": "ContentStore",
"DataSourceType": 5,
"CoreId": 1,
"DataSourceId": 1,
"contentid": "94951ae0-5d65-41a4-9111-e5485f2bec85",
"sea_push_counter": 0,
"data_source_type": "jdbc",
"data_source_name": "DBSample",
"data_source": "84",
"_version_": 1580899376996286500,
"timestamp": "2017-10-10T19:18:52.665Z"
},
{
"Status": 0,
"Description": "",
"Attribute": 0,
"CreateTime": "2017-02-06 21:42:09.617",
"DataSourceGuid": "4935AEA1-39C9-479D-ABB7-A71203882000",
"ModifiedBy": 2,
"OwnerUserID": 2,
"ModifiedTime": "2017-02-06 21:44:45.607",
"DataSourceName": "BankCustomers",
"DataSourceType": 4,
"CoreId": 3,
"DataSourceId": 3,
"contentid": "c182c42e-b07a-429c-bc86-2db1e5ddeaae",
"sea_push_counter": 0,
"data_source_type": "jdbc",
"data_source_name": "DBSample",
"data_source": "84",
"_version_": 1580899377454514200,
"timestamp": "2017-10-10T19:18:53.111Z"
},
{
"Status": 0,
"Description": "",
"Attribute": 0,
"CreateTime": "2017-02-06 22:50:25.963",
"DataSourceGuid": "FE9E1794-F9E4-4EF5-9100-B0129E9C112B",
"ModifiedBy": 2,
"OwnerUserID": 2,
"ModifiedTime": "2017-02-06 22:51:23.82",
"DataSourceName": "GlobalSuperstore",
"DataSourceType": 4,
"CoreId": 4,
"DataSourceId": 4,
"contentid": "560318f3-adad-4eb9-a9c3-ddf2481b680f",
"sea_push_counter": 0,
"data_source_type": "jdbc",
"data_source_name": "DBSample",
"data_source": "84",
"_version_": 1580899377484923000,
"timestamp": "2017-10-10T19:18:53.143Z"
},
{
"Status": 0,
"Description": "",
"Attribute": 0,
"CreateTime": "2017-02-07 16:31:16.017",
"DataSourceGuid": "351943EE-6568-44E1-8DC1-BEA1CD565170",
"ModifiedBy": 2,
"OwnerUserID": 2,
"ModifiedTime": "2017-02-07 16:42:56.08",
"DataSourceName": "DevshareCSV",
"DataSourceType": 4,
"CoreId": 6,
"DataSourceId": 6,
"contentid": "e6718ddf-8df4-4ae4-adbd-90ca1010775d",
"sea_push_counter": 0,
"data_source_type": "jdbc",
"data_source_name": "DBSample",
"data_source": "84",
"_version_": 1580899377519526000,
"timestamp": "2017-10-10T19:18:53.163Z"
},
{
"Status": 0,
"Description": "",
"Attribute": 0,
"CreateTime": "2017-02-08 01:11:41.477",
"DataSourceGuid": "790B372C-1DAB-4DA2-AC0C-BBC441762480",
"ModifiedBy": 2,
"OwnerUserID": 2,
"ModifiedTime": "2017-02-08 01:11:41.603",
"DataSourceName": "TestFederated",
"DataSourceType": 10,
"CoreId": 7,
"DataSourceId": 7,
"contentid": "97131bba-be25-482e-befa-4bb7f98e56d4",
"sea_push_counter": 0,
"data_source_type": "jdbc",
"data_source_name": "DBSample",
"data_source": "84",
"_version_": 1580899377525817300,
"timestamp": "2017-10-10T19:18:53.173Z"
},
{
"Status": 0,
"Description": "",
"Attribute": 0,
"CreateTime": "2017-02-08 19:11:29.177",
"DataSourceGuid": "884D3726-5B73-4D1E-A57F-4FD53B2DF538",
"ModifiedBy": 2,
"OwnerUserID": 2,
"ModifiedTime": "2017-02-08 19:11:29.45",
"DataSourceName": "VaultCxDocuments",
"DataSourceType": 5,
"CoreId": 9,
"DataSourceId": 9,
"contentid": "a03a9e34-86fd-4092-895a-68213d116707",
"sea_push_counter": 0,
"data_source_type": "jdbc",
"data_source_name": "DBSample",
"data_source": "84",
"_version_": 1580899377540497400,
"timestamp": "2017-10-10T19:18:53.183Z"
},
{
"Status": 0,
"Description": "",
"Attribute": 0,
"CreateTime": "2017-02-09 15:20:36.647",
"DataSourceGuid": "E54D7692-15E7-4F55-BC03-510888ACE7CE",
"ModifiedBy": 2,
"OwnerUserID": 2,
"ModifiedTime": "2017-02-09 15:28:06.163",
"DataSourceName": "PerfCounters",
"DataSourceType": 4,
"CoreId": 10,
"DataSourceId": 10,
"contentid": "dd20cbc1-2e2f-4cc5-bbe0-97b2ec8dee5e",
"sea_push_counter": 0,
"data_source_type": "jdbc",
"data_source_name": "DBSample",
"data_source": "84",
"_version_": 1580899377548886000,
"timestamp": "2017-10-10T19:18:53.191Z"
},
{
"Status": 0,
"Description": "",
"Attribute": 0,
"CreateTime": "2017-02-14 19:54:21.9",
"DataSourceGuid": "27AA7ED5-4706-4A74-8FFE-D1E66DE345EF",
"ModifiedBy": 2,
"OwnerUserID": 2,
"ModifiedTime": "2017-02-14 19:56:44.513",
"DataSourceName": "FlightDetails",
"DataSourceType": 4,
"CoreId": 12,
"DataSourceId": 12,
"contentid": "3be75f1e-07a5-49f8-aea2-afe31c5ac991",
"sea_push_counter": 0,
"data_source_type": "jdbc",
"data_source_name": "DBSample",
"data_source": "84",
"_version_": 1580899377554129000,
"timestamp": "2017-10-10T19:18:53.197Z"
},
{
"Status": 0,
"Description": "",
"Attribute": 0,
"CreateTime": "2017-02-22 00:15:38.437",
"DataSourceGuid": "1CDAF83F-4FA8-4817-82CD-6C3B62F39A56",
"ModifiedBy": 2,
"OwnerUserID": 2,
"ModifiedTime": "2017-02-22 00:15:38.54",
"DataSourceName": "FileSystemFederated",
"DataSourceType": 10,
"CoreId": 18,
"DataSourceId": 18,
"contentid": "ba2e453d-4223-4340-97ba-a23f4693dbbc",
"sea_push_counter": 0,
"data_source_type": "jdbc",
"data_source_name": "DBSample",
"data_source": "84",
"_version_": 1580899377559371800,
"timestamp": "2017-10-10T19:18:53.202Z"
},
{
"Status": 0,
"Description": "",
"Attribute": 0,
"CreateTime": "2017-02-22 05:00:44.667",
"DataSourceGuid": "CE472079-7764-4675-A8F2-D599E2DF488A",
"ModifiedBy": 1,
"OwnerUserID": 1,
"ModifiedTime": "2017-02-22 05:02:47.34",
"DataSourceName": "tantest",
"DataSourceType": 4,
"CoreId": 19,
"DataSourceId": 19,
"contentid": "99c13ef7-f41e-443b-bad7-72f1ba52bc9a",
"sea_push_counter": 0,
"data_source_type": "jdbc",
"data_source_name": "DBSample",
"data_source": "84",
"_version_": 1580899377562517500,
"timestamp": "2017-10-10T19:18:53.204Z"
}
]
}
}
GET /dcube/search/:datasourceid/select
Authorization
type: apiKeyname: Authtokenin: header
Request
Request
curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/dcube/search/:datasourceId/select' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'
curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/dcube/search/:datasourceId/select' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'
curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/dcube/search/:datasourceId/select' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'
curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/dcube/search/:datasourceId/select' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'
curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/dcube/search/:datasourceId/select' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'
curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/dcube/search/:datasourceId/select' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'
curl -L -X GET 'https://CommandCenterHostName/commandcenter/api/dcube/search/:datasourceId/select' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>'