Designing and Running Pipelines

Rest API service endpoint returned erros result: Status Code =403

When configuring a REST Post of the mailjet API, it indicates the following message. Error: Reason: REST API service endpoint returned error result: status code = 403, reason phrase = Forbidden, refer to the error_entity field in the error view docum...

Trying multiple inputs into Directory Browser Snap

Hello Community! I am trying to design a pipeline which takes a list of S3 URLs generated by a Mapper and uses the Directory Browser snap to produce output. I am seeing that the pipeline runs, but only the first URL in the list is picked up by the Di...

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

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

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

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

Is there a way to selectively exclude fields output from a mapper snap?

I have a case where many fields may have to be excluded from mapper output, as if they never existed, selectively during a run. I am going to a cloud instance of a routine that will take null values in, and display them, or may delete wanted values,...

SnapLogic - Integration Nation

Forum Posts

Rest API service endpoint returned erros result: Status Code =403

Trying multiple inputs into Directory Browser Snap

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

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

JDBC Thin Client: Wallet

Resolved! Add single quotes in comma separated string

Pipeline Search in Dashboard

Is there a way to selectively exclude fields output from a mapper snap?

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