Designing and Running Pipelines

Excel Formatter - need date datatype with this format MM/DD/YYYY

Im using Excel Formatter. I am selecting from Oracle. I need the column in excel to be date datatype, but have this format MM/DD/YYYY with no time on the end. I can get the date into that format if I do a to_char(mydate, ‘MM/DD/YYYY’) in the select...

File Rename but not able to replace

Hi All, I am facing one issue in one of the scenario. Please Help. I have a source file name in source path Ex: a_b_abc_test_120_7568.xml I want to rename this file in different format Ex: a_babctest_120_7568.xml I have written one code in mapper and...

How to filter json document based on keys present in another object

Hello Experts. i want to filter json object based on keys present in another object of same document. I have one json object which hold key information. As end result we should consider only those values which has key value matching with json object ...

How we can Migrate s3 Bucket folders to Another Bucket

Hi, I have a requirement to create s3 bucket folders from one bucket to another bucket with the same structure.

Resolved! Split hours into back dated days based on total hours

Hello All, I’ve stumbled upon a scenario, where I need to split the JSON object into n number of objects (backdated) if the total hours coming in from the source crosses 24, it should split until the point the total hours have been exhausted. I have ...

MTOM Input Handling in Snaplogic

Hello All, Scenario: We are getting a SOAP MTOM request in which there can be 0 or more attachments and we need to send this request along with the attachments to another SOAP Service using Soap Execute Snap. Currently we are able to retrieve the XML...

Parsing of json object with dynamic attribute keys

Hi, I have a nested json, with the inner most element is an array of struct. The key to identify this inner element is a dyamic value. see the numeric value in the below json. the json parser snap works fine with this, but when it comes to split...

Google sheet account authorization

Hi Team, I have created Googlesheet account but every time it needs to be authorized even if I selected autorefresh. It is working for another account on other server and the only change I see is on OAuth2 Token which is not default but https://www.g...

SnapLogic - Integration Nation

Forum Posts

Excel Formatter - need date datatype with this format MM/DD/YYYY

File Rename but not able to replace

How to filter json document based on keys present in another object

How we can Migrate s3 Bucket folders to Another Bucket

Resolved! Split hours into back dated days based on total hours

MTOM Input Handling in Snaplogic

Parsing of json object with dynamic attribute keys

Google sheet account authorization

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

How can I edit/update my community posts?

Http Client Snap vs REST Post snap