Dataset Views
A Dataset View is a reference dataset that points to another dataset as its source. It lets you create a customized view for users within the application where the view resides. While a dataset view belongs to a single application, its source dataset can be from another application. Use dataset views to share data across applications without duplicating large datasets.
Create a Dataset View
Dataset views can only be created from shared datasets:
- Go to Data > Datasets and click New Dataset.
- Select the Shared Data tab and choose a shared dataset as the source.
- Click New Dataset View.
The owner and source app are displayed for each shared dataset.
View Dataset Views
- Go to Data > Datasets and locate the desired dataset.
Dataset views are identified by the Type property on the main Datasets page.
Customize Dataset Views
You cannot change the underlying data structure of a dataset view. Allowed actions:
- Show/hide columns
- Change column names
- Adjust column visualization formats
- Create geolocation groups
- Set column links
Restricted actions:
- Edit connection settings or source queries
- Create joins or transformations
- Change column data types or input formats
- Set unique identifiers
- Define sync schedules
Create a Dataset View via API
-
Choose a Shared Dataset:
- Use Qrvey Composer to share a dataset, or use an existing shared dataset.
- Or, use the API to mark a dataset as shared by sending
{ "isPublic": true }
in the request body:https://{{DOMAIN}}.qrveyapp.com/api/v4/user/{{USER_ID}}/app/{{APP_ID}}/qollect/dataset/{{DATASET_ID}}/publishVersion?runPublicTrigger=true
-
Get the shared dataset's
connectionId
using the Get Dataset endpoint. -
Create the Dataset View using the Create Dataset View from Shared Dataset endpoint.
Note: You’ll need the domain
, appId
, and datasetId
. In Qrvey Composer, open Apps > [Application] > Data > [Dataset] > Design and check the URL for these values:
https://{{DOMAIN}}.qrveyapp.com/app/index.html#/application/{{APP_ID}}/data-uploads/{{DATASET_ID}}