# Data sources

PRIVATE PREVIEW

Workato Insights is in private preview.

Private preview features are those that have passed the development phase and are now ready for customer testing. Our goal is to gather your input to ensure their reliable release in upcoming enhancements.

In the private preview release, Workato does not support import/export capabilities or deployments for Insights dashboards.

Insights supports a variety of data sources, including:

  • Workspace usage
    • Projects in all environments
    • Recipes in all environments
    • Job history with full job list of your entire workspace
  • Individual recipe job history, with custom columns
  • Data tables
  • Workflow apps

Data sourcesSelect a data source

The specific data sources available depend on your configured access in Workato. For example, you can only see data tables in the projects in which you can access.


# Available data

The following table describes the type of data available for each data source.

Data source Description Available data
Workspace usage (projects) View data related to all the projects in your workspace.
  • ID
  • Name
  • Created at
  • Updated at
  • Environment
Workspace usage (recipes) View data related to all recipes within your workspace.
  • ID
  • Project ID
  • Name
  • Task count
  • Job count
  • Successful job count
  • Failed job count
  • Environment
  • Is active
Workspace usage (full job history) View the full job history data for your workspace.
  • Job ID
  • Recipe ID
  • Recipe Name
  • Project ID
  • Project Name
  • Started at
  • Completed at
  • Is Completed
  • Is successful
  • Is test
  • Task count
Recipe job history View the recipe job history data for a recipe you specify.
  • Job ID
  • Started at
  • Completed at
  • Is complete
  • Is successful
  • Is test
  • Task count
  • All custom columns
Data tables View data from a data table you specify.
  • Record ID
  • Created time
  • Last modified time
  • Additional data. This additional data depends on the columns present in your data table.
Workflow apps View data from a workflow app you specify.
  • Record ID
  • Created time
  • Last modified time
  • Current stage
  • Current stage ID
  • Assigned to (the user or user group to which the request is assigned)
  • Assigned to user ID (the user ID, when the request is assigned to a user)
  • Assigned to user group ID (the group ID, when the request is assigned to a group)
  • Due on
  • Created by (name of the user who created the request)
  • Created by ID (the ID of the user who created the request)
  • Additional data. This additional data depends on the columns present in your workflow app's corresponding data table.

FURTHER READING


Last updated: 2/13/2024, 1:10:22 AM