lazo_ilijoski
New Contributor III
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Data reconciliation solutions?
Hi feenst, Different data replication strategies can be implemented based on business requirements, whether the need is for real-time, near-real-time, or scheduled synchronization. For scheduled data replication, SnapLogic provides a straightforward solution using the Salesforce Snappack. Data can be retrieved from any Salesforce object by retrieving data based on LastModifiedDate (or SystemModstamp) field. At the end of each sync cycle, the most recent timestamp can be stored and used in the next cycle to fetch only those records that have been modified since the last successful run. For real-time or near-real-time replication, in addition to the Change Data Capture (CDC) feature, there can be used Outbound Messages in Salesforce. Outbound Messages can be configured to trigger SnapLogic tasks. In this case, Ultra Tasks are ideal for real-time processing due to their low-latency response time and built-in retry capabilities. Similarly, HTTP Callouts from Salesforce can also be used to invoke SnapLogic tasks, typically implemented via @future methods or queueable Apex classes to ensure proper bulkification and asynchronous execution. We’ve successfully implemented these approaches multiple times and found them to be reliable and scalable. If this aligns with your needs, I’d be happy to set up a call to walk through the different architecture options for replicating Salesforce data using SnapLogic. Best regards, Lazo.257Views1like1CommentRe: Using the parsed Float value in string
Maybe initially I didn’t understand well your issue. You can use the following statement with regex: "Input Value “+ ((parseInt($NTGEW) == parseFloat($NTGEW)) ? parseInt($NTGEW).toString() : (parseFloat($NTGEW).toString()+“0”).match(”(.*d?[1-9])0+$")[1])* So, I did tests with few cases and got the following result: And here is updated pipeline: floatIssue_2020_10_08_v2.slp (5.2 KB) Please let me know if this version works as expected. /Lazo5KViews5likes1CommentRe: Ultra Tasks takes more time to execute at each interval
Hi @hirakangshu.nag, There is possible another approach. Instead of having ultra pipeline, you can simple have one pipeline that starts with File Poller snap. Once the pipeline is started it will run indefinitely if pooling timeout is set to -1. So, in the dashboard you will see only one process that will run continuously If you check Only Output On Change there will be output documents from File Poller only if the content of the given location is changed. Polling interval in seconds allows you to specify on what period the file poller should check the location for changes (i.e. 10 seconds in your example). Below is a screen shot of one test pipeline: I hope this will help you in your case. Let me know if you need further help on this. 👌 /Lazo2.2KViews4likes0CommentsRe: Snaps execution in pipeline
Hi @Siva_Venna, Probably order of execution of the unconnected snaps/streams depends on the order of creation of the starting snaps in the pipeline. Since, the order of the executions cannot be guaranteed and if you want to guarantee the order of executions, then I suggest all snaps to be connected by using copy/router or any other appropriate snap. Regards, Lazo2.6KViews2likes1CommentRe: Rest Post with attachment and form data
Hi @manohar, You can use REST POST snap in which you can set header parameters in HTTP header section: If you want to attach a file to POST service, you have to upload the file in SLDB at first and then you can specify the file in Single file upload: File, as well as the name you want to be used, for instance: manohar: -F ‘attachment[intent]=Supplier’ Don’t forget to remove the file (by using File Delete snap) after you call the rest service. BR, Lazo2.1KViews3likes1CommentRe: Create XML file for Card Transactions from Database Query
Unfortunately I don’t have any good example, but hopefully you can find useful tips & tricks at the following links: An XML Generator & XML Formatter Snaps example SnapLogic Tips and Tricks: The XML Generator Snap (Part 1) | SnapLogic https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439280/XML+Generator BR, Lazo2.9KViews4likes0Comments
Groups
Partner User Group
This area is for our partners to communicate with each other and with the SnapLogic Alliances team.0 Posts
