Displaying Records For Values Provided Upstream

This example demonstrates how you can use upstream Snaps to control the data returned by the Workday Read Snap.

The Workday Read Snap doesn't necessarily need upstream Snaps. However, it can be used to leverage fields in the upstream data to retrieve and make available specific data from Workday to downstream Snaps.



Download this Pipeline

Example Overview

In this example, we shall retrieve Workday data related to specific workers and upload the received data to a SQL server.

  1. Review the table below to understand:
    • The tasks that must be performed to identify and transition data from Workday to SQL Server, based on specific criteria.
    • The Snaps that are used in the pipeline that effects this transition.
    • The task that each Snap performs.
  2. The following table shows the configuration details:
    Task Snap Description / Comments
    Read worker-related JSON data from an SLDB file. Read Data from SLDB ( File Reader Snap) Reads the Staff.JSON file from a shared folder in the SLDB.
    Retrieve a list of all worker IDs that are greater than 21040. Parse Data as JSON (JSON Parser) Converts the received file into a valid JSON format, so it can be managed properly.
    Filter User Data ( Filter Snap) Runs through the JSON data, seeking out all user IDs that are greater than 21040.
    Retrieve Workday data related to the filtered list of worker IDs. Map Data Fields (Mapper Snap) Maps data keys pertaining to the Worker ID type and value in the input JSON file to the corresponding column headers in the Workday DB table.
    Get Worker Data (Workday Read Snap) Retrieves worker data associated with the identified worker IDs from the Workday DB.
    Upload the returned data to SQL Map to SQL (Mapper Snap) Maps the keys present in the data received from Workday to column headers in the target SQL DB table.
    SQL Server BulkUpload (SQL Server - Bulk Load Snap) Uploads the mapped data into the identified SQL Server DB table.
  3. For details on the contents of each Snap, download and import the sample pipeline into SnapLogic.
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.