Designing and Running Pipelines

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

Resolved! Is there a way to generate Excel files and not write them to disk?

I have and Excel Formatter and a Rest Post Snap. I want to send the Excel File in the Rest Post Snap. Why do I have to write the Excel file to disk first? Can I create the Excel file in memory and pass that to the Rest Post Snap somehow without go...

How to log the rejected records while migrating the data

Hi , We have migrated the data from DB2 to MySQL AWS cloud. For 1 table there were duplicaate records in DB2 as there were no primary keys or index keys deifned. But we have set composite keys in cloud DB. While migrating the duplicate records were ...

Bidirectional data sync (Two way data Sync between the databases)

Hi , we are migrating applications from DB2 to Azure SQL. I have a situation where I need to sync tables data in both ways DB2 to Azure SQL and AZure SQL to DB2. The tables doesnt have any timestamp fields (created or updated). Is there anyway we cou...

Resolved! URL Pagination, but it's buried within the string

This article is very similar to my question. I’m in a bit of a different boat though. My pagination is buried as a string within a string within the headers - not entity. I am able to parse with something like $headers.link.split(“;”)[1] but this se...

SnapLogic - Integration Nation

Forum Posts

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

Resolved! Is there a way to generate Excel files and not write them to disk?

How to log the rejected records while migrating the data

Bidirectional data sync (Two way data Sync between the databases)

Resolved! URL Pagination, but it's buried within the string

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

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