Designing and Running Pipelines

Counting headers in CSV

Hi Team, I was trying to develop a pipeline where it compares the data of two systems . I have collected huge data from those two systems and I need to find the mismatch of data . I thought of splitting this work in two ways . First to find the misma...

Need help with NetSuite Deposit creation using NetSuite Create snap

Dear Members, I need an insight of how to create NetSuite Deposit using NetSuite Create snap. During the deposit we link the payment transactions (using $record.paymentList.depositPayment[*]) to the deposit. I would like to know, which attribute do w...

Resolved! Transforming into JSON Array

Hello All, I have a requirement where I have to merge two same keys within a JSON array to form a JSON array of themselves. The below provided examples will clear the requirement: Input JSON: [{ “header”: { “batch_id”: “PVTS_20200919_866184”, “compan...

How to determine if today is between 2 dates

A task I frequently need to do is determine if today is between 2 dates (without time). I’m wondering if anyone has found a more elegant way to do this? I’ve been converting the start and end dates from an oracle database, and the current date to st...

XML Formatter error

Hi Folks, i am getting below error in XML formatter. Failure: Failed to canonicalize XML., Reason: The reference to entity “D” must end with the ‘;’ delimiter., Resolution: Failed to read the XML document, please try again. Please help.

Expression Library - Environment Variable

Hi all, We are looking at building a solution for loading variables into pipelines via the expression library feature. One feature we would like to include is when loading the external library it will select the file based on the environment(ORG) tha...

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

SnapLogic - Integration Nation

Forum Posts

Counting headers in CSV

Need help with NetSuite Deposit creation using NetSuite Create snap

Resolved! Transforming into JSON Array

How to determine if today is between 2 dates

XML Formatter error

Expression Library - Environment Variable

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

Infor Visual 7

Best Approach for Handling CSV Import with Truncat...

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?