Designing and Running Pipelines

Does Snaplogic support writing Grid format headers for Excel Binary Spreadsheet(.xslb files)?

Hello Team, I have requirement of writing excel binary spreadsheet .xslb extension type. Used Excel formatter snap followed by file writer and able to write the .xslb file , But how do i apply Grid format for Excel table headers for filters on each c...

Azure SQL Bulk extract-- BCP absolute path

Hi, I am using a Azure SQL bulk extract snap and it is asking me to mention the BCP absolute path. I am not aware of this. Can anybody pls help me out?

How to remove columns with null value alone in pipeline?

Hi, I have a scenario where I have few columns have null value few not. Objective is to not to bring in columns with null value for each records. source: idabcdeabcnull12nullnulldef11null2233nullijk111222null333444lmonullnullnullnull5555 Expected: a...

Unable to create a Redshift account

Failed to validate account: Failed to retrieve a database connection. Cause: FATAL: no pg_hba.conf entry for host “???”, user “ABC”, database “XYZ”, SSL off (Reason: FATAL: no pg_hba.conf entry for host “???”, user “ABC”, database “XYZ”, SSL off; Res...

Math.absolute on array element

Hi there, I have an array that has negative decimal values. how can I make all the values positive, if theres one? Thanks Manohar

Resolved! SFTP to blob storage

Hi Team, I have a requirement where in I have to read the files from SFTP and write the files to Blob storage. This has to be done every 15 minutes. How can I ensure I am not writing any duplicate files to the blob? Regards Sindhu

How do we check if NO DATA in a CSV file after filtering out headers

Hello, I need to check if there is no actual data after reading and parsing a CSV file, I am using the CSV Parser and have checked the ‘Contains Header’ (as we will always have a row with headers), I then follow it with a Mapper. If we have no data a...

Passing custom value to Error pipeline

Hi, I have search the community and Google for that matter but I cannot find a sample of how I can pass a custom value to an error pipeline. When we start a pipeline we consume message information from a RabbitMQ queue and when we have an error in ou...

SnapLogic - Integration Nation

Forum Posts

Does Snaplogic support writing Grid format headers for Excel Binary Spreadsheet(.xslb files)?

Azure SQL Bulk extract-- BCP absolute path

How to remove columns with null value alone in pipeline?

Unable to create a Redshift account

Math.absolute on array element

Resolved! SFTP to blob storage

How do we check if NO DATA in a CSV file after filtering out headers

Passing custom value to Error pipeline

CSV parser cannot parse data

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

multiple array objects

String replace method where pattern is dynamic

Send Multiple HTML Tables in Email using XML Parse...

Email Sender Snap - Send data as HTML Table

Creating a pipeline involving user interaction in ...

How to add an object into an array

Writing to Pipeline Parameters within Pipeline

Email Sender Snap - HTML Table printing grouped va...