Designing and Running Pipelines

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?

Resolved! Conversion of json file to Reltio Specific format

Hello, We are creating a data interface between snaplogic and reltio with a .json file. Reltio expects the .json file to be in a specific format as below: Notice the ‘new line’ i.e ‘\n’ inserted after every record of json data. We tried scripts hook,...

SnapLogic - Integration Nation

Forum Posts

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

Resolved! Conversion of json file to Reltio Specific format

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