Page tree

 

Contents:


Get the list of accessible imported datasets for the authenticated user.

Version: v3

Required Permissions

NOTE: Each request to the Trifacta® platform must include authentication credentials. See API 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.