Designing and Running Pipelines

Resolved! LDAP Delete Attribute - Clarification

I just want to verify the function of this snap, since I don’t have a staging Active directory available in which i could test this. The documentation states that it ‘will completely remove the attribute itself’, which isn’t fully clear to me, could ...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! LDAP Delete Attribute - Clarification

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

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

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...