Designing and Running Pipelines

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

Create Key Value Pair Array

Hoping someone can help me out. I have a JSON array. It’s an array of string values and it’s called, washCare. I want to give each value in the array a property name. How would I write the correct mapping to accomplish the following? I thought I coul...

Get JIRA Attachment Content Document in Snaplogic Pipeline

Hi all, We’re trying to get the JIRA Attachment Content document and it gives the URL of the attachment as shown below:- “content”: “https://myjira-abc.atlassian.net/secure/attachment/10000/sample.txt” We are trying to get the metadata of this conten...

SnapLogic - Integration Nation

Forum Posts

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

Create Key Value Pair Array

Get JIRA Attachment Content Document in Snaplogic Pipeline

What account should be used for API with query par...

How to dynamically update an account?

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