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

Best Approach for Handling CSV Import with Truncat...

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?