Designing and Running Pipelines

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

Excel Parser : reading formatted values instead of the original value

Hi there, I am using excel file to read the sheet and i am noticing that it is truncating decimals. It reads the formatted column values instead of the actual values… for example … Value: -123.943661971831 is read as -$123.94 Whereas i want the actua...

SnapLogic - Integration Nation

Forum Posts

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

Excel Parser : reading formatted values instead of the original value

Trim and convert string into Date

How to output the SQL statement that was executed ...

How to identify if there are no files in the sourc...

Decode column name that has @ as a prefix

Cannot call parameter in the error pipeline

Formatting CSV data for XML output

Get MIN (oldest) or MAX (most recent) date from ar...

Line Break in Mapper

how to filter out spaces

Expression to extract values in nested JSON object...