Designing and Running Pipelines

Using Templates to drive Smartlink or JSON output

Has anyone figured out how to create Templates to drive the Target Schema in a mapper snap? This would be useful to standardize JSON output schema outputs and also reduce the time it takes to map outputs. If not can someone explain when and how a T...

Hold Rest Post Snap until all records uploaded

Hi, Below is my pipeline where iam trying to upload data from oracle execute query which returns 200k records. iam grouping them into 10k at a time to Rest Data Upload snap(rest post). My question - is there a way i can stay on Rest Data Upload snap ...

Parse Excel file with duplicate columns

Hi All, I have same column name multiple times in excel file. I want to parse all and load them into database but excel parser throws error of duplicate columns. Please suggest. Thanks

Reading Source file and target file and mapping data from source file to target file

Hi All, We have a requirement to read the data from source file and map it to target file where as the target file has to be taken as input file to read the structure(target columns) as target file structure is dynamic. Ex: Source File has columns A ...

Getting Snap aborted error when executing script file

Snap was aborted Hide Details… Script[5d35a4b567ad1a03d5af51a6_8067c2d5-703e-432b-a5aa-3dfe73595b42 – 99f07565-a279-430f-9660-184162b1c909] com.snaplogic.cc.snap.common.ThreadDetails: Waiting to receive data from s3.amazonaws.com/XX.XXX.XX.XX:XXX at ...

Mapper snap showing extra elements

In a pipeline custom snap is connected to a mapper snap. In the below screenshot left hand side is the data preview of custom snap and on right the input schema of mapper. The mapper is showing me the elements(as highlighted) that are not present in...

Queries in merging two tables

Good Day, We need to perform a simple activity where I used outer join and merge . The purpose of merge is to actually unite both the tables to proceed further . Since the entries present in the result table are not in source table , there are null e...

Most Efficient Way to Copy Values From Parent Object to Multi-Instance Child Object

Hi, I’m looking for the most efficient way to copy values from a parent object to a multi-instance child object. For instance, if I need start and end dates from an order header on the order lines. I should also add that I’d like to rename some of t...

SnapLogic - Integration Nation

Forum Posts

Using Templates to drive Smartlink or JSON output

Hold Rest Post Snap until all records uploaded

Parse Excel file with duplicate columns

Reading Source file and target file and mapping data from source file to target file

Getting Snap aborted error when executing script file

Mapper snap showing extra elements

Queries in merging two tables

Most Efficient Way to Copy Values From Parent Object to Multi-Instance Child Object

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings