How to render distinct elements only in an array with duplicates
I have a JSON document that has inside an array with duplicate values such as [1,1,3,3,6,1,2,1,2,100]. I am trying to transform/map it from source into target by returning only the distinct values such as [1,3,6,100]. How can I achieve that using a Mapper snap or if any other snap. For example when using jsonPath() function to specify a part of JSON document that has an array, is there a function similar to .unique() that could be attached to return only unique array elements? The Unique snap works only on entire documents/rows not array elements within a document.Salesforce Outbound Message Notification
A key feature in Salesforce is the ability to send outbound notifications upon changes to assets - such as Accounts, Contacts, Leads, etc. This can be useful for real-time integrations with external systems. To implement this feature, as a prerequisite, you should already have a Salesforce Developer account. This can be obtained for free. Also note that only new and modified records can be sent outbound. Deletions cannot be captured. Attached is a sample pipeline that receives an outbound message from Salesforce and sends a response back. Outbound Message Integration_2017_02_28.slp (6.5 KB)Aggregate Snap example
This is an example to illustrate the Aggregate Snap with Functions like Sum, Count, Min, Max and Average. The 1st Snap generates the required input data like Name, Age, Dept, etc. The next Snap “Aggregate” is configured with functions like Sum of Age for Total Age Count of Name (Unique column) for Total employee Min of Age for Minimum Age Max of Age for Maxiumum Age Avg of Age for Average Age Below is the quick screen shot of the configuration of the functions of this Snap. Attached is the .slp for the pipeline reference of this example.Aggregate_2017_03_11.slp (6.0 KB)An XML Generator & XML Formatter Snaps example
Here’s an example illustrating the use case of the snaps XML Generator, XML formatter and File writer. The 1st snap “XML Generator” of the pipeline generates a document format data with the given xml input configured in the snap on “Edit XML *” in snap settings. The 2nd snap “XML Formatter” accepts the document format and encapsulates the data into XML formates and provides the the binary output which can be an input to the File writer snap which accepts the binary input. Attached is the .slp for pipeline reference.XMLGenerator_Formatter_2017_03_1.slp (4.1 KB)Converting a JSON list to an Array
How to convert Json list to Array It’s very simple to covert JSON list to Array in SnapLogic. Simply drag and drop the Snap “Json Splitter” and connect to any document format snap whose downstream is a JSON list like in the attached example, select the Json path and the output that you’ll recieve at the downstream of the JSON splitter will be an array. JSON_Splitter_2017_02_18.slp (2.9 KB)