Contents:
Get the list of accessible imported datasets for the authenticated user.
Version: v3
Required Permissions
NOTE: Each request to the Designer Cloud Powered by Trifacta® platform must include authentication credentials. See https://api.trifacta.com/ee/5.1/index.html#section/Authentication.
Request
Request Type: GET
Endpoint:
/v3/importedDatasets
Endpoint with embedded reference:
/v3/importedDatasets/?embed=connection
For more information, see API ImportedDatasets Get v3.
Endpoint with paged retrieval:
By default, this endpoint returns results in sets of 25.
You can apply query parameters to change the size of the default set and to page through result sets. The following example queries for results 100 at a time. In this case, the query asks for results 3-102:
/v3/importedDatasets?embed=connection&limit=100&offset=2
If the count of retrieved results is less than the limit, you have reached the end of the results.
Request Body:
Empty.
Response
Response Status Code - Success: 200 - OK
Response Body Example:
In the following example, you can see the data for three separate connections:
- JDBC with custom SQL query
- JDBC
- File-based (uploaded)
{
"data": [
{
"id": 15,
"size": "-1",
"path": null,
"isSharedWithAll": false,
"type": "jdbc",
"bucket": null,
"isSchematized": true,
"createdAt": "2017-02-03T07:34:40.727Z",
"updatedAt": "2017-02-03T07:34:43.910Z",
"createdBy": 1,
"updatedBy": 1,
"name": "all_objects",
"description": null,
"connection": {
"id": 2
},
"parsingRecipe": {
"id": 37
},
"relationalSource": {
"relationalPath": [
"adam_test",
"sys"
],
"columns": [
"name",
"object_id",
"principal_id",
"schema_id",
"parent_object_id",
"type",
"type_desc",
"create_date",
"modify_date",
"is_ms_shipped",
"is_published",
"is_schema_published"
],
"filter": null,
"raw": null,
"id": 1,
"tableName": "all_objects",
"createdAt": "2017-02-03T07:34:40.760Z",
"updatedAt": "2017-02-03T07:34:40.760Z",
"datasourceId": 15
}
},
{
"id": 14,
"size": "2049672",
"path": "/trifacta/uploads/1/1a0d9144-a0bc-44a2-ae93-fc3f53613930/base_type_map_array_record_large.avro",
"isSharedWithAll": false,
"type": "hdfs",
"bucket": null,
"isSchematized": true,
"createdAt": "2017-02-03T05:16:49.934Z",
"updatedAt": "2017-02-03T05:16:51.200Z",
"createdBy": 1,
"updatedBy": 1,
"name": "base_type_map_array_record_large.avro",
"description": null,
"parsingRecipe": {
"id": 35
}
},
{
"id": 13,
"size": "711558",
"path": "/trifacta/queryResults/administrator/hello_world/original_2_1_random_rows.json",
"isSharedWithAll": false,
"type": "s3",
"bucket": "3fac-jlong-test",
"isSchematized": false,
"createdAt": "2017-02-03T05:15:07.398Z",
"updatedAt": "2017-02-03T05:15:11.724Z",
"createdBy": 1,
"updatedBy": 1,
"name": "original_2_1_random_rows.json",
"description": null,
"parsingRecipe": {
"id": 33
}
}
]
}
Reference
For more information on the properties of an imported dataset, see API ImportedDatasets Get v3.
This page has no comments.