LogoLogo
Home
  • Verb Documentation
  • Release Notes
  • Environment Settings
    • Authentication
      • Authentication Endpoint
  • Data Sources
    • Ingestion Methods
    • Table Sync Intervals
    • Data Source Integrations
      • Network Permissions
      • Microsoft SQL Server
      • PostgreSQL
      • MongoDB
      • Snowflake
      • Elasticsearch
      • DynamoDB
      • Google BigQuery
      • Firebase Cloud Firestore
      • Supabase
      • Cloud Files
      • Flat Files
    • Data Synchronization
      • Synchronization Methods
        • Full Synchronization
        • Incremental Synchronization
        • Change Tracking
        • Change Data Capture
      • Synchronization Intervals
      • Synchronization Status
        • Pausing and Resuming
      • Synchronization History
      • Schema Changes
      • Row Filtering
      • Schemaless & NoSQL
      • Managing Connections
      • Troubleshooting
  • Models
    • What is a Model
      • Elements of a Model
      • Model Management
    • Building a Model
      • Add/Remove Data
      • Relationships
      • Row-Level Security
      • Transformations
    • Advanced Model Information
      • Database Keys
      • Unstructured Data
      • Publishing Updates
      • Troubleshooting
      • Automatic Modeling
  • Data Transformations
    • What is a Transformation
      • Elements of a Transformation
      • Transformation Management
    • Building Transformations
      • Creating Transformations
      • Configure Transformation Steps
      • Transformation Steps
        • Calculator
        • Manipulate Text
        • Map Values
        • Remove Duplicates
        • Date Operation
        • Select Columns
        • Change Type
        • Group Data
        • Filter Data
        • Join Data
        • Append Rows
        • Pivot Data
        • Rank Data
        • Window Data
      • Complete and Publish
  • Collections
    • What is a Collection
      • Elements of a Collection
    • Building Collections
    • API Collections
      • Building API Collections
        • Connect Data Sources
        • Data Model
        • Select Data
        • Authentication and Security
        • Data Access API Keys
        • Data Access API Documentation
      • API Collection Versions
    • Advanced Collection Options
      • Time Zones
      • Currency Symbols
  • Tiles
    • What is a Tile
      • Elements of a Tile
    • Tile Management
      • Tile Data
    • Tile Actions
    • Custom Date Formats
    • Currency Conversion
  • Design Themes
    • What is a Design Theme
    • General Theme Settings
    • Data Visualization Settings
  • Account Settings
    • Integrations
      • Slack
  • Legal
    • Terms of Use
    • Privacy Policy
    • Subscription Agreement Terms
    • Subscription Agreement
    • Data Processing Addendum
Powered by GitBook
On this page
  • Configure Fields
  • Set Collection Filters

Was this helpful?

  1. Collections
  2. API Collections
  3. Building API Collections

Select Data

The third step in creating a Data Access API

PreviousData ModelNextAuthentication and Security

Last updated 4 years ago

Was this helpful?

To select the data that you would like to share with your end-users you’ll create an API collection. You must have your data sources and a model created in order to create a collection. However, you can easily refine your model if there is missing data or you need different data accomplished with a data transformation.

Configure Fields

You will select the fields to include in your API Collection on the Fields tab using the Add Field buttons. The actual values section will always show the non-aggregated data and aggregated fields will allow you to select the aggregation types.

To adjust the name of the field or the aggregation type select configure on the individual field. You may reorder the fields within their section (Actual or Aggregated fields). Actual fields will always be listed before the Aggregated fields.

Set Collection Filters

You may define filters that end-user are allowed to use in their requests. A filter can be set on fields that are dates, text, numbers or Boolean.

To create filters for users go to the Filters tab on the collection page and select the Add New Filter button. Then select the type of data and the field to filter on. You will need to select the default filter criteria in case the request does not contain filter criteria.

Filters are shown in the UI of the collection page for your convenience in testing.

Data Access API Collection field configurations
Data Access API Collection filter creation