Designing and Running Pipelines

Dynamic File Writer filename after XML Formatter possible?

Hello, Is there a simple way, to pass filename to File Writer, after XML Formatter was executed? In the Mapper: filename shall be constructed into $filename. XMLJSON content for saving als XML shall be constructed into $content XML Formatter makes an...

Get unique original input file name before file delete

Hi, I have a requirement where I need to split batch input xml and process it and at the end delete the input batch xml from the directory. Everything is working but at the end since it is creating multiple xml and I do a join to get original input x...

Reading BLOB data from SQL and write it to file share

Dear Community, I am successful in creating a pipeline that read blob data from SQL server and writing the file in SLDB. Now, I wanted to write the file on an SFTP server using File Writer - validation is okay but failed during execution. protocol: ...

Time format Conversion changing the date

I am doing date conversion. But not sure why it is changing the date. Input Date is : “29-JUN-21 10.07.35.000000 AM” Output date is becoming :“2020-12-27 10:07:35” The conversion I am using is : Date.parse($OrderDetailCreateDate,“dd-MMM-YY hh.mm.ss....

Resolved! Snaplogic Redshift Copy Command

Hi Team, When I read data from a file/csv and do a bulk load, into redshift I know that at the backend it’s trying to copy the data and tries to do the bulk load. Here…I need to know what was the full set of options the Snaplogic code used for the Re...

Unable to connect to SnapLogic MySQL to AWS MySQL instance but able to connect to that instance in AWS environment

Hi Team, When tried to connect to mySQL select in Snaplogic with instance in AWS account getting below mentioned error. Failed to validate account: Failed to retrieve a database connection. Cause: Communications link failure The last packet sent succ...

Read File Name from SFTP

Hello , How can we capture the name of the file picked up from the SFTP if we are reading multiple files at a time? I dont want to use child pipeline but want to capture file name to be used at very end to pass onto email snap? Thank you in advance!!

SCD 2 in snaplogic with snowflake as target table

hi team, would like to implement scd type 2 in snaplogic and target dw is snowflake table. scenario : 1) Need to select sample txt / json file from local drive 2) process file into snowflake table 3) what are the snaps and how it links in pipeline ...

SnapLogic - Integration Nation

Forum Posts

Dynamic File Writer filename after XML Formatter possible?

Get unique original input file name before file delete

Reading BLOB data from SQL and write it to file share

Time format Conversion changing the date

Resolved! Snaplogic Redshift Copy Command

Unable to connect to SnapLogic MySQL to AWS MySQL instance but able to connect to that instance in AWS environment

Read File Name from SFTP

SCD 2 in snaplogic with snowflake as target table

String replace method where pattern is dynamic

Send Multiple HTML Tables in Email using XML Parse...

Email Sender Snap - Send data as HTML Table

Creating a pipeline involving user interaction in ...

How to add an object into an array

Writing to Pipeline Parameters within Pipeline

Email Sender Snap - HTML Table printing grouped va...

error 3 upstreams for join

How to add a snap that does nothing.

How to find if the entity exists in an array or no...