Designing and Running Pipelines

Mysql account

I tried to create a mysql account using localhost. I get the following error, can you please help. Failed to validate account: Failed to retrieve a database connection. Cause: Communications link failure The last packet sent successfully to the serve...

Triggered task landing page

I am considering using a triggered task to provide unsubscribe functionality for an internal email system. The link would pass two parameters to the pipeline, username and subscribe = yes or no. I have a couple of questions; When the task has complet...

Ignoring double quotes

I am in a situation where after a CSV formatter my data is coming in double quotes. How can i ignore it?

Getting The Response Header and not Response Content from Jira Webhook

The header is a JSON file and content comes in a binary file as can be seen from the trigger task debug trace below: Tried using the pipeline below and I only get the response header also included below and can’t find a way to get the content:

Resolved! Find a specific word in Json Object

In the router i am trying to route data based on below criteria if any of the value in statusC.contains("T’) route to view1 if any of the value in !statusC.contains("T’). (does not contains) route to view2 How can i best achieve from below data [ { ...

Joining two files without a common value

I want to join two files based on a field of file 1 containing the value of a field in file 2. What would be the best way to do this? e.g. File 1: $district_name='ABC School District". File 2: $district: ‘ABC’. So if $district_name.contains($distr...

Send email notifications on errors without SMPT server

Hello everyone, I’m trying to figure out is there a way to send notifications via email on errors without SMTP server as I do not necessarily need to attach files or error documents? Like the notifications that are sent on tasks execution. I have a p...

ServiceNow Query snap Performance

My usecase is to ingest data from ServiceNow into Snowflake, with no tranformation. I’m creating simple pipeline with 2 snaps - ServiceNow Query and Snowflake BulkLoad The service now table has 2.5 M rows, it is taking about 7hrs to read this data fr...

SnapLogic - Integration Nation

Forum Posts

Mysql account

Triggered task landing page

Ignoring double quotes

Getting The Response Header and not Response Content from Jira Webhook

Resolved! Find a specific word in Json Object

Joining two files without a common value

Send email notifications on errors without SMPT server

ServiceNow Query snap Performance

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