Designing and Running Pipelines

Issue reading XML data

I am getting error while reading following XML in XML generator. Error message “Failure: null, Reason: Error occurred while validating the XML, Resolution: Please provide a valid XML” <?xml version="1.0" encoding="utf-8"?> EUR Projec...

Resolved! API that catches HTTP Post encoded in CXML

I am trying to build an API endpoint that can catch an HTTP Post that is encoded in XML. The error I am getting is:Document input views only accept JSON-encoded data. I understand that there are snaps that allow me to conver the XML to JSON once th...

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

SnapLogic - Integration Nation

Forum Posts

Issue reading XML data

Resolved! API that catches HTTP Post encoded in CXML

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

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

What account should be used for API with query par...

How to dynamically update an account?

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