Designing and Running Pipelines

Resolved! Sum of values in array of objects without reduce function

Hello all, I stumbled upon a situation where I have to find out a sum of a certain key in the objects residing in an array without reducing the objects? What I mean to say is, here is the input: [ { key1: value1, key2: 10 }, { key1: value2, key2: 20 ...

Need to know email address validation logic

Hi, I need to setup a logic to filter out only valid email address, might use that logic in filters, conditional or mappers. logic should able decide which email address valid. For ex : test@test687 is invalid and test@test687.com or test@test687.edu...

Snaplogic CSV parser failing

Hi Team, While parsing a csv I got an “EOF reached before encapsulation token finished” error . However when checked each field is mapped to the header appropriately . After this error I again ran the pipeline without touching anything and we got the...

Which IP address do SnapLogic SMTP requests come from

I am trying to set up a SMTP account to send an email with the Email Sender snap in SnapLogic. I asked the IT Admin team to set up an account to use with SnapLogic in order to access our SMTP service. Their question to me was “Where is the request co...

Groundplex not running on server Snaplex does not detect it

Hi I am trying to run an instance of groundplex on a server but I am not able to see the snaplex dectecting the node, I got jcc_error.json and I see this error: “ERROR”,“fi”:“RequestFilter.java:157”,“msg”:“JCC cannot be initialized properly [Error co...

Debugging Expression libraries in eclipse (or other editor) using Javascript

I would like to be able to write tests for my expression libraries using and editor and javascript. I have tried require() and import, but have not been successful

Migrating Oracle Number to SQL Server Numeric

I have data I need to move from Oracle to SQL Server. In Oracle the data type is just “NUMBER”. No precision or scale specified. I know from analysis that these values are in some of the rows for one of the columns. .2010259556758395029265468931284...

How to use if else condition in xml generator snap

Hello Team how we can use if else condition in xml generator snap here is my query here either Expt have value or Sco have value not in both (Expt,Sco) i want to display case 1)if vatPer = 0.0 and if Expt tab have value then display Expt tab expe...

SnapLogic - Integration Nation

Forum Posts

Resolved! Sum of values in array of objects without reduce function

Need to know email address validation logic

Snaplogic CSV parser failing

Which IP address do SnapLogic SMTP requests come from

Groundplex not running on server Snaplex does not detect it

Debugging Expression libraries in eclipse (or other editor) using Javascript

Migrating Oracle Number to SQL Server Numeric

How to use if else condition in xml generator snap

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