Designing and Running Pipelines

Resolved! Return custom HTTP Header

I’m trying to return a hash of a CSV document I’m returning in a triggered task and I want to return it in a HTTP header. I would have thought i can do it the same way i can manipulate the status code by setting a binary header, but the headers aren’...

How to post zip file using rest post

Hi All, I am trying to post the zip file to end point using rest post. The downstream application expecting the ZIP file. They are storing the zip file in the blob column of sql server. data(zip file name) - storing in the blob column to process furt...

Salesforce data types not coming over when loading SQL Server

I am grabbing an object in Salesforce using the Salesforce Read Snap. I am using SQL Bulk Load and it is flagged to create table if it doesn’t exist. My numeric types are not being created in SQL. Almost everything is coming over as varchar(8000). I...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Return custom HTTP Header

How to post zip file using rest post

Salesforce data types not coming over when loading SQL Server

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

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