Designing and Running Pipelines

Help Using Group By!

Dear Community I need your help with understanding the group by in the attached simple pipeline. I am supplying the Json data and sorting and grouping it by ID as in the picture but for each Group, i.e. ID. Then I need to first determine if a type of...

Want to create a single Excel file from multiple Files

I have multiple Json files and I want to create single Excel file using Snaplogic. It should Append the data and shouldn’t overwrite the file.

JDBC Select order by Descending - HELP

Good day, I’m trying to get the JDBC select snap below to order by descending on a field. Is this possible?? Thank you very much in advance.

Dynamic Data Validation

I want to validate the incoming data which will be in CSV format. I have Target table defined for each file. Now I want to develop a common pipeline which should validate the data based on the rule for each file. Validation Rules - Not null, length a...

SMB/windows server-SSH connectivity

Hi , Currently SL has capability to connect to windows servers via SMB basic authentication. Is there a way where we can connect to SMB server with SSH(key based) authentication?

Can We create a Variable in Mapper

Hello Everyone, I am trying to create an incremental addition let say i have 2 columns empl_id and salary so in target i want to derive third column with cumulative salary. I can do it by using variable, have done it using Different tool but never im...

Can you please help me with the logical type to specify the date format in the Parquet Writer Snap

INT32 (DATE) not providing expected output as 2019-09-24 What data type should I be using to get desired output.

SOAP Exec - removal of default created XML headers

Hi! We’re currently using SOAP Execute to communicate with our ERP system. Unfortunately, SOAP Execute always adds a SOAPaction to the XML header, whilst we need to try to skip this one. We’ve already explored the option to configure the headers, Bu...

SnapLogic - Integration Nation

Forum Posts

Help Using Group By!

Want to create a single Excel file from multiple Files

JDBC Select order by Descending - HELP

Dynamic Data Validation

SMB/windows server-SSH connectivity

Can We create a Variable in Mapper

Can you please help me with the logical type to specify the date format in the Parquet Writer Snap

SOAP Exec - removal of default created XML headers

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