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, DarshSolved31KViews0likes13CommentsResumable & Error Pipeline
Whether Below Answers are Correct We can resume a pipeline in suspended state using the Activity API - True A pipeline can be in suspended state for a maximum of one week - False A pipeline can utilize an error pipeline or the resumable pipeline feature, but not both. - False1.8KViews0likes0CommentsError create Teams OAuth2 User Account
trying to create a connection to teams using the Teams OAuth2 User Account so we can send a message to a channel, we can create a Teams OAuth2 Application Account which connects but struggling to get the User one set up. under “Auth endpoint config” section we have added but when i try to auth we get the following: if i change the value to a scope we have ceated in AAD when i click on the Authorize button a new tab opens you see the azure auth screen before it redirects with and error and closes… what are we meant to put in the the Auth endpoint section to get this to work??? thanks2.2KViews0likes2CommentsDifference 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.4KViews0likes4CommentsJSOn body for property with null value
Hi all, I’m having an issue while designing the mapping property with null value for my JSON object. For example I have a Mapper to map $input to $body with the expression like follow: {“my_id”: $input.Id, “my_name”: $input.Name, “my_address”: $input.Address }. When the $input is {“Id”: 123,“Name”: null, “Address”: “A Street, B District, C City”}, the $body should be: {“my_id”: 123, “my_name”: null, “my_address”: “A Street, B District, C City” }. But when the $input is {“Id”: 123, “Address”: “A Street, B District, C City”}, the $body should be: {“my_id”: $input.Id, “my_address”: $input.Address }. I tried with hasOwnProperty() and hasPath(), but they all treats the null value as not existing property, so it will not work. Does anyone know how can I keep the null value for mapping, but eliminate property that does not exist in the $input. Thank you in advanced. best regards.2.9KViews0likes3CommentsJMS Consumer vs AWS SQS Consumer
In JMS Consumer , we have a setting named “Message Acknowledge Mode*” which we set it as ClientACknowledge or dupsAcknowledge Comparing it with AWS SQS Snap , it does not have any acknowledge mode. In our prod environment, we have JMS consumer where client acknowledge is enabled. Now if i have to replace it with AWS SQS snap , how can i achieve the same configuration as JMS ?Solved3KViews0likes1CommentConcatenate 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.Solved6KViews0likes4CommentsSort 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.1KViews0likes8CommentsInserting additional columns with Null values
How can we add additional columns with Null values using a mapper snap? Rationale behind this question: I’m trying to use a Join snap wherein Input 1 has 1 column and Input 2 has 50+ columns, after reading the documentation, the best practice suggests that both the inputs should have consistency else the output would be some unexpected data. While using mapper snap, I tried adding additional columns but it gives me an error saying that it couldn’t find the column_name (that I’ve added), how do I resolve this error? Thank you in advance for your help 🙂Solved3.3KViews1like3CommentsConnecting to Azure SQL Database
I am trying to connect to our Azure database from our Ground Plex using the Snap Azure SQL - Execute. Here is the error I get. I use the same connection from SQL Server Mgt Studio and it works fine. Failed to create a database connection. The TCP/IP connection to the host peasql-1297393639.database.windows.net, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall. Any suggestions would be appreciated. Guy2.4KViews0likes1Comment