Designing and Running Pipelines

Mapper expression required for encoding

Hi Team, Help required to implement below logic for one field in mapper snap. Please help API_KEY =“3456789dgghhjh” SECRET=“8889999456hhggth74kju” var payload = ‘POST\n\n’ + date.toString() + ‘\n’; hmac = crypto.createHmac(‘sha256’, SECRET); hmac.upd...

How to Get the previous 2 snap's snap label and snap instance id

Hi All, How to get the 2 previous snap label and snap instance id .

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

SnapLogic - Integration Nation

Forum Posts

Mapper expression required for encoding

How to Get the previous 2 snap's snap label and snap instance id

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

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

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...