Designing and Running Pipelines

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...

Expression in router

Hi, We are doing migration to snaplogic and I need to write expression in router where basically in first output anything which is true for the expression:- $Z7_COND.IDOC.MES in (‘ED’,‘FG’) and $Z7_COND.IDOC.REC in ('34,‘PD’) and 2nd output should ha...

SnapLogic - Integration Nation

Forum Posts

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

Expression in router

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...

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data

Parsing XML using a Python script returns an encod...

multiple array objects

String replace method where pattern is dynamic