Designing and Running Pipelines

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

Resolved! Failed to execute pipeline

Hi, I am getting error while running the child pipeline with larger files. There is no error with smaller files. I have a mapper at the starting of child pipeline. Below is the error:- Failed to execute pipeline Reason: Snapi request failed: {“respon...

Generate same cipher text as result of encrypted value

Hello Expert, I’m trying to encrypt few fields of file (eg Name,Age) using encrypt field snap. if same name and age appears in different file encrypt field snap is giving different cipher text. Attaching sample pipeline for reference. testCipherText_...

Formatting excel data

I have an Excel sheet with with below format: In this Excel, column 1,2 and 3 remains common, and the data which i am suppose to send is in below output csv format: Output: QWE;1234;567890;1111;20212021 (Row 1: Column 1,2 and 3 is common with fields...

SnapLogic - Integration Nation

Forum Posts

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

Resolved! Failed to execute pipeline

Generate same cipher text as result of encrypted value

Formatting excel data

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

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data

Parsing XML using a Python script returns an encod...

multiple array objects

String replace method where pattern is dynamic