Designing and Running Pipelines

Can I use Dynamic SQL in SnapLogic?

I have a DYNAMIC SQL that I run in SQL Server Query and it runs fine. I am having trouble running the same SQL in the SQL Server - Execute snap. Can someone guide me on what I might need to do to get dynamic SQL running in SnapLogic. This is the mes...

Rerun a task manually

Is there an easy way to rerun a task? I usually update the schedule on the task to run it and revert the schedule to its original value once the task kicks off.

Error pipelines

Hello, I am looking some tips and looking for sample error pipelines. Thank you in advance. //Harish

Changing data types in Script Snap: Python

I got my first script snap to run successfully, but would like to change data types in specific columns. I could do this with a mapper snap I guess but would like to see it in the Script snap if anyone has an example.

Redshift insertion even the condition is false

Hi, I have a scenario to read records from Redshift table based on this condition below which I have it in all my Redshift snaps for the pipeline I am using. weekof < Post_prod_support7 and weekof != Post_prod_support7 At the end it checks for any re...

REST API returning tar.gz

I am attempting to make an API call that returns a tar.gz file. I want to convert it to a csv and then upload it to an S3 bucket. Note: S3 and aws is not set up yet but would like to be able to read it in and get that aspect down before they our team...

REST oauth2 authentication in Scheduled/Triggered task

Summary (new/inexperienced user) How do I configure a scheduled task/pipeline that hits a secured REST endpoint such that the oauth account required is authorized without manually intervention to allow use as a scheduled task? Background I have a pip...

How to expose pipeline as an interface for external client to call?

Hi, I have requirement to create a simple SOAP web service in snaplogic designer and expose the pipeline to external (eg:- Postman). Which Snaps that I can use in the pipeline in order to receive the value from Postman? Any suggestion or sample pipel...

SnapLogic - Integration Nation

Forum Posts

Can I use Dynamic SQL in SnapLogic?

Rerun a task manually

Error pipelines

Changing data types in Script Snap: Python

Redshift insertion even the condition is false

REST API returning tar.gz

REST oauth2 authentication in Scheduled/Triggered task

How to expose pipeline as an interface for external client to call?

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

Converting a string to JSON doesn't work