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

How to handle null or empty element

Hi, I need to use null and empty condition in router. curretnly i am using:- $ZSDATA.IDOC.EDL2.EDL4.BEL != “” but i feel i am not handling it correctly. Any inputs?

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

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?

How to handle null or empty element

Objects From Array

Pipeline execution time is more than expected

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