Designing and Running Pipelines

Unable to execute Redshift Script with comments in it using Redshift Execute

Hi All, I am using redshift execute to run a redshift script . While I am able to run the script when every redshift query is enclosed in double quote, but the script is failing when I am adding comments to that. Would like to know how to write comme...

Seclore encrypted file processing

Hi, I have a file which is encrypted by ‘Seclore’ and now I wanted to read this file data using SnapLogic and write it to text format. To read the data in my local system I have installed ‘Seclore Desktop Client.exe’ software which is decrypting this...

Resolved! Including payload in REST Get Snap

Hi, I need to call a REST GET method but it needs a payload e.g. {“path”: “xyz”}. I can’t find anyway to call a GET endpoint and include a payload in Snaplogic, does anyone have a solution? Thanks

Updating part of a JSON Document

Mapper output is shown below. I would like to update the InstrumentIdentifiers section in the JSON with the Tickers section. In other words, the Array of JSON fragments under Tickers should come under InstrumentIdentifiers. Second Image shows the J...

What is the maximum allowed length of Triggered URL?

Hello, If I have a triggered task that I’m passing parameters to as key=value pairs in the query string, for example: https://elastic.snaplogic.com:443/api/1/rest/slsched/feed/.../task/?param1=123&param2=456 What is the maximum allowed length of that...

Does NS Search Snap takes the date paramter as the criteria along with the saved search id?

Hello, We have a requirement for which we need to get the data using the NS Saved search. We have the savedSearchScriptId with us and we are passing this id to the NS Search Snap. We have enabled body fields, advanced fields and etc. The NS Search S...

Resolved! Mappping element of a Subarray of a JSON document in mapper snap

Hello, I have an issue with splitting a JSON document in a mapper. In short, this document is received via a REST Get Snap and certain elements of it should be mapped to certain names, think for example: Received JSON: { “Property1”:“value1”, “Proper...

Using Oracle Execute to run complicated SQL Select not returning any data

I’m new to SnapLogic and was told by one of our senior SL developers that instead of using the Oracle Select snap, I could use the Oracle Execute snap to run a complex SQL select statement. When I try to do that though, I get no data and I can’t fig...

SnapLogic - Integration Nation

Forum Posts

Unable to execute Redshift Script with comments in it using Redshift Execute

Seclore encrypted file processing

Resolved! Including payload in REST Get Snap

Updating part of a JSON Document

What is the maximum allowed length of Triggered URL?

Does NS Search Snap takes the date paramter as the criteria along with the saved search id?

Resolved! Mappping element of a Subarray of a JSON document in mapper snap

Using Oracle Execute to run complicated SQL Select not returning any data

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap