Retrieving Data Modifications

Retrieving data modifications in a date range becomes much more effective if you use the Transaction Logs service. This way, instead of querying all data for the specified date range, Workday can use the transaction logs for the same date range and only compare records modified within the date range. This example demonstrates how this can be done.



Download this Pipeline
  1. Review the pipeline structure before configuring the Snaps.

    This pipeline is structured as follows:

    To use the Transaction Logs service in the Workday Read Snap, you must first pass the following Transaction Log criteria into the Workday Read Snap:

    • Date range
    • Modified entity's name
    • Modified entity's value
  2. Configure the Mapper Snap to pass the three Transaction Log criteria to the Workday Read Snap.

    Configure the Mapper Snap field mappings for the Transaction Log criteria as shown below:



    The output from the Mapper Snap is as shown below:



  3. In the Workday Read Snap settings, set the Output field for the Transaction Logs service to True.

    To use a Workday service, the Workday Read Snap's Output field must be configured to set the service to True:



  4. Run the pipeline to retrieve only the records modified within the specified date range.

    The output from the Workday Read Snap is as shown below:



    Below is a screenshot of the Workday Read Snap output without using the Transaction Log service:



    Comparing both outputs, you can see that using the Transaction Logs service is much more efficient.

To reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.