Designing and Running Pipelines

SnapLogic CI/CD with Exported slp files

I would like to build a CI/CD process that uses the exported slp files and compares them to the target environment and only overwrites them if there is a change. My original plan was to use the Metadata Snaps, but the “read” pulls a reference/pointer...

How to delete particular record from csv file

How to delete particular record from csv file eg. if the some record is processed from csv file then need to delete that record from csv file , please suggest how to proceed this. Thanks Mahes

Account Ref Functions in SnapLogic to refer credentials?

We have a requirement to pass credentials from external applications like centrify to our API calls. Instead of External, can i create a Snaplogic account and refer the password of that account using a ref function in the API call. In this case i can...

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

SnapLogic - Integration Nation

Forum Posts

SnapLogic CI/CD with Exported slp files

How to delete particular record from csv file

Account Ref Functions in SnapLogic to refer credentials?

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

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

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap