Designing and Running Pipelines

Resolved! Capitalize First Letter of Every Word in a String

Is there a good way to capitalize the first letter of every word in a string with the rest lowercase natively in a Mapper or other snap? For example: fort worth => Fort Worth SAN ANTONIO => San Antonio I see the upperFirst() and capitalize() function...

Error while trying to Upgrade Java 8 to Java 11

Hi, We are working on Upgrading the Groundplex nodes from Java 8 to Java 11, I am following the steps mentioned in the below link https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/850067457/Configuring+the+Java+Version+on+your+Groundplex#Conf...

Does snaplogic supports internal messaging systems

Hi Team, I am trying to do a migration from WebMethods to snaplogic. In Webmethods it has used internal universal messaging queues for any storing any data. Does snaplogic has internal queues to support this functionality or we have to use any extern...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Capitalize First Letter of Every Word in a String

Error while trying to Upgrade Java 8 to Java 11

Does snaplogic supports internal messaging systems

Date Validation using Expression Library

JSON Formating

Controlling Auto Commit

Javascript plusMinutes() no longer working why?

Semantic URL Example

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