Designing and Running Pipelines

Create reusable lookup that we call multiple times in the same pipeline

We have requirement where we have multiple data quality rules configured in a Oracle table for each pipeline that loads different tables. Each rule also has a severity associated with it. Ex: If when are reading Employee data we want to check if Empl...

Resolved! SQL Table into Excel File

I have a pipeline that I am working on that requires data to be extracted and transformed in SQL Server (completed) and should be loaded into a single excel file. I cant seem to get my data into an excel file. Has anyone completed a similar load, if ...

How to remove null value objects from json

Hello Team , can you please let me know how to remove null value objects . Below is the example Thanks in advance ! here is input – INPUT { "ESTDATA": { "TITLE": "Testing", "DESCRIPTION": "Testing Json", "VERSION": "", "CURRN": "", "TRANDS...

Replace values from one file in another file

Hi Team, We are new to snaplogic and have started building pipelines. There are few cases where we are having challenges. I have two csv files. Image 1: The first column has the column names which are present in the file shown in Image 2. Question:...

Generate sequence of dates between 2 dates

i have a requirement to “fill in the gaps in time” per se on data from a system. Here is my use case: A customer signed up with the company for $100 subscription monthly for 3 years. The company added services 6 months into the contract which bumped ...

Remove emply/null value fields from JSON

Can you help me to remove empty/null value fields from a JSON structure? Kindly suggest pipeline design suggestion or expression language for the below expected results. Thanks! Input: { “INVOICE”: { “TITLE”: “Test”, “DESCRIPTION”: “Test124”, “VERSIO...

Resolved! Capitalize First Letter of Every Word in a String

Is there a good way to capitalize the first letter of every word in a string with the rest lowercase natively in a Mapper or other snap? For example: fort worth => Fort Worth SAN ANTONIO => San Antonio I see the upperFirst() and capitalize() function...

Error while trying to Upgrade Java 8 to Java 11

Hi, We are working on Upgrading the Groundplex nodes from Java 8 to Java 11, I am following the steps mentioned in the below link https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/850067457/Configuring+the+Java+Version+on+your+Groundplex#Conf...

SnapLogic - Integration Nation

Forum Posts

Create reusable lookup that we call multiple times in the same pipeline

Resolved! SQL Table into Excel File

How to remove null value objects from json

Replace values from one file in another file

Generate sequence of dates between 2 dates

Remove emply/null value fields from JSON

Resolved! Capitalize First Letter of Every Word in a String

Error while trying to Upgrade Java 8 to Java 11

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?