Designing and Running Pipelines

Can I read multiple CSV files located in my local drive using Snaplogic?

For example a file present in my G drive - using Multi File Reader or File Poller. I tried using file:///G:/Snaplogic Sandpit/ in Folder/File - and wanted to use *.csv in wildcard

Transpose data from Excel

HI, Could someone tell me how to transpose data from excel. My Excel input has Pivot data, i need to transform everything to rows. I started with File reader and then used Excel parser to define the row and column, but not sure how to transpose data....

Adding dependency before execution of task or pipeline flow

Hi Team, we have requirement to add dependency on source system refresh time. I want to check the refresh table if it is greater then yesterdays run only then I want to execute the pipelines in case the table is not updated the flow should trigger a...

Resolved! JSON value split by comma

Hi, I’m trying to split the value “ConfigValue” string in the following JSON : [ { PipelineID: 25 PipelineName: “CashValue_Main” ConfigName:“CashValueDates” ConfigValue:“1218, 1217” } ] Into a JSON document like this: { “YearEnd”: 1218 } { “YearEnd”:...

Using URI parameters

Hi Team, Can you please help us on working with URI parameters in Snaplogic with a sample pipeline? Thanks, Sravanthi

How to correctly log API call execution time

Hello everybody, I want to create some metrics related to API call time. For now, I am trying to subtract date.now and pipe.startTime using following expression (Math.trunc((Date.now() - pipe.startTime)) ) in mapper preceded by REST POST. Sceleton of...

To add Header & Trailer records

Hi, I have a requirement to add header and trailer records to a text file before writing to a server. Can any one guide me how to achieve this functionality. Thanks,

Resolved! Assistance requested creating pipeline for SQL query-->mapper-->text file

My goal is to execute a SQL query, return data, and format it so that it is accepted by a custom app we run here. So far, I have extracted the necessary data and formatted it using a mapper. The mapper output contains three columns that I need to m...

SnapLogic - Integration Nation

Forum Posts

Can I read multiple CSV files located in my local drive using Snaplogic?

Transpose data from Excel

Adding dependency before execution of task or pipeline flow

Resolved! JSON value split by comma

Using URI parameters

How to correctly log API call execution time

To add Header & Trailer records

Resolved! Assistance requested creating pipeline for SQL query-->mapper-->text file

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?