Designing and Running Pipelines

Resolved! Mapper to retrieve a field value from optional json path

I have to extract "pw_cc__IsoCode_2__c" when in the payload "Country_of_Installation__r" is present.Since both parent property Opportunity and child property Country_of_Installation__r are optional field i need to check if the node present before e...

Automating data chunking date file

I am reading a file in a pipeline to break a data load into six-month increments. Twice a year, I need to update the file to accommodate dates for the next six months. My question is this: is there a way to build this date increment logic into my sn...

Mapper to retrieve field value with null check

I have to extract "pw_cc__IsoCode_2__c" when in the payload "Country_of_Installation__r" is present.Since both parent property Opportunity and child property Country_of_Installation__r are optional field i need to check if the node present before e...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Mapper to retrieve a field value from optional json path

Automating data chunking date file

Mapper to retrieve field value with null check

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

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings