Designing and Running Pipelines

ZipFile Writer - creating multiple zips

I’m currently trying to build an integration where I need to take a large volume of files (photos) and zip them up into separate zips that aren’t larger than a certain size (as the destination has a limit on how large the zip files can be). I current...

Error connecting to Azure SQL

Greetings, We are trying to connect to an Azure SQL database and we are getting the following errror… The port is 1433 because we checked in our DB properties… Screenshot_2020-05-20 17.52.42_ITXy5I|690x83 We have tried many different things so I am t...

Diff shows identical rows as modified

I am using a Diff Snap against two inputs in which the rows look like below, and the Snap is outputting to the Modified output View. I have found it’s because of the dates, meaning, I have rows without Dates, and they end up in the Unmodified Output ...

Resolved! Retrieving the value of a sibling from a JSON payload

Hi, I’m trying to extract the object_id of the object with path=“/Test_Engagement_A17” and write this to a pipeline property in a Mapper. Could anyone give me a pointer? Thanks. “objects”: [ { “object_type”: “DIRECTORY”, “path”: “/Test_Engagement_A19...

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

SnapLogic - Integration Nation

Forum Posts

ZipFile Writer - creating multiple zips

Error connecting to Azure SQL

Diff shows identical rows as modified

Resolved! Retrieving the value of a sibling from a JSON payload

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

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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