Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Remove emply/null value fields from JSON

Can you help me to remove empty/null value fields from a JSON structure? Kindly suggest pipeline design suggestion or expression language for the below expected results. Thanks! Input: { “INVOICE”: { “TITLE”: “Test”, “DESCRIPTION”: “Test124”, “VERSIO...

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

Fischerd by New Contributor
  • 5094 Views
  • 7 replies
  • 1 kudos

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

peter by New Contributor III
  • 1485 Views
  • 2 replies
  • 0 kudos

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

Mark by New Contributor II
  • 1332 Views
  • 0 replies
  • 0 kudos