Designing and Running Pipelines

Resolved! JSONPath where key or value starts with @ character?

0 I am attempting get a value based on the key containing @ symbol fails using JSONPath. Cause: Since @ is the current object/element, json does not return the value. Sample 1: { “firstName”: “John”, “lastName” : “doe”, “phoneNumbers”: [ { “type” : “...

Infor Visual 7

Hello, We are trying to integrate from Coupa (expenses that are OK to Pay) to the Infor Visual ERP. This is an old version of Visual (2011) and there are no APIs. Our approach is to go directly to the underlying SQL Server Database. Does anyone have ...

For important values storage

I have some important values that I dont want anybody including me can see as plain text and further I can use those values in any snap. So what is the recommendations to store those values?

Passing Cdata to xml

Ho wcan I pass CDATA to SOAP execute

Do we need JDK installed to use JDBC snap?

I have on-prem groundplex. We need to connect mainframe Db2 database. I heard we can do that by using JDBC select snap. In order to use JDBC snaps, do we need JDK installed in our machine?

JDBC connection error - Db2

Trying to set account for connecting to Mainframe DB2 database using JDBC Select snap with the below information. I received below error. Can someone help me to fix this.? Failed to validate account: Failed to retrieve a database connection. Cause: [...

Need to do lookup on multiple tables without using join

I have 30 tables to lookup on 30 respective columns, In case of other ETL tool we had lookup as a function to do it independently in a single transform. In snaplogic, I am not sure how to do it. I can combine all 30 into a single lookup table like So...

Resolved! Replace All Case Insensitive Based on Incoming Value

Hello. I am having some issues getting “replace” to work the way I want; kindly have a look. This works: $Name.replace(/ron/gi, “Ronald”) So does this: $Name.replace($OldName, $NewName) But, I want the above to also work with the “gi” option but it d...

SnapLogic - Integration Nation

Forum Posts

Resolved! JSONPath where key or value starts with @ character?

Infor Visual 7

For important values storage

Passing Cdata to xml

Do we need JDK installed to use JDBC snap?

JDBC connection error - Db2

Need to do lookup on multiple tables without using join

Resolved! Replace All Case Insensitive Based on Incoming Value

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