Convert array of objects in an object of key value pairs
Hello,I need to convert the following array of object into an object of key value pairs.Input:Expected output: Thank you for your help!
Forum Posts
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...
