Designing and Running Pipelines

Creating File in NetSuite File Cabinet using NetSuite Create Snap

I have various types of binary files such as word document, Excel, PDF, images etc. stored in MySQL DB as blob storage. I am transferring this files to NetSuite File Cabinet using NetSuite Create snap and selecting File as record type. The problem is...

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

SnapLogic - Integration Nation

Forum Posts

Creating File in NetSuite File Cabinet using NetSuite Create Snap

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

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

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work