Designing and Running Pipelines

Need to join the input array of objects to string

Hi The json input I get to the pipeline is array of objects. I need iterate each object data and join as a string. Also I need to append some html code in between. Ex: input json “chathist”: [{ “created_by”: “test”, “created_date”: 1626244986151, “in...

Formatting an XML Output

After a REST POST execute, my response comes as: I want to remove the part which is enclosed in <>. The output file is in CSV format and should capture data after “CDATA[” and ends at “]]”.

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

SnapLogic - Integration Nation

Forum Posts

Need to join the input array of objects to string

Formatting an XML Output

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

Create a date range by hour

SOAP execute snap vs REST post/Http client snap

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's