Designing and Running Pipelines

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

Time stamp on an end of a file

Hello, I am trying to figure out the time stamp features, and I can’t seem to get it to work. I have on my file writer: “XXXXXXX_” + Date.now() + .txt But that doesn’t work, Can someone inform me on what I need to do to correct this and get this to w...

SnapLogic - Integration Nation

Forum Posts

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

Time stamp on an end of a file

What account should be used for API with query par...

How to dynamically update an account?

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