(...) eryone, is someone here how understands power query? I got a task to retrieve data from a BPS report in excel to use it for additional analysis. I was able to retrieve the data but transforming the json response to a table is beyond me. Just in case there's someone who would be able to do it but doesn't know how to retrieve the data I add the logic below which can be put into the advanced editor. Y (...)
(...) I haven't found any documentation how to access the current form data. What I know is, that all the formdata is kept in a json property called liteDate.liteModel as a json -object as you can see when calling /api/nav/db/{dbId}/app/{appId}/element/{wfdid}/desktop I guess that this liteModel must be available via javascript. I'm wondering, because there is this form from the offical 2021 release pap (...)
(...) Hello everyone! Have u stumble upon this error when u make a request through the action and map the body on a field? In the body field as mentioned in the picture should be the body , the json but, is shown the type of collection ( System.Collections.Generic.Dictionary`2[System.String,System.Object] )
(...) m/posts/post/starting-workflow-from-the-sharepoint-document-library/54 I've did all the same configurations as the document to try to get it working but my Start BPS column is not displayed. The json code that is in the post needs to be formatted and my final version (for my case) is: { "$schema": "https://developer.microsoft.com/json -schemas/sp/v2/column-formatting.schema.json ", "elmTyp (...)
(...) subworkflow using MS Flow (now called Power Automate) but when I need to configure the Get Token Action I only have the options in the picture and they are premium. Anyone with ideas? Using the json in the column of the item list is not working. Thank you!
(...) kFlow.Base.BusinessLogic.ElementManagement.FormFields.Choose.ChooseFormField.get_AvailableChooseValues() w WebCon.WorkFlow.Web.UILogic.Form.ViewModels.Data.ChooseViewModel.UpdateFromClient(String json ) w WebCon.WorkFlow.Web.UILogic.WFDynamicLite.Rest.Logic.ElementFormLoader.c__DisplayClass8_0.b__1(BaseFormField field) w System.Linq.DataEnumerable.ForEach[T](IEnumerable`1 _this, Action`1 ac (...)
(...) a rule to color backround of a date cell. The condition would be "if the date in the current field is greater than today, then color backround, else dont change the color". Currently the not working json code is: { "content": "=CurrentField", "style": { "background-color": "=if(CurrentField > today, '#FF0000', '')" } } I've also tried different variants of the condition like "dat (...)
(...) Hi all! I am getting a strange warning when deploying a second SDK plugin package to customer environment (see screenshot). The background information is: Both SDK plugins need System.Text.json namespace for serializing / deserializing json objects, which requires a bunch of satellite assemblies to be packaged also. These assemblies are added to each package with a custom Powershell script an (...)
(...) ng like the article Run an SQL procedure https://community.webcon.com/posts/post/the-run-an-sql-procedure-action/230). But, I would like the procedure to generate a .txt file with the results (e.g. json ), and the file to be downloaded using the WEBCON platform (maybe a new process with starting the procedure and preparing a .txt file for download, such as an attachment). Is it possible, if so how?
(...) history of the instance and scroll down to the attachment link, it opens the file just fine. Is this a known issue? Error during saga execution: Unexpected token 'A', "Attachment"... is not valid json SyntaxError: Unexpected token 'A', "Attachment"... is not valid json at json .parse () at application/App.c6e87d.bundle.js:2:569216 at Generator.throw () at m (/application/App.c6e87d.bundle.js:2:3850 (...)
(...) ations.dll, Version=4.2.0.0, ... The plugin uses the version 4.2.1.0, so I can understand why this fails. But I what don't understand is what artifact requires a 4.2.0.0 version. I searched all .json , .config and .txt files in the directories WEBCON BPS Designer Studio, WEBCON BPS Portal and WEBCON BPS WorkFlow Service The only hits for the filename I got were in the Portal directory. Which is o (...)
(...) n first? I'm asking the question because I'm exploring the possibilities offered by using a service as MailGun. They can parse the incoming email message and post the parsed information in form of json to a URL. The issue I'm having is I can only configure a URL to which the send a POST command with parsed json . There is no way to send the first authorization request to obtain the token and only af (...)
(...) name: 'System.Numerics.Vectors, Version=4.1.3.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' at System.SpanHelpers.SequenceEqual(Byte& first, Byte& second, NUInt length) at System.Text.json .json Serializer.LookupProperty(Object obj, ReadOnlySpan`1 unescapedPropertyName, ReadStack& state, Boolean& useExtensionProperty, Boolean createExtensionProperty) at System.Text.json .Serialization (...)
(...) ection": 0, "dimensions": [ { "id": 0, "type": 0 }, { "id": 0, "type": 0 } ] } ] } When I use 'json grid' I don't know how to add second 'dimensions' When I use 'json ' they don't display list values.
(...) HI, When installing Webcon, the SQL Server compatibility level is set to 120 (default). To use advanced functions like `string_split` and data processing functions from json , it is necessary to manually change the compatibility level to 150. These functions are essential in developing more complex processes. If we manually upgrade the compatibility level from 120 to 150, Webcon will no longer pr (...)
(...) part of the response. There are probably classes used for each so, it probably wouldn't have a real impact on the client. In my case I removed the below default strings which reduced the compressed json length from 424722 (2) to 401807 (4) using a "pretty printed" version this reduced the length from 549913 (3) to 508477 (5) Best regards, Daniel "indicator": false, "percent": false "autocom (...)
(...) in 2023.1.2.44 i get a "Bad request" error when saving the substitution. Attached you find the diagnostics session and develeoper tools log. Any ideas what is going wrong here? // diagnostics json { "session": { "id": 565, "sessionGuid": "2c8664cd-1862-4978-9355-1d0b7c3c47d5", "userTime": "2023-08-31T05:51:09.457", "userLogin": "xxx", "userLanguageCode": "en-US", (...)
(...) I want to use "Invoke rest web service request" action and in response I don't have json but message in Header: Response-Code: Forbidden (403) Response-Body: {"type":"/challenge","title":"Challenge requested","status":403,"detail":"Request to perform challenges described","instance":"fe66c6a2-2cc5-42f9-a4ce-96bea7cd716b"} Response-Header: Date: Thu, 28 Sep 2023 07:06:57 GMT Connection: k (...)
(...) everyone, I am trying to upload an attachment using the REST API. I am using the REST Web service action for this. How to do it correctly? Along with the attachment, I would also like to upload a json with other information. Endpoint is configured correctly, the problem is in the BODY itself. The referenced API is written in python using FastAPI framework. This is response: { "detail": [ (...)
(...) I need to change 2 values with REST, I use'd API v3 and PATCH method. This values is in another workflow. json [ { "data": { "guid": "3567e810-6f44-41e5-9ac3-794d6e055db1", "value": "2024-05-27T14:02:26" }, "wynik": { "guid": "56e078eb-dc11-4960-a662-3974f0f837da", "value": "Ryzyko niskie" } } ] In other workflow history I have only i (...)