Designing and Running Pipelines

Resolved! Route the Pipeline based on the location (Cell range) of a Column in the Source excel file

We have two different version of Source file in one version the CashInvoicePaymentTerm table is available on Cell 88-B as shown in the below screen shot. Again, in another version the CashInvoicePaymentTerm table is available on Cell 117-B as shown ...

Check if the element in the array is empty or not

[ { “test”: [ { “group1”: “”, “id”: 1 }, { “group1”: “test”, “id”: 2 } ] } ] How can i check if group1 is empty or not?

Fields are auto appended at the end

Hi Good day, I am stuck at an issue where I happened to find there is an extra string getting appended at the end of the field name. We are filtering the Japanese field name based on certain conditions. I am processing the field name (バイオの選択) While p...

JSON Generator with 'Or' operator

Hi All I am reading an excel file which is having multiple worksheets in it. I need to check whether the worksheet name is matching with the Sheet name specified in JSON generator snap or not. Customer has recently came back and said that one of the ...

Check if field inside array has value and route the output

[ { “items”: [ { “test”: " ", “id”: 1 }, { “test”: “test”, “id”: 2 } ] } ] Currently we have an array like this , we need to route the output from the Router based on the test field , if there is a value the output should go to the upper branch if th...

Resolved! How to create new array if there are more than 100 elements in the array

Hi , currently we have an array that contains more then 100 elements , approximately 168. Is it possible with some transformation in the mapper to create another array that will contain the rest 68 elements ? We would have 1 array with 100 elements a...

How to use private key file under the "Key Store" option of "JWT account"

Hi Snaplogic team- We would like to use the snap “JWT Generate” for one of our pipelines. While creating “JWT account” (that will be used in the snap “JWT Generate”), we ran into an issue. Under “JWT account” options, there is a field called “Key Sto...

Database Poller

Hi Team, I have a requirement which is near to Realtime where the data from Oracle database has to be polled/picked and insert/update in the MongoDB for every 3 seconds. Is there any possibility of do this in an ultra where polling should be done fro...

SnapLogic - Integration Nation

Forum Posts

Resolved! Route the Pipeline based on the location (Cell range) of a Column in the Source excel file

Check if the element in the array is empty or not

Fields are auto appended at the end

JSON Generator with 'Or' operator

Check if field inside array has value and route the output

Resolved! How to create new array if there are more than 100 elements in the array

How to use private key file under the "Key Store" option of "JWT account"

Database Poller

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