Designing and Running Pipelines

Issue on reading multi-level nested XML document

Hello Everyone, I have a requirement to read very complex xml document and make it in structure format. And also xml files and information are keep changing. I have attached the file here. It would be good if I anyone would help me with a python code...

Guidance manipulating files in S3 using Script (Python) snap

I would like to read a file from a S3 bucket, update the file, then write it back to S3. I would like to use the account in SnapLogic I configured for S3 use. Does anyone have an example of any of this they could share?

Fixed Width Parser - (with no line separator)

We’re receiving a fixed width record file, but there are no line separator characters. Is it possible to parse this file using SnapLogic?

Handling Oracle non-standard CSV exports

We have worked on several projects where Oracle DBAs create direct table extracts using standard Oracle tools. Those tools do not generated properly escaped CSV files. As such, lines like “123”,"quote",“test” “345”,“Mc"Donalds”,“test2” Cause Snaplogi...

How to create new path in SFTP for File Operation

Hello, Please suggest how can I write a file into a new path which does not already exist in the SFTP and needs to be created. Regards, Darshita

Resolved! What do you use the global shared folder for?

Hello, We are relatively new and trying to figure out our approach for structuring project spaces and projects. One question that came up is what to do with the global shared folder. Is it generally acceptable to put generic pipelines, accounts, sc...

Table name in SQL select snap

Hi, I have few tables on SQL server like abc_2020 abc_2019 abc_2018 I want to query the the table that has suffix as current year. I have specified the value in the settings > table name-- ‘abc_’+ Date.now().getFullYear() it’s throwing error. Failure...

How to check condition and route

Hi, I want to check the value of Description in each item in the below JSON and route seperately if all are same and seperately if they’re different. How can I do this? [ { “SEGMENT1”: “104155”, “DESCRIPTION”: “EUR”, “UNIQUE_ID”: “224”, “ITEM_NUMBER...

SnapLogic - Integration Nation

Forum Posts

Issue on reading multi-level nested XML document

Guidance manipulating files in S3 using Script (Python) snap

Fixed Width Parser - (with no line separator)

Handling Oracle non-standard CSV exports

How to create new path in SFTP for File Operation

Resolved! What do you use the global shared folder for?

Table name in SQL select snap

How to check condition and route

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