Designing and Running Pipelines

Resolved! Batch Number From Group By N

Hi, I am building a pipeline where i am using Group by N. I would like to know if there is a way to get the batch number of each document. For example lets say i have 100 records in source and my group size is 10. Now this 100 records are divided int...

How to Enter Request body for OAuth2 POST Snap

Hello, In the Below Snapshot, I am trying to enter the Body Parameters for the REST POST snap for Oauth2 refresh token. I have all the necessary parameters stored as variables and pass them as below. I have the content type as “application/x-www-form...

Insert empty records of a file

This is my file while insering to table i expect it to have 6 records But it only inserts 4 records PIPELINE: Thanks in Advance

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Batch Number From Group By N

How to Enter Request body for OAuth2 POST Snap

Insert empty records of a file

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

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

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

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