Designing and Running Pipelines

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

Milliseconds to Date

Hi , I want to convert Milliseconds to Date. For instance If I give 1540456849550 then it should give me the date like Thu 25 October 2018 14:10:49 Thanks, Gaurav Sandil

SnapLogic - Integration Nation

Forum Posts

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

Milliseconds to Date

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data

Parsing XML using a Python script returns an encod...

multiple array objects

String replace method where pattern is dynamic

Send Multiple HTML Tables in Email using XML Parse...

Email Sender Snap - Send data as HTML Table

Creating a pipeline involving user interaction in ...

How to add an object into an array