Data sources

Data Source REST Web Service Connection (Basic / Token Authentication)

0 2

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

How to find all local groups in WEBCON via database sql

0 2

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.

Unable to connect to Sharepoint Online

0 2

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

Initializing a list of items with attachments from the parent workflow

0 2

How can I initialize attachments on the item list in the subworkflow? The initializing query retrieves text fields, but does not retrieve attachments. I receive an error message: Validation Error, SubElems (ID: 9031) Attachment not found. SubElems (ID: 9031) Attachment not found.

SearchIndex source for calendar - issue with timezone

0 2

Dear Community, I just discovered that when I select SearchIndex as a source for calendar type report, elements are in different timezone than server time. When I change source to SQL source everything is fine. Does anyone experience same issue? Best.

Errors when using <Current BPS Connection>

0 2

After upgrade to version 2022.1.4.174 I get errors on some querries that use <Current BPS Connection>. Error occurs when querying another database directly or using join, etc from SQL COMMAND or choose field querry. I found that this is related to change described in https://community.webcon.com/download/changelog/117?q=cf05b90, associated with using bps_user on SQL COMMANDS. Is there any way to deal with it at SQL server level by proper configuration or should I change <Current BPS Connecti (...)

Querying with SOLR

0 2

Hello, is there a possibility to use existing SOLR as Data Source? I had an idea to show users SQL grid, which would show similar items found in database, based on text typed in regular TextInput field. That lead me to Levenshtein Distance algorithm, which might be slow in SQL, but i've found that such a thing is already implemented in SOLR (https://stackoverflow.com/questions/1752301/how-to-configure-solr-to-use-levenshtein-approximate-string-matching). Also, any ideas how to implement i (...)

Active Directory department query as datasource

0 2

Hi. Is there a way to query the Active Directory only for the department column and add this as a datasource. What I'm seaking is a list of all departments we have in the company. Kind regards Klaus

HELP / ADVICE NEEDED / Connection webcon -> OAuth -> Dynamics Business Central

2 2

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

Problem with data source (choice field returns no data for some user)

0 2

Hi, I have some problem with privilages. I have the choice field which is sourcing by BPS Internal view. One of user don't see the data in this field (she see field but data source is empty for her). I checked already if there is some space sign or any other which limited the search result. She has privilages to application, form, on choice field there is no limit. I've seen everything because I have an admin privilages but even if I revoke permission (to replicate the problem) I stil (...)

Problem with connect external database

0 2

Hi, I add new connection (MSSQL database) - test it with success. Next I add new data source with some SQL query which returns some data when I test it. If I save that connection Webcon shows the error: "Failed to retrive column from data source XXX. No connection settings." If I want to test that data source in choice form field I've returned: Nieznany błąd: The ConnectionString property has not been initialized.. Does anyone have some idea what I should do to fix it? Than you (...)

Stored Procedure as Datasource

0 2

Hello. Is there a way to use a stored procedure as datasource instead of a view or table or Select statement? I use at the moment a query on two tables (UNION) which has an inner join on another table. The speed is not really breathtaking, thus I wanted to use a stored procedure where I can perform all the timetaking steps already on the SQL server. Regards Klaus

Add Item List for Sharepoint Calendar

0 2

Hello all, Does anyone set up an action to add items in a Sharepoint Calendar? I'm using this https://howto.webcon.com/sharepoint-calendar-adding-entries-from-bps-workflows/ to help in the configurations and I'm able to send the information to Sharepoint: Message Log for my Action Message Address of a Sharepoint list: https://visionboxdomain.sharepoint.com/sites/customers/Lists/Calendar Inserting values: Title: Renovation Doc, Location: PT, EventDate: 3/12/2021 12:00 AM, EndDate: 3/14/ (...)

Problem with using WEBOCN with external SQL in Master Data Management

0 2

We are implementing a solution of Master Data Management and are trying to use Webcon as a User interface with all the logic behind forms. The database is prepared in MS SQL with different tables. The challenge we are having is to update entries with foreing keys. Scenario: Table 1: Country has one column (apart from ID) – 'Country' Table 2: City has two columns 'Country ID' (Choice column from table Country) and 'City' So in City table, we have one foreign key that shows on Country table. (...)

Set up Onedrive connection

0 1

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

KSeF [Polish Gov. e-Invoice Program]

0 1

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

Active BPS Users

0 1

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!

Filter by date does not work

0 1

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"

Connection to SharePoint

0 1

Hello everyone, I need your help with a task that should actually be relatively simple. I'm trying to establish a connection to my Site Collection in SharePoint and have entered the relevant data (Server and Site Collection, User, ...). When I click on "test", it loads for several seconds, and I get the error: Unable to connect to the remote server. Regarding my rights in SharePoint: I am the owner of the Site Collection. What could be the cause of this? Thanks in advance!

Non-working days vs Country

0 1

Hello all, Does anyone knows or have configured something that can relate the country vs national holidays in the country? Like having the calendars for Portugal Holidays, Spain, etc I know that we have to manually insert the holidays in the System configuration for calendar's table but in this case, the idea is, if I'm abroad and inserting extra hours, by defining where I am, the system could check if it's an holiday or not. Thanks!