Designing and Running Pipelines

Resolved! Filtering Out A List Of Unique Identifiers From Output Document

Hi, I have an output document in SnapLogic Designer and I also have an excel file. I want to remove the records from the output document that match the ID fields in the excel document. Since it is not a fixed value that I want to filter out and since...

Resolved! How to split a value into multiple fields

Hello, Say I have a .csv with the following row: value1_value2_value3_value4_value5 How can I split the string by “_” so each value can be mapped to its own field? I basically need to do stuff with each record, but through the Mapper I can’t seem to ...

Redshift bulk load preview showing no failed record counts but not loading records to tables

Hi All, I am trying to load data to Redshift table using Redshift bulk load snap. Upstream documents has preview with proper data and bulk load snap showing no error view and showing success count as 50 and failed count as 0 with proper table and sch...

Need to identify count of a character appearance in a string

Hi all, I have a scenario where upstream document has a string field like below. In this string ‘:’ can appear for some records. All I need to find is how many times ‘:’ appears in the string for each record to pass the count. Eg: fjhfjh:jfhjhgg:ouer...

How to audit payload in pipeline?

Hi all, I’m new to SnapLogic world with past working experience in traditional ESB products like IBM Message Broker, WebMethods ESB, TIBCO etc. Wanted to understand if SnapLogic provides any out of the box feature to capture the input & output docume...

Objects From Array

Hi , Can you please help me to get the objects from the array as below.The LX segment is dynamic in the below example it is having 2 but it will be varying. This is my Input [ { “order_edi”: [ “LX|000001”, “W01|1|EA||IN|53142262|UP|642470202104||||||...

Pipeline execution time is more than expected

Hi Team, We had a medium complex pipeline around 30 snaps and it takes around 10 secs to execute the pipeline. The pipeline contains XSLT snap which execution time around 2 secs and Rest Post snaps execution time takes around 3 secs and other snaps e...

Some json strings questions

Hi We are just starting off with SnapLogic and we wonder if somebody can give us some answers to the following questions. We have the following input [ { transactionId:“F59AE026-8AEA-4F69-BE97-F7AB981AC3BF”,LineCreationSequenceNumber:1,ItemNumber:“99...

SnapLogic - Integration Nation

Forum Posts

Resolved! Filtering Out A List Of Unique Identifiers From Output Document

Resolved! How to split a value into multiple fields

Redshift bulk load preview showing no failed record counts but not loading records to tables

Need to identify count of a character appearance in a string

How to audit payload in pipeline?

Objects From Array

Pipeline execution time is more than expected

Some json strings questions

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?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...