Designing and Running Pipelines

Performance with Triggered task

As part of our project requirement, we are using Triggered task and observed that performance is not as expected. So, can someone help to understand whether the trigger task has some latency in general to complete the transaction?

How to split the string on the basis of length of bytes

How can i Split string( UTF-8) on the basis of bytes length and not on the basis of character counts. e.g String > 4000 bytes then split the string into multiple columns each not more than 4000 bytes. Like, if string1 ~ 10,000 bytes then, first 4000 ...

Writing files to on-premise servers

I am trying to write a file that gets created in a pipeline to one of our on-premise servers (i.e. sftp://ourschool:22/directory/filename.txt) and am getting the following error message: Unable to create filesystem object for sftp://ourschool:22/dire...

Best practice for adding Subscribers to an AWS SNS topic

Apologies if this has already been covered, but I can’t find anything on the search. We need to add Subscribers to an AWS topic in bulk. The most basic use case of this will be a list of Subscribers and adding them via SnapLogic to an empty AWS SNS T...

Pipeline Parameter in create statement

I have to pass the pipeline parameter as part of the table name in create table statement. Can you please share the syntax. Ex: “Create table “_jobname”+c1temp (abc , xyz …)” . it gives could not compile error…

Router with more that 2 conditions

Hello , I am creating a pipeline that should fetch the filetype from the expression libray file and based on the filetype it should write the file. But I noticed that though the condition written in the router is correct, it is routing to multiple p...

Resolved! Set Date to 1st of Current Month

I am trying to get the current date and convert it to the 1st of the current month of the current year. The resulting format should be dd/mm/yyyy SnapLogic doesn’t recognize this expression (even without the Date.parse): Date.parse(Date.now().withDay...

Currently experiencing large load times

we currently have a pipe that queries salesforce via SOSL for search results. Using a normal *non ultra) pipeline task with a bearer token. When are using json to recieve and parse information then returning (non mapped) json to the requester. This w...

SnapLogic - Integration Nation

Forum Posts

Performance with Triggered task

How to split the string on the basis of length of bytes

Writing files to on-premise servers

Best practice for adding Subscribers to an AWS SNS topic

Pipeline Parameter in create statement

Router with more that 2 conditions

Resolved! Set Date to 1st of Current Month

Currently experiencing large load times

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