Preview not available for Flow snaps
Certain flow snaps like “Filter”, “Head”, “Tail” when used in a complex pipeline doesn’t generate a preview while validating the entire pipeline however these generate a preview if the pipeline is simple. For instance, if I’m trying to read data from an excel file with 100k+ records and use either ‘filter’ or ‘head/tail’, I can see the preview when the pipeline has been validated but it doesn’t generate one when the pipeline is huge. Any specific reason behind this? I would want to see the preview as the pipeline that I’m currently developing is a complex one (multiple snaps prior to “flow” snaps), thereafter it needs a ‘filter + head/tail’ (i.e. flow snaps) and then it will again require a bunch of other snaps after those ‘filter + head/tail’ making it complex again. Help on this matter would be highly appreciated. Regards, DarshSolved31KViews0likes13CommentsIssue with Arrays in Downstream Mappers after a Custom Snap Transformation
We built a custom snap that performs a transformation. You will notice in the output of the custom snap in the screenshot below that “medicalEnrollment” is a json array. In a downstream mapper, we attempted a transformation on this array. We have tried (1) using the sl.ensureArray() method and (2) another downstream mapper performing a transformation in the array. However, we notice that in both the #1 and #2 attempts the mappers do not detect the array, thus causing issues with the transformation. Below is a snippet of the preview of what we expect vs actual preview. We also notice that chaining a Json Formatter and a Json Parser right after the custom snap does indeed makes the mappers work correctly. Pattern shown below: So my question is, is there something hidden in the JSON parser snap that allows strong typing of the array that we are missing? Anything in between? @robin , Tagging you since I was told you might be able to help out. Thanks!Solved9.5KViews0likes20CommentsHead/Tail snap dynamically setting Offset value
Hello, I am working on loading data from big excel file into a database. I want to use Head/Tail snaps to dynamically take “Documents offset*” from upstream. Please suggest if there is an alternative to this approach. Thanks, Mithila6.2KViews0likes6CommentsConcatenate strings in Mapper snap
I want to utilize the functionality of mapper snap to prefix my value with a static string, then concatenate with other variables and again concatenate with a static string. I’m able to do the concatenation part however I cannot prefix the string. Any suggestions please? Thanking you in advance for your time.Solved6KViews0likes4CommentsMongoDB Update Query Expression
I have a child pipeline, which contains a MongoDB Update Snap, and I am trying to have the Update Query be an expression so I can take into account parameters passed down to the child pipeline. The documents in the MongoDB Collection I am targeting, have a unique index on a field named “runId”, and so I am trying to match on this, and where found update another value in the document “documentsExpected”, again from another parameter. Below is what I tried as my expression, but it is choking. Is what I am attempting possible? If so, where am I going wrong with the expression? “{ _runId:” + _parentRunId + “}, { $set: { documentsExpected:” + _documentCount + " } }"5.6KViews0likes8CommentsDifference between HTTP Client and Rest Api(get,post....) snaps
Hi All, I am exploring the HTTP Client snap, I wanted to know what is difference between HTTP Client and Rest API methods (get,post…) snaps. Can any one please help to know about the below highlighted Entity Type in the snip. and also can we get the output as xml from the HTTP Client snap ? if yes, how? Thanks in advance @dmiller can you please help me5.4KViews0likes4CommentsSort snap's functionality
Results of a sort snap (ascending) is a little bit hard to digest. I used a file reader which was reading a single column A (i.e. IDs) and I decided to sort it. The results I get are surprising. Input raw data: 1217 151983 1543 370904 402 402783 901602 373 373916 374 120651 1216 1000022 1000027 394533 906 909 1000019 918 1205 Output after sort: 1000019 1000022 1000027 1205 120651 1216 1217 151983 1543 370904 373 373916 374 394533 402 402783 901602 906 909 918 Result expected: 373 374 402 906 909 918 1205 1216 1217 1543 120651 151983 370904 373916 394533 402783 901602 1000019 1000022 1000027 Can anyone explain what’s the rationale behind the results I got using the sort snap? It’s confusing for me to be honest. Thanking you in advance for your time, help and response. Regards, DarshSolved5.1KViews0likes8CommentsMerge 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