Designing and Running Pipelines

SQL Server - Update deadlock issue

Hello All, I am getting transaction deadlocked errors while Updating the records. The snap being used here is SQL Server Update. Transaction (Process ID 92) was deadlocked on lock resources with another process and has been chosen as the deadlock vic...

How to encrypt a field using RSA 1024 bit key?

Hello, I have a requirement to encrypt a field using an RSA 1024 bit key. I have tried using the ‘Encrypt Field’ snap but get an error - Key length not 128/192/256 bits. Any ideas? Thanks, Mark

Resolved! Loading jsonb postgres data

How can I load JSONB data using Postgres snaps? I’m able to load the data as TEXT type but not as JSONB type. Below is how I’m setting up my pipeline for inserting data to postgres db: Any answers would be appreciated!

How to Decrypt fields for an entire table at once?

Hello, We get a client’s data each week and we try to encrypt the data using encrypt snap and Keystore account. Next, for decryption, we save the encrypted fields for each file into a separate file and append the encrypted new weekly data to the hist...

Executing different SOAP request's based on input field value

Hello, I have to design a pipe line which is based on SOAP request. I have the wsdl. This is my first SOAP pipeline I have few queries. The SOAP Execute snap has three fields Service Name 2) Endpoint . 3) Operation. What values I have to give here, I...

Resolved! HDFS Writer Writing to ADLS Gen2

I am trying to upload a file to adls gen2 storage using OAuth method to connect The Account creation and validation was successfull But the Writer Fails with following error The ApplicationID/ClientID used is assigned as contributor to the storage a...

Logging from custom java jar in script snap

Hi, I have a Java Jar file which has a method inside a class that returns a string value, and I also have a log4j logger inside the method. I placed these 2 jars mycustom.jar and log4j.jar in node path. In script snap (python) I mentioned the path of...

Resolved! Merging two arrays

Hi there, I have 2 arrays that I need to merge; I have used Merge in Join Snap but they are not coming in as Output below. seems simple but missing something. Any guidance? Thanks Manohar INPUT **Array 1** [ { "order-lines": [ { "...

SnapLogic - Integration Nation

Forum Posts

SQL Server - Update deadlock issue

How to encrypt a field using RSA 1024 bit key?

Resolved! Loading jsonb postgres data

How to Decrypt fields for an entire table at once?

Executing different SOAP request's based on input field value

Resolved! HDFS Writer Writing to ADLS Gen2

Logging from custom java jar in script snap

Resolved! Merging two arrays

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

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling