Designing and Running Pipelines

Mapper following Group By Field

Hi Everyone, I have a record, that has a field of CSVs. I split the CSVs using the JSON splitter, and then use a group by fields snap to create my objects which have the recordId, and the individual values from the CSV field. I end up with what I nee...

Converting Objects with arrays into row format for DB storage

Hi, I have issue converting an object with array to a format that could be inserted into a table. I have a following dynamic JSON document: “testcode”: { “1203”: [1,2,5,6,8,10,11,12,13,14,16,17], “1205”: [9], “1206”: [7,3,4,15] } Above, testcode is s...

Problems with Date.parse() function

Hi, I have a problem with the Date.parse () function. I cannot convert a String to date, the format of my string is the following: “dd/MM/yyyy”. It only happens to me with some specific dates (with most data I have no problem). The problem occurs wit...

Resolved! Creating files in a different organization

Hi everyone, i’m having the following challenge: I’m documenting files on Gitlab which are at some point then promoted from the Dev organization to the Prod org. This promotion runs in the Dev organization. It turns out that the File Writer cannot wr...

Instances of ultra tasks stops receiving messages after multiple failures

Hi Team, We had an issue in Production and I need some assistance from you experts. I had one pipeline which is very complex one with multiple scripts snaps. And this pipelime receives messages from IBM Mq and we are using ultra tasks with 3 instance...

DateTime Parameter can't save to datetime field

I’m calling a child pipeline to do an insert I’m passing a datetime field, but in the child parameter it is now a string How do I convert it back to datetime? In the parent before I execute the child the value is: 1996-08-26T00:00:00.000 In the child...

Does snaplogic have a mechanism like includes method? array.includes("value")?

Does snaplogic have a mechanism like includes method? e.g. “AwardStatus”:[“ACCEPTED”,“OFFERED”,“CANCELED”], Something like $AwardStatus.includes(“CANCELED”) ?

File writing using smb path

Hi Good day, I am trying to write a file in the remote desktop server . Instead of hardcoding the data I have parametrized certain fields as we have sequential child execution running for each country. This is my path: ‘smb://sgkcawveemwdv02.astrazen...

SnapLogic - Integration Nation

Forum Posts

Mapper following Group By Field

Converting Objects with arrays into row format for DB storage

Problems with Date.parse() function

Resolved! Creating files in a different organization

Instances of ultra tasks stops receiving messages after multiple failures

DateTime Parameter can't save to datetime field

Does snaplogic have a mechanism like includes method? array.includes("value")?

File writing using smb path

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

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...