Designing and Running Pipelines

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

Using "Error Pipeline" - parent pipeline does not stop, how to stop it? error-pipeline called at the end?

Hi SL gurus! Pipeline got Error Pipeline defined in properties(for logging/alerting). When error occures, in e.g. Mapper, main pipeline does not stop and execute error-pipeline, but runs further. If more errors occur, they will be sent to the error-p...

Decrypt / Decode the content from incoming message from AWS SNS to ultra pipeline

I have received the below message from AWS SNS to my ultra pipeline, I would like to know how I can Decrypt / Decode the content from the message. Thanks [ { “task_name”: “xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx”, “client_port”: 19549, “x-amz-sns-topic-...

SnapLogic - Integration Nation

Forum Posts

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

Using "Error Pipeline" - parent pipeline does not stop, how to stop it? error-pipeline called at the end?

Decrypt / Decode the content from incoming message from AWS SNS to ultra 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...