Designing and Running Pipelines

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": [ { "...

Scheduled Tasks with No end date stops

All, Would like to know if any one has experienced stoppage of schedule tasks. We have a scheduled tasks without any end dates and its was disabled on its own. What could be the reason? Thank You, Sombit

Resolved! Sort internal array

hi there, I have a inbound json thats coming this way. How can I sort the Order-Lines array based on line-num in asscending order. tried to use sort but did not work. any other solutions? Thanks Manohar [ { "order-lines": [ { "lin...

SnapLogic - Integration Nation

Forum Posts

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

Scheduled Tasks with No end date stops

Resolved! Sort internal array

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings