Designing and Running Pipelines

Don't email empty error logs

I have snaps running nightly to insert data into SQL server. If there was an error I have it set up to email what my file write created. I wanted to ask if it’s possible to prevent it from emailing empty error logs. As of now if there aren’t any erro...

Snaplogic SQLServer Insert Snap

Hi the snaplogic insert snap is throwing error when a trigger task is invoked and the FileId is coming as the parameter. The error is below java.sql.BatchUpdateException: Invalid column name ‘FileId’. at net.sourceforge.jtds.jdbc.JtdsStatement.execut...

Email Reader Snap very slow

Hi, I am using Email Reader snap to read email/attachment from an microsoft outlook emailbox. The snap is able to connect to the mailbox and read the attachment but the speed at which it reads is too slow (generally in KBs and sometimes even in bytes...

How to split column values into new row

Hi Guys , I have below given json as input and i wanted to spilt it into difference rows based on multi valued columns . Input: “Cost_Center_Hierarchies”: [ { “Fucntional_Lvl4”: “CC6140”, “F_Lvl_4_Descr”: “Corporate - G&A” }, { “Fucntional_Lvl4”: “S...

How to create a file only with the header?

If no data from the sql execute ,then i want to create an empty csv file with column headers. The columns return from the database is not fixed.

Change OBJECT to ARRAY using Mapper

Using Mapper, we can change the Object in to array. In the below pipeline , data is generated using csv generator in plain text. Pipeline CSV generator configurations Changing the name from object to list. $Name instanceof Array?$Name :[$Name] Her...

Creating one more field in list of objects by using the fields in same objects

Hi Team, I have the below input data : [ { ID:123 “Name”:“Tony”, “Age”:24 }, { ID:124 “Name”:“Sam”, “Age”:36 }, { ID:125 “Name”:“Glenn”, “Age”:58 }] I need to add one more field ‘halfAge’ to the above and output data should be like below: [ { ID:123 ...

Task running ServiceNow Query snap - intermittent errors

When running a task with a ServiceNow Query snap against the incident table, in the error message: An error occurred while fetching the records (status code: 400). This related to the incident records or possibly a lost connection to ServiceNow.? I...

SnapLogic - Integration Nation

Forum Posts

Don't email empty error logs

Snaplogic SQLServer Insert Snap

Email Reader Snap very slow

How to split column values into new row

How to create a file only with the header?

Change OBJECT to ARRAY using Mapper

Creating one more field in list of objects by using the fields in same objects

Task running ServiceNow Query snap - intermittent errors

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error