Designing and Running Pipelines

Ingesting large AWS S3 file(30 GB) into a AWS RDS

Hi, I am trying to start of with S3 select , however s3 select does seem to have size restrictions upto 128 MB ? I can't use S3 browser as all I see is meta data information , I want actual data. How should the pipeline look like.I tried S3 select u...

Resolved! Filter Single attribute from JSON list to use it in a like query

My Input looks like this. {"totalCount": 4,"dataList": [{"IfaNumber": "1","alink": "","agroupId": ""},{"IfaNumber": "2","alink": "","agroupId": ""},{"IfaNumber": "3","alink": "","agroupId": ""},{"IfaNumber": "1","alink": "","agroupId": ""}]} Can anyo...

Resolved! Email Sender Snap - Multiple HTML tables

Hi all, I am looking to send a single email with 3 separate HTML tables in the body of the email. They are small tables (roughly 10x10). The data sources are 3 separate CSV files / or 3 SQL Server Selects. How can I append 3 separate tables to the em...

CSV to EAV Schema

Hello Snaplogic Community,I'm currently working on a project where I need to import data from a CSV file into an EAV (Entity-Attribute-Value) schema in a Postgres database. I'm looking for advice on best practices for implementing this process, espec...

Resolved! How to Pass Mapping Variables to Email Snap

Hi, I am new to SnapLogic. i need help on how to pass the Mapping variable to Email snap. I need a requirement to read the mapping variable and need to refer in Email Snap Template body. so that users can read the values on email itself. Thanks

Resolved! Splitting zip files

Hello all,As part of my pipeline I'm downloading a .zip file from a server (using the HTTP Client snap) and the zip file that I'm getting contains documents in different languages that are stored under a folder named after the language. For example:M...

Resolved! How to replace value in string based on othec conditions

Lets say i have a string:"FF;0545454;value1;test;01;99;;;value2;866"how can i tell snaplogic in mapper, if third value is (value1) and value in fifth column is 01, change second value to 888 so the result will be:"FF;888;value1;test;01;99;;;value2;86...

Merge documents into one big document

Hi, Currently when I use Oracle select/Oracle execute snaps to query data from Snaplogic, it will return multiple documents as output from those snaps(one row per doc). Is there a way i can merge them together into one json array or one doc? Thanks

SnapLogic - Integration Nation

Forum Posts

Ingesting large AWS S3 file(30 GB) into a AWS RDS

Resolved! Filter Single attribute from JSON list to use it in a like query

Resolved! Email Sender Snap - Multiple HTML tables

CSV to EAV Schema

Resolved! How to Pass Mapping Variables to Email Snap

Resolved! Splitting zip files

Resolved! How to replace value in string based on othec conditions

Merge documents into one big document

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

Rest Post for Multipart form type content type wit...