Page tree

Release 5.1


Contents:

   

For the latest updates on available API endpoints and documentation, see api.trifacta.com.

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.