Designing and Running Pipelines

Resolved! Can we round integers to 2 digits?

Hi Team, I was using the Math.round() but was wondering if we can decide on the decimal digits for the rounding. For example, number = 3.14125252 Desired output = 3.14 With Math.round(), output is 3. Any suggestions on how to use the native Round(num...

How i retrieve status information of master pipeline using Snaps in designer? without using dashboard and tasks

Hi.i am new learner in snaplogic please help me .I need to trigger an email when the master pipeline is running longer than expected like an hour is an usual expectation. how can i perform this job in pipeline? if my pipeline is running more than exp...

Transform JSON to Ndjson

Hi, I am getting JSON from my SQL Server - Select snap I want to convert it into NDJSON to push the data into ElasticSearch example:- the data from SQL server: [ { “Id”: “1”, “Type”: “student”, “Name”: “s one”, “Age”: 27 }, { “Id”: “2”, “Type”: “teac...

Fixed Width Formatter Generate Blank file

Hi, I am using fixed width formatter in my pipeline and If I don’t have any data in the source and fixed formatter generates one output and create a blank file. Do we have any other functionality similar to ignore empty stream.

Resolved! RPE only returns small proportion of documents

I have a RPE running with the snaplogic recommended data science docker image. When i pass documents to the remote python script (hundreds, sometimes thousands) I only get around 1% of the documents back from the snap. Even when i literally pass the ...

Resolved! Convert data from SQL select to JSON

What is the best way to take data from a SQL Select statement and convert to JSON so that it can be used in a API put commend?

Passing a custom sql server data type into a stored procedure

Given the below sql server procedure definition excerpt. How would we pass in an array of data into this this datatype as the input parameter of the stored procedure. when passing in a straight array of values we get the following error. “reason”: “E...

Error message on snowflake bulkload

I am trying to migrate the data from MySQL to Snowflake DB. I am getting th following error message with snowflake bulk load snap. I have entered the data for all the columns but still getting the same error. “reason”: “The·input·to·the·SF·Bulk·Load...

SnapLogic - Integration Nation

Forum Posts

Resolved! Can we round integers to 2 digits?

How i retrieve status information of master pipeline using Snaps in designer? without using dashboard and tasks

Transform JSON to Ndjson

Fixed Width Formatter Generate Blank file

Resolved! RPE only returns small proportion of documents

Resolved! Convert data from SQL select to JSON

Passing a custom sql server data type into a stored procedure

Error message on snowflake bulkload

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

Parsing CSV file

Data Validator Pattern error