Designing and Running Pipelines

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

Deleting a Value in Workday

I have been trying to delete a field on an object in Workday and haven’t found a way. If I’m just writing a SOAP request, I can pass in an empty tag like “< emptytag/>” to delete a value. With SnapLogic, I’m not sure how to achieve that. I have tr...

SnapLogic - Integration Nation

Forum Posts

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

Deleting a Value in Workday

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?

Remove XML duplicate key from JSON list in XML for...