Designing and Running Pipelines

Resolved! Need to convert yyyymmdd to yyyy-mm-dd

Hi, I have a element as:- jsonPath($, “$Z_ORD.IDOC.DK02[].DATE") and value is coming as 20210521(yyyymmdd). I need to convert it to 2021-05-21 and map it to target ml element. I am using mapper. Tried like below:- Date.parse(jsonPath($, "$Z_ORD.IDOC....

Blank pipe.ruuid returned from unbounded mapper

Hello All - In order to monitor our pipelines, I have placed a unbounded snap(mapper) at the start of the pipeline that “most of the time” returns the pipe.ruuid once the job kicks off. For some of our shorter jobs, I had to put a script at the start...

Record Count per file

Hi, I am reading multiple csv files from a SFTP location. I need to get the # of records per file, so I can put that info in a summary email. Any ideas on how I can retrieve the filename and # of records for each file? Thanks! Dawn

CSV data fields is greater than Header size

Hi Gooday, I tried reading a csv file from smb server through csv parser . The parser throws the error like “Error parsing at record 6478, content-The number of CSV data fields is greater than the number of header columns in the input data: number of...

Maximum size of a JSON document

Is there a limit on the size of a JSON document that SnapLogic supports?

How to encode (base64 format) a zip file?

Hello Everyone! We are planning to build a pipeline to achieve the following scenario. Extract Oracle Data → Create a CSV File → Zip CSV file → Convert Zip file to Base64 Format. We build the pipeline as following. We were able to do all activities t...

Resolved! Connecting to shared Mailbox Error

Hello, I am trying to connect to the mailbox and it keep giving me this error. I can connect to the mailbox using outlook without any issues. Any help will be appreciated.

Unable to find proper resource to which can help import external libraries in script snap

Using Script Snap to fetch file document of attachments from JIRA and to encode it, we are unable to add external third party libraries like “request” for python in the directory mentioned as /opt/snaplogic/:- Below is the script:- import requests im...

SnapLogic - Integration Nation

Forum Posts

Resolved! Need to convert yyyymmdd to yyyy-mm-dd

Blank pipe.ruuid returned from unbounded mapper

Record Count per file

CSV data fields is greater than Header size

Maximum size of a JSON document

How to encode (base64 format) a zip file?

Resolved! Connecting to shared Mailbox Error

Unable to find proper resource to which can help import external libraries in script snap

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