Designing and Running Pipelines

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

Dynamic file name in excel format

I want to name a file dynamically while creating an excel, the csv formatter allows dynamic file naming but not the excel formatter. I am having issues with the csv formatter, it does name the file dynamically but the csv file does not show all field...

Resolved! Search in Array

hi there, I have data coming in these structures source1 - { "@type": "array", "order-line": [ { "line-num": "00010", "attachments": { "@type": "array", ...

SnapLogic - Integration Nation

Forum Posts

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

Dynamic file name in excel format

Resolved! Search in Array

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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?