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?

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

Netsuite - dynamically passing the object name

I saw in Netsuite I can pass the object statically like below reference screenshot marked yellow, is there any way I can dynamically pass the object name like with ‘=’?

SnapLogic - Integration Nation

Forum Posts

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

Infor Visual 7

For important values storage

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

Netsuite - dynamically passing the object name

Error pipelines and pipeline execute

records to json file

Combine CSV document into a new file

Only execute child pipeline if BigQuery result is ...

Create a date range by hour

SOAP execute snap vs REST post/Http client snap

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file