Designing and Running Pipelines

Modify an excel

Hi I need some help with the following use case. The steps are as follows: First Query the database. The output of the query should be loaded into an excel template. The excel template here means a pre-defined excel sheet. In short I need to modify a...

JSON parse error with string has new line characters

Noticed some times I received JSON parse error when the string contains new line characters.

Time format Conversion not working

Hi All, I am trying change a data format with expression. Input is a string value: “9-JUN-21 10.06.39.000000 AM” Output should be ‘yyyy-MM-dd HH:mm:ss’ format I am trying data parse the incoming date format but unable find proper format for input da...

Unable to decode base64 value

Hi, I’m getting an encoded test from SNS which can decode base64 using online tool but when I use “Base64.decode($content)” in map i’m getting below error, can someone please help Failure: Unable to decode base64 value, Reason: Bad Base64 input chara...

Triggered Task execution details

Hello Experts, Can someone help me to understand about triggered task execution. For eg:- User1 created one triggered task and share the triggered task URL to User2 for execution. So User1 is task owner. When user2 hit the triggered URL,then in dashb...

Sort all elements in JSON Object

Hi all, I’m having an issue where i’m utilizing the the builtin snaps to get details on a pipeline. I’m then pushing these pipeline details to Gitlab to enable version control. Now my issue is that for some reason (i couldn’t find the culprit yet) th...

How to do a handshake with SNS Subsbription?

Hi, I’m trying to receive messages from AWS SNS subcription using URL of the ultra task. Can someone please help How to do a handshake with SNS Subscription the first time and handle the subsequent request? Also, where the Bearer token need to config...

Add prefix to each column

Hello Experts, for eg. if i have 50 columns and wanted to add some prefix to each column value then without mapping individual column in mapper how can i do it? Regards, Ajay

SnapLogic - Integration Nation

Forum Posts

Modify an excel

JSON parse error with string has new line characters

Time format Conversion not working

Unable to decode base64 value

Triggered Task execution details

Sort all elements in JSON Object

How to do a handshake with SNS Subsbription?

Add prefix to each column

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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