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

Forum Posts

Resolved! Remove JSON Key when value is "" or null

I have a json [ { "opportunity_Id": "Abc1", "sales_account_id": "Abc2", "account_name": "Pitney Bowes Inc.", "city": "Shelton", "address": "27 Waterview Dr", "requested_by": "Abc3@Abc3.com", "postal_code": 6484, "fax...

ajs by New Contributor II
  • 6994 Views
  • 6 replies
  • 6 kudos

Resolved! Detect XML attribute xsi:nil and apply null value

I am using a SOAP Execute to retrieve information from an API. The payload is being converted to JSON. The problem is any field that is null returns with an attribute of @xsi:nil:“true”. This is just an example subset. There are actually more tha...

Thom by New Contributor II
  • 4815 Views
  • 4 replies
  • 0 kudos

JDBC Thin Client: Wallet

Hi, I have a question regarding Oracle Thin Dynamic Account. How could I connect to Oracle ATP with a wallet? Oracle says, the the wallet needs to extracted in a directory. Then I can use the Custom JDBC URL with jdbc:oracle:thin:@dbname_high?TNS_ADM...

Birthe by New Contributor
  • 814 Views
  • 0 replies
  • 0 kudos

Resolved! Add single quotes in comma separated string

Hello, I have a scenario where the location name will come in 2 different scenarios from an API as mentioned below. LOC1LOC1, LOC2, LOC3 The expected output should be ‘LOC1’‘LOC1’, ‘LOC2’, ‘LOC3’ I tried using the split and replace function but in va...

Pipeline Search in Dashboard

Hi everyone, Does anyone know how to search for pipelines, in Dashboard/Health, based on exclusion. For example, if it is easy to only show pipelines containing in the name “pipelineXYZ”, how can we show all runs of pipeline excluding “pipelineXYZ”? ...

eric_sou by New Contributor III
  • 2452 Views
  • 4 replies
  • 0 kudos