Snaps Packs

Generic JDBC - interaction between exhaustion of connection pool and 'number of retries' setting?

Let’s say I have a Generic JDBC account configured with MaxPoolSize= 10 connections and Checkout Timeout - 10,000 milliseconds. I have a Generic JDBC Execute snap configured with ‘number of retries’ = 5 and ‘retry interval’ = 10 seconds. When the fir...

Resolved! Merge two tables based on multiple criteria

Hi there, I’ve been trying to find a solution for our use case with no success, so I’d like to ask the Community for help. We have two tables (both from Salesforce), table A contains deal information, table B contains campaign information. Both table...

Copy snap creating output that is multiplied by number of records

I have a pipeline that creates files based upon 490 records in an Oracle table. I create the output by doing a select on static headings that I create and union it with actual records from the table and then I sftp the file. I wanted to also be able ...

SSH and Password

Hi, Currently the SSH account supports only key based authentication, we have a requirement for 2 factor authentication with private key and password. Is this in the roadmap to support in SnapLogic? Ref: SFTP Two-Factor Authentication Using SSH Keys ...

How to render distinct elements only in an array with duplicates

I have a JSON document that has inside an array with duplicate values such as [1,1,3,3,6,1,2,1,2,100]. I am trying to transform/map it from source into target by returning only the distinct values such as [1,3,6,100]. How can I achieve that using a ...

Faster PostgreSQL Bulk Loads available

We are pleased to announce that ‘latest’ has an updated PostgreSQL bulk load snap with significantly better performance. We’re routinely seeing 3x performance in our tests but your mileage may vary. This is mostly drop-and-go but there is a small dif...

Tutorial: Using the DocuSign eSignature REST API with the REST Snap Pack and JWT Authentication

I previously wrote about integrating with the DocuSign eSignature API with the REST Snap Pack and OAuth 2.0 authentication, but for those that wish to control their access a bit more, DocuSign supports authenticating with JSON Web Tokens (JWTs) too. ...

Extra characters inserted in DB when using Bulk Loader

We have a pipeline with a SQL bulk upload snap in it. Here is our input: ID: 1 JSON : {"address: 1234 no where”} We insert several hundred of these into a SQL DB into a table with ID,JSON Create SQL: CREATE TABLE [dbo].[test_json_inc]( [id] [bigint] ...

SnapLogic - Integration Nation

Forum Posts

Generic JDBC - interaction between exhaustion of connection pool and 'number of retries' setting?

Resolved! Merge two tables based on multiple criteria

Copy snap creating output that is multiplied by number of records

SSH and Password

How to render distinct elements only in an array with duplicates

Faster PostgreSQL Bulk Loads available

Tutorial: Using the DocuSign eSignature REST API with the REST Snap Pack and JWT Authentication

Extra characters inserted in DB when using Bulk Loader

Salesforce Update REST API Throughput

unable to see the output from a python script

Sharepoint Online OAuth account, error 500 when re...

XML Generator is removing empty elements

Add fields dynamically in Encrypt field snap

Join and In-Memory Lookup not working

Using the Filter Snap on nested array

Error Sending Email through Email Sender Snap

SAP SuccessFactors Snap Pack

When making a REST call over HTTPS what CA bundle ...