Designing and Running Pipelines

Resolved! Counting Instances in Array Object and Removing Duplicates

As I process an array, I want to see if I have any duplicate names in the array that I am processing. If I encounter a duplicate name, I only want to keep the one where the series contains “Trekker.” How can I do this? For example, given the shows ar...

Delimiter in CSV formatter

Hi, I wanted to Add CR LF as a delimitter in CSV formatter but not sure how to add the unicode in the field, should it be with ‘=’ enabled or disables

Data Validator - validate pipeline parameters?

Is there a way to validate the pipeline parameters using the data validator? Getting the following error when trying to validate a pipeline parameter: Data Validator[5dc15a412e2bfc322115a57d_286ad388-7bdb-4bcf-be8e-0cb286d68710 -- f2cdd56e-15b0-4ea4-...

Table Creation in SQL server with specific data type using data from excel file

Hi all, Thanks in advance for read and any help here. I have a pipeline where I had a excel file, with columns name and table name, so first I read this excel file and them make a parse, this is a sample of the excel file: So I want (if not exist) c...

Failed To Mount when attempting to attach file using Email Sender

I have several pipelines that use the Email Sender to attach a document to the email. These are all failing now with the error saying that “Mount failed due to logon failure or bad credentials:” This just stopped working as of 5/13. Is anyone else...

Pipeline Execution on Dashboard

I have 2 triggered pipelines that have completed their processing, but they won’t fall out of the execution section of the dashboard and move to the execution history section. When I try to stop the pipelines, nothing happens, but I think that’s beca...

Salesforce Allow Null Updates to Target

I am trying to convert some Informatica upsert sync tasks to SnapLogic pipelines. One useful option in Informatica is an ‘Allow Null Updates to Target’ option. That is, when a source field becomes null, it also gets nulled in the target. How does the...

Mapper - change value in target path based on condition

I have the below req. i want to update the value of a column only if it’s null else leave as it is. ex: raw_table.date_joined will be populated only if it’s null, if it’s already have a value leave it. mapper: expression Target Date.Now(...

SnapLogic - Integration Nation

Forum Posts

Resolved! Counting Instances in Array Object and Removing Duplicates

Delimiter in CSV formatter

Data Validator - validate pipeline parameters?

Table Creation in SQL server with specific data type using data from excel file

Failed To Mount when attempting to attach file using Email Sender

Pipeline Execution on Dashboard

Salesforce Allow Null Updates to Target

Mapper - change value in target path based on condition

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