Data sources
Hey I have two choice fields Product Group and Product Category (groups are within the categories) so I have created filter that when somebody selects certain category they can only see in choice field product group, groups that are within the specified product category based on dictionary. However now is coming the problem that sometimes business would like to select two or more categories and when they do so the product group is empty. Is there a smart solution for that? Maybe in case of s (...)
I need to fetch all available rows for specific picker. I have used api endpoint /api/data/v6.0/db/{dbId}/elements/resolveFieldValue/{idguid} The api return only first 100 rows It is possible use pagination or sth like that ?
I have a problem to establish a connection to sharepoint online. I have chosen as connection type sharepoint online. When I enter the Url of the sitecollection and the user and password correctly, I get the Error message: "Unable to connect to the remote Server. The sign-in name or password does not match one in the Microsoft account system." As the account that I use to connect has not MFA enabled the reason for the error must be, that webcon uses legacy authentication, which is not allowed o (...)
Hi all! We would like to add a datasource from REST API. Datasource method is POST, since we have many parameters. We need this datasource in different workflows and parameters are dependent on values entered in current form (different fields in different workflows) and also should be fetched from database from another workflow. As I can see there is no way to use current form field values (in JSON mode, not JSON grid) in request body of datasource consuming a REST API. Is there a (...)
Dear Community, I'm trying to connect with REST API to SAP API. According to SAP API documentation this should look like this: POST https://localhost:50000/b1s/v1/Login { "CompanyDB": "SBODEMOUS", "Password": "1234", "UserName": "manager" } In response I receive receive 2 HTTP Cookie items (B1SESSION and ROUTEID) that I have to submit with every REST API call to SAP API. The problem is that I can't submit JSON configuration in REST API Connections area in WEBCON BP (...)
How to access values of the 'datasources'? -> The query only returns the ID of the datasource.
Hey, have anyone succesfully configured LDAP as source for users? * https://docs.webcon.com/docs/2023R3/Studio/SystemSettings/GlobalParams/UserSynch/SynchConfig/LDAP I'm trying to make it work, but all entities (users, and groups) are being synchronized as groups. From the error log it seems like Webcon is generating LDAP query with an error - the OR - | - operator seems to be in wrong place: - (8/12/2024 8:29:33 PM) Searching LDAP://ldap-server:389/DC=ldap,DC=goauthentik,DC=io?uid,gi (...)
Hello! is there a best practice how to transfer data from an external data source (eg. sql server) into a dictionary in webcon (and webcon in general)? I heard something about a technical path?
Hi, I am currently working on some tool management workflow in WEBCON and I have a problem. I have an items list with REST API as data source where user can pick and book tools for some time period. Time period property is not included in REST API so I'm using form fields for booking dates. Then I need to filter the items list using tools from REST API and dates from WEBCON database to exclude unavailable tools. Unfortunately i didn't find the way to do it using the REST API filter available in (...)
Hi, I have a choice field with SQL data source connected to it. Is it possible to create a link (into the choice field) to a selected element like as in the case of BPS Internal view? Simplify, I need the same option as in the selected screenshot but for the sql data source.
Hello all, I have a data table field where I'm selecting the fields using a SQL query. One of the field is a picker and I want to show just the Text and not the ID. I've tried many options but as soon as I try using the Database-Name, it's giving errors. I believe it's because the option has space on it : 'Non Ok'. But the system should overcome this right? Even using the DBO function, it doesn't work. Adding quotes is not allowed. I'm running out of ideas. Did this happened to any of y (...)
Dzień dobry Mam problem z wykonywaniem akcji globalnej, która ma za zadanie startowanie obiegu sql. W zapytaniu zastosowane jest open query do serwera oracle. Przy teście zapytania lub puszczeniu akcji globalnej dostaje błąd z załącznika. W management studio zapytanie jest wykonywane normalnie Proszę o sugestię Wersja Webcona 2022.1.4
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 (...)
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!
+48 12 443 13 90