DocumentationWorkfrontAdobe Workfront Fusion

Data store modules

Last update: Mon Feb 10 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

An Adobe Workfront Fusion data store, similar to a database or a simple table, can store data from scenarios, making it possible to transfer data between individual scenarios or scenario runs. You can use a data store to store new data from various systems during synchronization.

The data store modules enable you to add, replace, update, retrieve, delete, search, or count records in your Adobe Workfront Fusion data store.

For a video introduction to data stores in Workfront Fusion, see:

Access requirements

Expand to view access requirements for the functionality in this article.

You must have the following access to use the functionality in this article:

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
Adobe Workfront package Any
Adobe Workfront license

New: Standard

Or

Current: Work or higher
Adobe Workfront Fusion license** No Workfront Fusion license requirement.
Product

New:

  • Select or Prime Workfront package: Your organization must purchase Adobe Workfront Fusion.
  • Ultimate Workfront package: Workfront Fusion is included.

Or

Current: Your organization must purchase Adobe Workfront Fusion.

For more detail about the information in this table, see Access requirements in documentation.

For information on Adobe Workfront Fusion licenses, see Adobe Workfront Fusion licenses.

Prerequisites

To use Data Store modules, you must first create a data store.

For information on creating data stores, see Create and manage data stores.

Data store modules and their fields

When you configure Data Store modules, Workfront Fusion displays the fields listed below. Along with these, additional Data Store fields might display, depending on factors such as your access level in the app or service. A bolded title in a module indicates a required field.

You do not need to create a connection to use data stores.

If you see the map button above a field or function, you can use it to set variables and functions for that field. For more information, see Map information from one module to another.

Map toggle

Add/Replace a Record

This action module adds or replaces a record.

You specify the data store and the record’s key.

The module returns the ID of the record and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

NOTE
The module throws an error when you try to add a record which is already in the data store under the same name, and the Overwrite an existing record option is disabled.

When you are configuring this module, the following fields display.

Data store
Select or add the data store where you want to create a record.
Key
Enter the unique key of the record you want the module to add or replace. The key can be used later to retrieve the record. If you leave this field blank, a key is generated automatically.
Overwrite an existing record
Enable this option to overwrite the record. The record you want to overwrite must be specified in the Key field above.
Record
Enter the desired values to the record's fields.

Check the Existence of a Record

This action module specifies whether a particular record exists.

You specify the data store and the record’s key.

Data store
Select the data store you want to check for the record existence.
Key
Enter the unique key of the record you want the module to check for existence.

Count Records

This action module numbers the records in a data store.

You specify the data store.

When you are configuring this module, the following fields display.

Data store
Select the data store that contains the records you want to count.

Delete a Record

This action module deletes a record.

You specify the data store and the record’s key.

The module returns the ID of the record and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

Data store
Select the data store you want to check for the record existence.
Key
Enter the unique key of the record you want the module to delete.

Delete All Records

This action module deletes all records from a particular data store.

You specify the data store.

Data store
Select the data store you want to delete all records from.

Get a Record

This action module retrieves a record.

You specify the data store and the record’s key.

The module returns the ID of the record and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

Data store
Select the data store you want to retrieve a record from
Key
Enter the unique key of the record you want the module to retrieve.

Search Records

This search module looks for records in an object in Data Store that match the search query you specify.

You can map this information in subsequent modules in the scenario.

When you are configuring this module, the following fields display.

Data store
Select the data store you want to search.
Filter
Set the filter for the search.
Sort

For each field that you want to sort by, fill in the following fields:

Key

Select the column name you want to sort the results by.

Order

Select whether you want to sort results in the ascending or descending order.

Limit
Set the maximum number of search results Workfront Fusion returns during one execution cycle.
Continue the execution of the route even if the module returns no results
If enabled, the route that this module is part of continues processing even if this module returns no results.

Update a Record

This action module updates a record.

You specify the data store and the record’s key.

The module returns the ID of the record and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

When you are configuring this module, the following fields display.

Data store
Select or add the data store where you want to create a record.
Key
Enter the unique key of the record you want the module to update.
Insert missing record
Enable this option to create a new record if the record with the specified key doesn't already exist.
Record
Enter the desired values to the record's fields that you want to update.
recommendation-more-help
7e1891ad-4d59-4355-88ab-a2e62ed7d1a3