Designing and Running Pipelines

How to Handle image as response body of Rest get/Post snap

Hi I am having an API that responds back with a dummy image as the body of response, that API works fine as long as I am using it outside of snaplogic on tools such as postman. but when same I try to execute via REST POST snap, it routes to the error...

JMS Consumer ActiveMQ

Hello, I need help configuring JMS Consumer to consumer an ActiveMQ queue. I am stuck at the validating account part. Connection Factory: org.apache.archivemq.jndi.ActiveMQInitialContextFactory I’ve added the JAR & populated: InitialContext.INITIAL_C...

Bit is converted to 'true' and 'false'

Everytime I pull data from SQL Server / Salesforce etc, if the data type is bit, it returns a string of ‘true’ or ‘false’ that I am then having to convert back to a 0 or 1. How do I get this to behave differently?

Refresh Excel Pivot Table

The attached sample excel has three sheets: Sheet “data” - This sheet has the raw dump of data Sheet “pivot” - This sheet has a pivot build out of the “data” sheet Sheet “stats” - This sheet builds a summary data using the “pivot” sheet The goal is t...

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

SnapLogic - Integration Nation

Forum Posts

How to Handle image as response body of Rest get/Post snap

JMS Consumer ActiveMQ

Bit is converted to 'true' and 'false'

Refresh Excel Pivot Table

Modify an excel

JSON parse error with string has new line characters

Time format Conversion not working

Unable to decode base64 value

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

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?