Designing and Running Pipelines

Schedule Task to run every 5 min

Hi Team, I have a scheduled task for every 5 min. What happens if one execution is not completed with in 5 min. I have disabled the option “Do not start a new execution if one is already active”. Will it be in queue? or it will throw any exception. i...

Rollback deletion in case pipeline fails

We want to move data from one DB to another, and first step is to delete all the target data and then do insert. However in case of pipeline failure, we want to rollback to the original data in Target. Currently we are ending up with no data in targe...

Flattening multiple array entities in JSON Object

Hello, I am trying to flatten multiple array attributes from a JSON Document. Below is the JSON document and the expected output. { “TransactionId”: 55499, “ReceiptNo”: 1123, “Location”: “xxxx-xxxxx”, “Total”: 8.08, “TotalGross”: 7.46, “TransactionMe...

toString() is giving unexpected output

A field is coming as a number from source and we want to convert it to string, but the output format is different for some records. Follwoing 4 records have WSH value of 0 but after toString(), out is ‘0’ for 2 records and ‘0.0’ for the other 2

CSV Formatting issue

Hi I am getting json data in attached format from a JOIN Snap when viewed in table, I want to make one CSV out of it but it is taking only headers of the first json object screenshot of which is attached below. JSON form output Table form output Ne...

Implementation of OAuth 1.0

Hey Guys, so we have the following usecase: Talk to third party API that is protected by OAuth 1.0There is no out of the box support for this in Snap , so we need to built that custom logic in the pipeline custom logic is quite complex , and also in...

SAP BAPI Initialization Scenario

Hello. Has anyone else come across a scenario where the SAP BAPI that needs to be executed needs to be initialized first prior to execution? The current SAP Execute snap will only call one BAPI for that processing unit. Below is the scenario we are...

Large volume database updates

Greetings! What is the best way to manage a large number of updates to sql server/oracle? Currently, I have a sql server execute where I have the update statement dynamically written to set only the fields I need to update based on 2-3 conditions in...

SnapLogic - Integration Nation

Forum Posts

Schedule Task to run every 5 min

Rollback deletion in case pipeline fails

Flattening multiple array entities in JSON Object

toString() is giving unexpected output

CSV Formatting issue

Implementation of OAuth 1.0

SAP BAPI Initialization Scenario

Large volume database updates

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

Parsing CSV file

Data Validator Pattern error