JanosIT
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Getting CLOB data from Oracle into SnapLogic
I'm currently working on integrating data from an Oracle database (containing CLOB fields) with Salesforce using SnapLogic. The CLOB fields are causing difficulties in retrieving and processing the actual text content within SnapLogic pipelines. Currently, the values for CLOB fields are being returned as object references rather than the actual data. I understand that this is due to the way CLOBs are handled, but I'm hoping to find a solution that allows me to access and work with the text within SnapLogic. I'd greatly appreciate any guidance, suggestions, or best practices from the community on how to overcome this CLOB data integration challenge. If you have experience with similar scenarios, please share your insights on the best approach to take. Thank you in advance for your help!1.4KViews0likes0CommentsRe: Slicing Data from JSON
Hi Aleksandar, The expected data structure that gets into the Salesforce Create snap should look like this: [ { "FName__c": "John", "LName__c": "Smith", "Email__c": "john.smith@abc.com", "Phone__c": "1234567890", "Deal__c": "a0P3L000003KTVnUAO" }, { "FName__c": "Jane", "LName__c": "Taylor", "Email__c": "jane.taylor@cba.com", "Phone__c": "0987654321", "Deal__c": "a0P3L000003KTVnUAO" } ] So basically I want to retain the original structure of that particular "Contacts" part of the JSON, to insert it as separate child objects after adding the a new field (the ID of the parent) to each records, but when I use the Mapper snap to replace the keys with Salesforce fields, I get this: [ { "FName__c":["John","Jane"], "LName__c":["Smith","Taylor"], "Email__c":["john.smith@abc.com","jane.taylor@cba.com"], "Phone__c":["1234567890","0987654321"], "Deal__c": "a0P3L000003KTVnUAO" } ]3.4KViews0likes0CommentsSlicing Data from JSON
Hello SnapLogic Community, I'm a Salesforce administrator working with SnapLogic to process data from an Oracle server. My pipeline calls a function that returns a multi-level JSON file. I need to extract data from this JSON and insert it into various Salesforce objects (master record and related child records). Current Approach & Challenges: My current solution involves copying the JSON into multiple pipeline branches. Within each branch, I use JSON Splitter snaps to break the data apart based on each available fields; then I use Join snaps to merge the data. Here's why this isn't ideal: Scalability: This approach becomes unwieldy with a large number of fields, requiring excessive branches. Error Potential: If fields lack values, the Join snap may misalign data during reassembly. Example: Input JSON: { "Contacts": [ { "First Name": "John", "Last Name": "Smith", "Email": "john.smith@abc.com", "Phone": "1234567890" }, { "First Name": "Jane", "Last Name": "Taylor", "Email": "jane.taylor@cba.com", "Phone": "0987654321" } ] } Desired Output (CSV/table Format): First Name,Last Name,Email,Phone John,Smith,john.smith@abc.com,1234567890 Jane,Taylor,jane.taylor@cba.com,0987654321 Goal: I'm looking for a more robust and scalable way to handle this JSON parsing and Salesforce insertion. My main aim is to keep data associated within each record intact without the complex splitting and merging that introduces error risks. Request for Help: Can anyone please suggest alternative solutions or workarounds to achieve my goal? I'd greatly appreciate any ideas that don't require any advanced coding skills. I have been trying to use expressions in a Mapper snap, with no success, and experimented with different snaps but I haven't been able to achieve the expected results (only the splitting/joining worked, but it's not ideal, and I believe there must be an other way, something I haven't tried yet). Thank you in advance for your help and insights!SolvedMerge two tables based on multiple criteria
Hi there, I’ve been trying to find a solution for our use case with no success, so I’d like to ask the Community for help. We have two tables (both from Salesforce), table A contains deal information, table B contains campaign information. Both table A and B have the following fields: Start Date, End Date, Client1, Client2, Area Code, ID I would like to create a new column in in table B, called “DealId”, and copy the ID field from table A, if all of the following criteria are met: Start Date (B) is equal or greater than Start Date (A) and End Date (B) is equal or less than End Date (A) and Client1 (B) = Client1 (A) and Client2 (B) = Client2 (A) and Area Code (A) contains Area Code (B) So far I’ve tried the Mapper Snap and putting all criteria as an expression but it didn’t work. I have been also experimenting with the Join and Conditional snaps, but unfortunately I still haven’t found any solution yet. Right now in my pipeline I have two filtered documents, but cannot find a solution to add the right deal IDs to campaigns. Please help!Solved4.6KViews0likes3Comments