Designing and Running Pipelines

Fixed Width Formatter always adds one blank line

I’m using the Fixed Width Formatter snap to create a .txt file with one line in it, but it always writes the file with one extra blank line at the end. I tried adding the Head snap using 0 offset, 1 number of documents and tried 1 offset, 1 number of...

How to execute 20 different oracle sql queries using oracle execute snap

Hello Everyone, Need your expert advise, I have 20 different set of sql queries running on the same table to generate the metrics, I am trying to run through them using Oracle execute but got error as “resolution: Reduce the fetch size in the databa...

Conflicts with LastPass autofill during Account creation

Several members of my team and I have all experienced problems with LastPass auto-filling incorrect credentials or form info when we try to create new accounts within SnapLogic. I’m sharing here in hopes that that other people can avoid this problem....

Requirement to extract text from pdf, word doc and ppt file types

Hi All, We have a requirement to extract the text content from file type- pdf, doc, docx, ppt, pptx and store it in the text format or convert it to csv format. I couldn’t find any Snap which could help me in current version of Snaplogic but wanted t...

Excel format customization

I am wondering if it would be possible to customize the excel data during the pipeline process. I’m trying to replace some crystal reports that have some custom formatting. Is this possible? If not, can it be or are there any suggestions on how to do...

Fetching platform error failures using public API

Hi, I am trying to fetch the below errors using the snaplogic public APIs which are logged in the jcc_error.json file. Unable to get poolProxyHeartbeat failedUnable to push pipeline runtimes toStopping runaway suggest I was able to fetch the “Unable ...

Eval method behaving strangely

Hello. This is very strange but we have a pipeline that has pipeline parameters / arguments. 1 for month and the other year: This works fine when the months is 7 or less (july). once you put the param = 08 for august and year 2020 this strange error...

Redshift Unload Directly to Parquet

Hi, Has anyone figured out a way to Unload data directly to parquet format from Redshift? The Redshift Unload snap does not have parquet format as an option (just delimited and fixed width files). I have tried to circumvent this by using a Redshift E...

SnapLogic - Integration Nation

Forum Posts

Fixed Width Formatter always adds one blank line

How to execute 20 different oracle sql queries using oracle execute snap

Conflicts with LastPass autofill during Account creation

Requirement to extract text from pdf, word doc and ppt file types

Excel format customization

Fetching platform error failures using public API

Eval method behaving strangely

Redshift Unload Directly to Parquet

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

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