Designing and Running Pipelines

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

Resolved! Convert Date.now() to the Day of the Week Name

This may have been asked before, but I can’t find a solution. I need to extract the weekday name from the current date. In other words, today is March 8. I need ‘Monday’. Date.now().getDay() returns the number 1.

Setting Option set values in CRM

Hi Everyone, Can you set an optionset value using the int value rather than the string name? Also, do we need to refresh the meta data after adding new values in our CRM environment? We’ve added a new value which we can see in the front end and in th...

Resolved! How to read the value from an array using expression builder and return true or false

My initial JSON looked like below "customFields": { "textCustomFields": [ { "fieldId": "10546710413", "name": "templateUsageRestriction", "show": "false", "required": "false", "value": "allOptions...

Jsonb Data Integration

Hi, I am trying to load a table data from a AWS RDS instance to another AWS RDS instance. For e.g. Instance 1 : Table A (ID Int , Column1 jsonb , column2 Varchar) Instance 2 : Table A (ID Int , Column1 jsonb , column2 Varchar) created a pipeline usin...

SnapLogic - Integration Nation

Forum Posts

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

Resolved! Convert Date.now() to the Day of the Week Name

Setting Option set values in CRM

Resolved! How to read the value from an array using expression builder and return true or false

Jsonb Data Integration

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