Designing and Running Pipelines

How to create a report on Tasks Invoked by Specific User in SnapLogic?

Hi Everyone,I created a user with administrator privileges to invoke pipelines in a project using a username and password. However, I now want to reduce the user's role to a lower level.Before making this change, I want to ensure it won't disrupt any...

Get order of records within a group

I have a situation something like this: Employee IDEffective DateOffice11/1/2023San Francisco11/1/2024Oakland26/1/2023Sydney212/1/2023Tokyo I need to add an order column and end date of the previous record column. Can you please suggest any ways of ...

Using Workday RaaS to Extract Data

Using Workday RaaS to Extract Data Workday has a Reporting as a Service (RaaS) interface which allows you to export most data from Workday by creating a custom report within Workday then exposing it as a web service. The output can be various format...

How to split files based on size(less than 20mb per file) when writing into S3

Hello,I need to write files into S3 by keeping file Size(<20mb) ,rather than giving number of records batch limit using pipeline execute. My input is dynamic sometimes 1k records write file >20mb , sometimes 10k records is <20mb. We also have batches...

Resolved! how to filter out spaces

How do I remove spaces from the output ?Output of this pipeline is [ {"lrs": ["Indiana","Alabama",""] }]

Combining REST Get Queries into Single Snap

I have a two part question. I have to perform 3 queries to extract information from an application. I can put all 3 queries in the same REST Get snap. First question is…is this better or worse than using 3 separate REST Get snaps? Second question d...

Iterate JsonArray in parent to call child pipeline

Hello Community members,I have a scenario to discuss, if you can provide your assistanceI am receiving JSOnArray in pipeline which I am then splitting using Json splitter and those individual documents I am passing to child pipeline.In child pipeline...

How to loop thru N times

I have an input of 1000 Records coming in. I can only process 200 records at a time. How can I write a loop for this ?

SnapLogic - Integration Nation

Forum Posts

How to create a report on Tasks Invoked by Specific User in SnapLogic?

Get order of records within a group

Using Workday RaaS to Extract Data

How to split files based on size(less than 20mb per file) when writing into S3

Resolved! how to filter out spaces

Combining REST Get Queries into Single Snap

Iterate JsonArray in parent to call child pipeline

How to loop thru N times

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