Designing and Running Pipelines

Aggregate Snap

Hi , I was trying to extract repetitive string from the source using aggregate snap by specifying count condition and filtering for the count>1 . I don’t get the desired output instead it fetches only unique elements . Can someone suggest any alterna...

ServiceNow Snap

I am using the the ServiceNow Snap to request data from SNoW tables and I would like to pass SNoW, such as sysparm_limit, sysparm_exclude_reference_link, sysparm_display_value etc. However if I put the sysparms in the query field they do not work. D...

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

SnapLogic - Integration Nation

Forum Posts

Aggregate Snap

ServiceNow Snap

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

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