Designing and Running Pipelines

Date Validation using Expression Library

Hi, I’m developing a pipeline that uses date input parameters. I was looking to use an expression library to validate the date format by matching a regex pattern. For example, /^([1-9]|0[1-9]|1[012])/(0[1-9]|[12][0-9]|3[01])/(19\d\d|20\d\d)$/.test(“...

JSON Formating

Hi I have a set of data from ServiceNow that use a different header for each record and I would like to flatten this data to a single level. But I am not sure how as each header is different. See the example below; { "RITMNumber": "RITM3993", "numb...

Controlling Auto Commit

I have a pipeline with a jdbc execute with a select sql from source (postgres), Oracle Delete of target table, Oracle insert of target table. I turn auto commit off in the target oracle account. But for some reason after the Oracle Delete snap Sna...

Javascript plusMinutes() no longer working why?

I have a pipeline that uses the script snap and has java script in it. I use the .plusMinutes() which has been working fine for over a year, but now I am getting the following error message. “label=Script, failure=TypeError: pi.plusMinutes is not a...

Semantic URL Example

Hi, I would like to know how to correctly pass data via Semantic URL (as a Triggered Task via URL)? Here is what I did: Edit Pipeline Properties: I created an exampleId variable, if I wanted to pass a value of 1 to the exampleId variable: https://el...

Resolved! Create Key Value Pair instead of List/Array

Expression for Conversation.Text = $[‘$ConversationPost.Text’].toString().split(“|”).map((elem, index) => [elem]) Mapper Output: The desired output is: “ConversationPost” : { “Text”: “comment #2 US142”, “Text”: “comment #1 US142”, “Artifact” : “/h...

Migration to Snaplogic queries

Hi Team, We are migrating number of interfaces from WebMethods, SAP/PI and Cast Iron to Snaplogic. Below few points that’s needs your attention. a. Can we use some automated techniques in snaplogic that can read all connection details from existing s...

Snaplex running on Linux and I want to use the Script snap to execute a command on a remote Windows server

Our snaplex runs on Linux. I want to create a Script snap to execute a command on a remote Windows server. I was planning to use Python in the script snap. I’m looking for recommendation on which Python module to use. We don’t have SSH server install...

SnapLogic - Integration Nation

Forum Posts

Date Validation using Expression Library

JSON Formating

Controlling Auto Commit

Javascript plusMinutes() no longer working why?

Semantic URL Example

Resolved! Create Key Value Pair instead of List/Array

Migration to Snaplogic queries

Snaplex running on Linux and I want to use the Script snap to execute a command on a remote Windows server

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings