Data sources
Hi all, i thought it might be a good idea to share useful queries that should be reusable for any of us as they are. Although I personally find the built in Workflow-History very useful and really like it for admin-purposes, it might be some kind of an detail-overkill for common users. In order to give users a more simple look of what happened so far in the workflow, I created a datasource that should work for all workflows and translations. Values are shown depending on the users browser la (...)
Hi everyone, does anyone has an idea, why a data source dictionary would not return all data, also "access data in the context of system account" is checked? I was banking my head on the wall, why the form validation stopped working until I noticed that the lastest workflow instances are not returned by the data source. The screenshot shows the data from the "data sources" navigation pane, it's not a field which is filtered. Best regards, Daniel
Hi there, ever since OAuth2 connection was implemented I was happy and thought it would make connecting to Dynamics BC (Saas / Cloud Version) a breeze. However, so far, it was / is not. setting up the OAuth2 app authentication in Azure and webcon is pretty straightforward. - it works like a charm in Postman ( I get my bearer token back) but I have no real way to test it in webcon, so I have to assume it´s working. then you still have to set up the REST Web Service connection, then the (...)
Hello, I tried to import some templates from DEV environment to TEST environment and when I uploaded the .zip archive the following error occured on the .xlsx report: "Value cannot be null. Parameter name: securityProvider" Does anyone know why do we get this error? Thanks!
Hello. Has anybody an idea if and how it is possible to create a data source from two different data connections? I.e. I have a database (MS SQL) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS SQL, too). Now I want to create a datasource for a Choice field, where I could query for names in both tables. It is purely for reading data. Kind regards Klaus
Hi, After updating BPS to version 2022.1.4.111, I can't see the data source columns for dictionary processes. This applies to creating filters. Fixed value lists do not have this problem. What is causing this problem or change in behavior?
Hi all, at the moment we are struggling to generate C## classes automatically based on the SWAGGER JSON Definition of WebCon. (server-adress/api) It seems, that the inheritance could not be solved completely by the library. Our aim is to be able to read data in JSON format from the WebCon REST-API by using standardized tools, means no manually work for getting the data in the right format. Used REST instruction (v3.0) GET: Gets default bps view content Additional Information: - WebC (...)
Are there best practices how interaction with business central (formerly known as MS Dynamics NAV) can take place? What would be the preferred interface? I remember a communication with Webcon where comon data source was mentioned. Where are we here?
Hi all, Yesterday i upgrade Webcon to version 2023.1.3.118 and one things change. In workflow "Faktury" (Invoice) a had an action that download using Rest Api information about working time of employee. Using this data, system fill table with invoice items (eg. cost allocation ). But in this version i get error that: "No exact match was found for:..." ("Nie znaleziono dokładnego dopasowania:...") for attribute Choice field. In previous version this work fine. And there is no pattern in this (...)
Hello all, Does anyone configured a Onedrive connection in Webcon? I'm following the topics: https://community.webcon.com/posts/post/integration-with-aad-using-rest-invoke-method-and-microsoft-graph/117/18 https://community.webcon.com/posts/post/adding-attachments-to-onedrive/183/4 https://community.webcon.com/posts/post/working-with-onedrive-files/341/18 But this is explaining on how to configure using MS Graph and Rest API. However, in the connections area, there's one specific for On (...)
After app migration between enviroments strange error occured which shows up every time existing instance is opened or new instance is started in all apps. Reverting back the previous version of the app did not solve the problem. Designer studio throws the error on clicking every item as well. Restarting server did not help. Has anyone came acress similar issue? Any ideas on how to find the source of the problem? What does the phrase Key: (311, 5116) refer to? Thanks in advance. Designer (...)
Hello All, as of 01.03.2024, Webcon BPS service has stopped downloading current exchange rates from the NBP. Nothing has changed in the configuration (Webcon 2021.1.5). And the server has a connection to the NBP API service. I cannot find any errors in the service logs Do you have the same problem? Is there somewhere a cut-off date until when the rate should be downloaded? Thank you in advance for your help
Hi, Does anyone know how to use the 'Edit a list element' action to update a document element in a SharePoint document library that is in a sub folder in the SharePoint document library? I am trying to use a CAML query and while I can find documents in the root document library, I can't get the CAML to find documents in a sub folder in the document library. I should mention that this appears to be WEBCON specific since the CAML query does return subfolder contents if I use a regular CAML query e (...)
Have any of you implemented or are planning to implement in your company an interface for operating the KSeF (e-invoice) system via WEBCON? Similarly, has anyone successfully visualized an e-invoice according to ministry-defined template (xsd)? This would be a real GameChanger for WEBCON and natural for accounting document workflows. Maybe there are ready-made SDK libraries available or does anyone have an idea how to implement it at the lowest possible cost? https://www.podatki.gov.pl (...)
Hello, I created a few BPS users and I found out that they are saved in BPS_Config instead of BPS_Content. From the Administration tab I activated license for some users, but I have no idea in what table I can see this information. I want to make a calculated column in a dictionary report where I can see witch user has license. So in what table I can find if a BPS user has license or not? Thank you, Best regards!
Hello Community, I want to set form fields based on a dropdown selection which gets its data from a sharepoint list. I can set the value from the selection just fine. However I can only access the data with type ID and Name. The rest of the data has no type and does not show up for any rules I want to configure. How can I address this data in the form? Thanks Oliver
Hi I have a question. I imported a dictionary from Excel from the dictionary process and it duplicated the lines. I would like to upload this data from the beginning. How to delete all dictionary content.
Hi, We recently migrated Webcon to new servers on SharePoint 2019. Apparently, the configuration under Webcon BPS Configuration on each SharePoint site got lost (the database name etc.). 1. Is this behavior expected during migration? 2. Is it possible to set it globally or is it necessary to set it manually on each SharePoint site/subsite? 3. Are there any other such settings that might have gotten lost during migration? Thanks! Mark
Hello, is there any way to connect other data sources (MySQL or Generic-ODBC)? If not, is there a plan to implement this in the future? Thanks in advance Markus
Hi, I have 2 dictionaries: Countries and Cities. In the Cities dictionary, the form field 'country' is a picker field from the Countries dictionary.I would like this field to become a hyperlink which would take me to the Country dictionary instance for that country. I was expecting this to work at least in the Dictionary report Cities but it doesn't. For example when creating the Barcelona city instance in the Cities dictionary I selected Spain as a country. After saving I want to be able to (...)
+48 12 443 13 90