WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Data sources

Data sources

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 (...)

How to display data from another database (added as an MSSQL data source) in a report? How to do this in a new report? Or maybe it could be added to another process report

Hello all, We have implemented a new ticket system called Jitbit and I would like to connect it to WEBCON via REST web service. Unfortunately, I don't understand how to configure a "Basic authentication" or "Token authentication" in WEBCON. Using Postman, the authentication including the queries already worked. Enclosed you can find the documentation from Jitbit: https://www.jitbit.com/helpdesk/helpdesk-api/#/?id=helpdesk-api Could you please help me with the configuration? Many than (...)

hello, I need to migrate local groups from production to dev environment, do you know database table or do you have sql that will show me all local grups, even empty one ? thanks in advance.

Hi, how to set a filter in the data source for a data table so that search-filtering by date works. The usual filtering according to the scheme does not work: 1. "some date (iso or browser settings)" = "field in the data table with a date" (like attachment) 2. "some date (iso or browser settings)" like "field in the data table with a date"

Hi everyone, I tried to connect to one of our sharepoint online sites. For some reason, I get a message that the login or username is not correct. (see screenshot) If I use the same login data for our on-prem Sharepoint 2013, it works fine. (see screenshot) On the Sharepoint online site which I want to connect, I am logged in with my valid credentials and I am both in the member and the owner group. (see screenshots) Our on-prem AD is fully synchronised with MS Entra ID (formerly Azur (...)

Hi, Sorry for my lack of knowledge but I've just installed WEBCON 2 days ago. Please help! I want to add in a item list rows from a SQL database but: Querying data is ok. I want to select a product name based on that query (from a Choice field) and get the correspondent price from the query... Also my query is based on another field as a filter When I change the value of that filter, the list of products should change but it doesn't. And also, I can't get the price for the product... (...)

Hello, Does anyone has a rest api configured to access Sales Force? I have a connection and I use it in a process but I'm getting the data from Opportunities. I would like to bring in a specific report. I've checked how to do this and I came up with this query using the GET /services/data/v52.0/analytics/reportTypes/Opportunity But when I use the field as a Data table in order to check the information, the list comes empty. Anyone tried this? Do you know how to bring reports instead of (...)

MVP

Hi, We have an issue related to the usage of columns from a datasource (dictionary, BPS internal view) within a choicefield-type field. The user 'windows user' has created a new application, a new process, and a new dictionary. After configuring these, the user created the corresponding datasources for them. They created a new process where they associated the dictionary/process with choicefield-type fields. For data filtering, they used the fields from the datasources as filters. An (...)