Designing and Running Pipelines

How to do partitioning of the incoming data in a file without inserting into a database table

Hi Team - I need to do a partitioning of incoming data in a file for 1 column field without inserting into a database table.For e.g. in Oracle I can use this: SELECT row_number() over(partition by T.ndc order by T.ndc) row_num FROM TEST T;

Resolved! Transform single record to 2 records in CSV

Hi there, I am trying to split this into 2 records as below and write it to a csv file. Can anyone suggest how I can do this? NAMEACTIVESTL_TEXTSTL_CODEKRS_CODEPARENT_KRS_CODEJohn Dow Equipment LLCYesSample Equipment2678173486John Dow Equipment LLCY...

Development best practices - expression vs Inline queries and Git

We have a large number of snap pipelines inherited on a project and I wanted to ask for some best practices on maintaining those pipelines. How much should we put in expression files? Should we put all of our queries in SQL snaps in expression querie...

How to host an SCIM endpoint

Hello, Please help me understand if it is possible to host custom endpoints to trigger the pipelines. For example I want to host APIs for SCIM which have parameters like /user or /users/{id} or /groups in the endpoint which an external tool or user c...

Triggered Task respond with plain unformed text (not JSON)

Hello, How can I make a triggered pipeline respond with plain text vs something structured? e.g., it should return: My Return Text Here and not anything like this: [ { returnText: “My Return Text Here” } ] Thanks!

Resolved! JSON Lines with each entity in individual line - Json formatter

Hello, My pipelines are in two stages. Pipeline 1 . File pipeline I’m loading 5 records of Json data to a s3 file with ‘Json Lines’ attribute checked. Pipeline 2 . Using the s3 file created in Pipeline 1 in a REST POST, to call an API by passing it...

When executing pipeline it throws error with JMSWMQ2008

Hi, i`m new to snaplogic, i have a simple pipeline like: File Reader → JMS Producer In File Reader i set a path to a csv file In JMS Producer i set Destination with a name of a queue like QUEUE_NAME1 Destination type : QUEUE Messafe type: TEXT When i...

How to ping a server using Snaplogic

Is it possible to ping a server and check if it is up or down using the script snap with some python or js code? How it can be and works?

SnapLogic - Integration Nation

Forum Posts

How to do partitioning of the incoming data in a file without inserting into a database table

Resolved! Transform single record to 2 records in CSV

Development best practices - expression vs Inline queries and Git

How to host an SCIM endpoint

Triggered Task respond with plain unformed text (not JSON)

Resolved! JSON Lines with each entity in individual line - Json formatter

When executing pipeline it throws error with JMSWMQ2008

How to ping a server using Snaplogic

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?