Data sources
Hi, Let's assume I'm configuring data from a data source (a report) with one column and one filter. I want to use a User-Defined API that allows me to dynamically filter the report using a defined endpoint. Will the response return a simple JSON with information from this single column, or will it return the entire data set (element ID, signature, step, etc.) as in other responses?
WEBCON works on ver. 2024.1.1.130. We have a few dashboards with created data sources for reports. After data sources, we created reports but using this data sources, not creating new one in Designer studio or in Portal. Now, users gave us information about lack of access to one of the reports which uses data source. Inside configuration of dashboard we have option to change priviliges but if the report base on data source we can't change it on report. dashboards has individual priviliges (...)
Hello. I'm testing new User defined API: I have endpoint for data source. When I tested it manually, it works. But when I tried to do GET via API I got empty response. GET: {{env}}/api/udef/db/1/MTBVENDOR?ComCode=PL12&InvoiceNum=ASDF&InvoiceDate=2025-08-25 RESPONSE: STATUS 200: { "Data": [] } when i check sql query for data source is like this: (([InvoiceNum] = N'ASDF') AND ((CAST([InvoiceDate] AS DATETIME) = '2025-08-25T00:00:00') AND ([ComCode] = N'PL12'))) and i works (...)
Hi, ver. 2025.2.1.91 Is there any changes to CTE SQL availability when used as a Data Source? After the update from version. 2025.2.1.42 to 2025.2.1.91 we found that all functions using CTE from Data Sources stopped working. Strange - when you use CTE in the action config, it still works. Can you confirm whether it is a bug or not ? Error: Error in On path action Wgrywa nadgodziny (zrodlo danych). (Step: Rozliczenie nadgodzin, path: Pobierz nadgodziny) Error getting data for (...)
Hi, we would like to pick a group in a form field and to use all members of this group as filter for another user picker field. Using the function GROUP MEMBERS [AD-Group Login and name] in a business rule works fine. Setting this one into an ALERT all members are returned as expected. Using 'testgroup' as string in the group picker of the function GROUP MEMBERS ['testgroup'] in a filter of a data source works fine and all members are returned as expected. But using the AD-Group field (...)
hey, so i got a question about updating related fields in two separate reports. We have report with names of the people and other report which has all of those people in a field person. Now, if i change first name or last name in the first report, to also update itself in the latter report.
Hello, I would like to create a new data source in the MSSQL Database category that would retrieve information from a list of values from the form and other attributes on the same form, but I don't know what such a correct query should look like. Currently, my query is only able to retrieve information from the attributes themselves, but not from the list of values. Edit: I found the solution.
Hi all, is it possible to use another smtp-server besides echange-server? i.e. zimbra or kopano?
I want to use a REST DataSource to get customer information (ie name) via customer number. I have a form with a customer number field. I have a REST DataSource "REST GET CUSTOMER DATA" (..../getKundenData?customernumber=CUSTOMERNUMBER.Standard) which returns a json with all relevant customer data. I used a business rule to get the value from the REST datasource and a form rule (on value change) to set the customer name (returned from the businessrule). This is working fine. The problem (...)
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.
+48 12 443 13 90