Designing and Running Pipelines

Secured SOAP WS from Snaplogic

Hi Folks, I have a requirement where i need to call a secured SOAP WS. I have got the chain of certificates from the webservice team i.e. Root, intermediate and CA. Can someone instruct me how to install the certificates on Snaplogic and how to use t...

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

SnapLogic - Integration Nation

Forum Posts

Secured SOAP WS from Snaplogic

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

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

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling