Designing and Running Pipelines

How to make a generic pipeline Oracle => SQL Server

Hello, I would like to build a generic pipeline to load data from an Oracle DB to a SQL Server DB. I have more than 100 queries to load, so I would like to be able to call the pipeline with the Select (from Oracle) and the destination table as parame...

How to expose pipeline with basic authentication

Hi, How to expose pipeline with basic authentication, (not with Bearer token, need to use id and password). Thanks

Create table with datatypes from source but ONLY selected columns

I noticed the functionality to create a second output on SELECT from database and connect that to the second input on INSERT so that the destination table can be automatically created with the correct data types. Unfortunately I only want to select a...

File Writer - Append to Excel

Hoping someone can help. I have a pipeline that executes a SQL, uses a file writer to put the result set in an excel (call it excel #1) and then emails Excel #1 as an attachment. All works good. WHAT I NEED TO DO: have another excel file (call it...

JSON Payload issues

I’ve come across an issue where the REST post works using a JSON generator, but when we receive the JSON from the pipeline and post it, the call fails. The JSON payload is exactly the same between the JSON generator and what we receive, yet we cannot...

Accessing temp table Snaplogic creates in Snowflake?

Is it possible to access the temp table Snaplogic creates in Snowflake? Need to do some deletes and the delete snap takes a lot of time and resources. I would like to delete using a join to the temp table instead of individual transactions if possib...

Resolved! XML formatter replaces &quot to &quot

I have an input to the XML formatter which looks like this { “@SEGMENT”: “1”, “code”: “B00001”, MVodafone 150" BLACK “test_p”: [ ] } when this input is passed to XML formatter, it gives output as below: “code”: “B00001”, MVodafone 150amp;quot; ...

Writing python script in Script snap

Hi , Can anyone help me in writing simple “hello world” program using python in script snap?

SnapLogic - Integration Nation

Forum Posts

How to make a generic pipeline Oracle => SQL Server

How to expose pipeline with basic authentication

Create table with datatypes from source but ONLY selected columns

File Writer - Append to Excel

JSON Payload issues

Accessing temp table Snaplogic creates in Snowflake?

Resolved! XML formatter replaces &quot to &quot

Writing python script in Script snap

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