Data sources

[Solved] Dictionary data source does not return all data

2 3

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

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

Local AD sync filter out disabled accounts

0 3

I am attempting to control the AD sync on two different domains. How do I filter out the disabled accounts on the domains? There are users with the same names on both domains, is it possible to have the unique identifier the BPS ID as opposed to the Name so that users with the same name can by synced as 2 different accounts?

SHAREPOINT LIST - DELETE ITEM - FILTER BY COLUMN OTHER THAN ID

0 4

Dear Forum I am trying to remove SharePoint list items in one of actions. It works well when I pass a sharepoint item ID, but I do not have this available in webcon. I would like to delete an item based on other column that I have. I tried CAML query below, but it does not work. Tried different columns, tried "" and '', tried contains but it does not work. Any ideas how to do it properly? <Where> <Eq> <FieldRef Name="Project Code"/> <Value Type="Text">3153</Va (...)

Data source filter issue (dictionary process)

1 9

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?

REST - API usage: Problems with automated class generation in order to read JSON data

1 1

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

Adding new values to the source using Picker field.

0 0

Hi, Is there any tutorial about adding new values to the source using picker field? I have seen that there is that option but I have a problem with configuration of link to the object adding form.

Data sources Rest Web Service

0 1

Hi, I want used the global business rule in a rest web services. I try use de business rule in Customer Headers, but when I run the action the value it's empty. I added an image with the configuration. (config_restWebServices.png) Is it possible using the business rule in Data sources Rest Web Services? Thank you, Raluca

Sales Force and Webcon interaction

0 3

Hi all, Hope you're doing great! Does anyone have SF connected to your Webcon? I was wondering if there is any possibility to have more interaction between the 2 apps. At the moment, I have Webcon connected with SF through REST APi, where I get information from SF for a process. But sometimes SF is updated (for example, an opportunity is cancelled), and there is no reflection of that in Webcon. My idea was to have that information and automatically cancel processes that were connecte (...)

Microsoft Graph: How to get auth token?

0 3

Hi there, this is regarding Microsoft Graph. I'm trying to get a Bearer token but I always get an error message when loading stating: "error":"invalid_request","error_description":"AADSTS900144: The request body must contain the following parameter: 'grant_type' I attached a couple of screenshots of the configuraiton. And here's the full error message: Request Start Request-Url: https://login.microsoftonline.com/[I SANITIZED IT]/oauth2/v2.0/token Request-Header: Scope: https:// (...)

Check VAT Status [Poland] error

0 4

Dear Community, from last Friday (29th of July) I experience issues with SOAP Web Service at https://sprawdz-status-vat.mf.gov.pl that checks if Supplier is active VAT payer. Does anyone have same issue? Should we consider "migrating" to https://wl-api.mf.gov.pl REST Web Service, where we can check VAT status also? What about limitations of wl-api service? Thanks in advance for any response here. Best, Adam Hatak

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

SQL Report

0 1

Hi. I have a big SQL from 3-4 apps. Is the possibility to generate report from my SQL data source ?

Datasource containing HTML elements

0 1

Hi community! In some scenarios it is necessary for us to render datatables on form containing some custom links or buttons. For this reason we built following SQL statement for testing purposes: SELECT 'Internal' AS ID, '<input type="checkbox">Click me</input>' AS HTML UNION SELECT 'Azure' AS ID, '<a href="https://somedomain.com" onclick="alert(''hello'')">Link</a>' AS HTML And we used this datasource in a datatable field on form. However, we have some interesting results. (...)

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

Sql query with a where clause comparing an Oracle date to a Webcon date.

0 1

Hi, I have a following problem. I've created a data table form field that downloads data from SQL query. In that SQL query I have a following where clause, which compares a date from Oracle table to a date from a form field that is completed by an user (it is "user's date"): "where table1.date = User's date: date acc. browser settings(text)" and it doesn't work because of different date formats. I've tried multiple methods and nothing worked. Do you know any solution? However, the fo (...)

Didtionary order - sort

0 1

Is it possible to sort by the selected column (additional column, e.g. priority) in the dictionary selection field? Or to arrange your own order?