2022.2

Update Data Records
The Update Data Records action task updates records in the OL Connect Database using values from
the current Metadata or from JSON.
Each of the OLConnect Content Creation tasks can do the same, if the Update Records from Metadata
option is enabled for that task.
The Update Data Records task can be useful when data needs to be updated multiple times before
actually generating content, for instance when Postal Address Cleansing and Sorting is a two-pass pro-
cess.
Input
The current Job File is not used by this task. In order to update values in the Connect database, the
task requires that the current Metadata contains record IDs, or that the given JSON contains a JSON
Record Data List (see: "Types of JSON in Workflow" on page77 and ).
Processing
The records, of which the IDs are found in the source data, are updated either from the Metadata or
from JSON.
Note: Date strings conforming to ISO 8601 are parsed and stored in the OL Connect database as
Unix timestamps, i.e. the total number of seconds from the starting time of UTC (Universal Time,
Coordinated) to the current time (with zero time zone offset). For instance: 1675950179.
Output
The Job File is not changed by this task.
Task properties
General Tab
l
Update Source: Select the data source from which the records in the Connect database will be
updated.
l
Metadata: Select this option to use the current content of the Metadata.
l
JSON: Enter a JSON string, or a variable containing JSON. (See "Variable task properties"
on page289.) The task expects a JSON Record Data List; see: "Types of JSON in Work-
flow" on page77.
OL Connect Proxy Tab
This tab is common to all OL Connect tasks and defines where to process the jobs sent through these
tasks. When these fields are empty, they use the defaults set in the "OL Connect preferences" on
page654.
Page 544