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

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

What account should be used for API with query par...

How to dynamically update an account?

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?