Designing and Running Pipelines

Need Help to convert from XML to CSV

Hello Team, I need to convert some xml file to csv or we have to map it flattern. I am not able to verify the xml docs in order to proceed further, I have attached the xml file. Can anyone please help me here and provide me the sample pipeline for sa...

Resolved! Remove json key value from document based on condition

Greetings! Is there a way we can use the mapper to remove “upperlimit” key value from the document, whenever “ApprovalType”==“Greater than equal to” and ignore it if “ApprovalType”==“Between”?? Appreciate your help!! Thanks, F.

Resolved! Skipping faulty records in tab delimited file

Greeting! Is there a way we can skip faulty records which has special symbols as it fails the whole file while using the CSV parser. The highlighted record is the one which needs to be removed, or any records which has special symbols which are not ...

CI/CD - Sample Pipelines

Hi, I went through blog post on implementing CI/CD for snaplogic pipelines. Please refer to the following links. End-to-end pipeline automation and governance (Part 1 of 2) | SnapLogic End-to-end pipeline automation and governance (part 2 of 2) | S...

Ideas on building Pipeline based on REST Service

To avoid building a point to point integration with Salesforce, I was wondering if there was a way to execute a pipeline based on API requests created by a website. Am I right in saying that we could use the a REST get snap to do this and we would ju...

Salesforce to csv

Guys, can you help me to create a pipeline or provide some sample pipleline to export all salesforce objects to csv? Thanks

Excel Formatter - need date datatype with this format MM/DD/YYYY

Im using Excel Formatter. I am selecting from Oracle. I need the column in excel to be date datatype, but have this format MM/DD/YYYY with no time on the end. I can get the date into that format if I do a to_char(mydate, ‘MM/DD/YYYY’) in the select...

File Rename but not able to replace

Hi All, I am facing one issue in one of the scenario. Please Help. I have a source file name in source path Ex: a_b_abc_test_120_7568.xml I want to rename this file in different format Ex: a_babctest_120_7568.xml I have written one code in mapper and...

SnapLogic - Integration Nation

Forum Posts

Need Help to convert from XML to CSV

Resolved! Remove json key value from document based on condition

Resolved! Skipping faulty records in tab delimited file

CI/CD - Sample Pipelines

Ideas on building Pipeline based on REST Service

Salesforce to csv

Excel Formatter - need date datatype with this format MM/DD/YYYY

File Rename but not able to replace

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

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data