Designing and Running Pipelines

Create a scheduled task in a different project space

We have a requirement to create many different scheduled tasks for different clients, but they will all be executing the same pipeline. For clarity we’d like to keep tasks for each client in their own project space, but the task scheduler UI requires...

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

SnapLogic - Integration Nation

Forum Posts

Create a scheduled task in a different project space

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

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?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...