Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

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?

fmdf by New Contributor III
  • 4989 Views
  • 4 replies
  • 0 kudos

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

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

Shrabanti by New Contributor II
  • 2243 Views
  • 2 replies
  • 0 kudos

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