Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

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

Version: v3

Required Permissions

D s api auth

Request

Request Type: GET

Endpoint:

Code Block
/v3/importedDatasets

Endpoint with embedded reference:

Code Block
/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 201-300:

Code Block
/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)
Code Block
{
  "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.