Flatten JSON files into CSV files
Created by @schelluri The pipeline pattern flattens a JSON file, which has multiple objects, and turns it into a CSV file. Configuration Sources: JSON Generator Targets: CSV file Snaps used: JSON Generator, JSON Formatter, JSON Parser, Script, CSV Formatter, File Writer Downloads MS_Flatten_Script.slp (31.4 KB)CSV to Workday Tenant
Submitted by @stodoroska from Interworks This pipeline reads a CSV file, parses the content, then the Workday Write Snap is used to call the web service operation Put_Applicant to write the data into a Workday tenant. Configuration If there is no lookup match in the SQL Server lookup table, we are using MKD as a default code for country code. Sources: CSV file on the File share system Targets: Workday tenant Snaps used: File Reader, CSV Parser, SQL Server - Lookup, Mapper, Union, Workday Write Downloads CSV2Workday.slp (17.3 KB)
New CSV in Box will create a new record in AWS Redshift
Created by @kjain This pipeline parses a CSV file in Box and creates a new record in Redshift. Configuration Provide value in update condition field in the Redshift - Update Snap. Example id = ‘5069829837’ Sources: Box Targets: Redshift Snaps used: Box Directory, Box Read, CSV Parser, Mapper, Redshift - Update Downloads Box_to_RedshiftUpdate.slp (6.9 KB)
Record new CSV file in Box to Google Sheets
Created by @skatpally SnapLogic moves a CSV file uploaded to Box into Google Sheets as a new row. Configuration Webhooks need to created by the Client Sources: CSV file in Box Targets: Google Sheet Snaps used: Box Read Snap, CSV Parser, WorkSheet Writer Downloads Record_new_CSV_file_in_Box_to_Google_Sheets.slp (5.0 KB)
