WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for datasource

(...) Hi all! I am new to WebCon BPS. I wonder if it is possible to get all items of a process or a datasource /dictionary defined in BPS from client side via REST API. In SharePoint I did something like this: _api/web/lists/getbytitle('MyList')/items?select=Title... This does not seem to be possible with BPS REST API or at least I did not find it ;-) I am thankful for every hint pushing me into the right di (...)

(...) When adding or updating elements via Rest Api, for picker fields it is required to provide Id and name. Quite often the name is known, but not the id. As picker fields are usually based on datasource s, it would by great, when the api would be extended with methods to query datasource s. There should be at least two methods: 1) getting a list of all available datasource s (overall / by application) 2) quer (...)

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

(...) or buttons. For this reason we built following SQL statement for testing purposes: SELECT 'Internal' AS ID, 'Click me' AS HTML UNION SELECT 'Azure' AS ID, 'Link' AS HTML And we used this datasource in a datatable field on form. However, we have some interesting results. First row is rendered as text (with esacaped html entitities < ...), the second row is rendered as HTML, also the cl (...)

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

(...) Hello all, Does anyone configured an action where the value in a specific column for an item list is a value coming from a datasource different than MS sql server? My idea is, I need to get from an oracle table the rate for a specific employee, so I'm using the action with datasource = my table and in the advanced filter, I just add the person id and the dates for comparison but this is not working. (...)

Hi, it would be great if the response tab of a data source would have an additional option to download the defined response structure so that it could be uploaded. This would be even better, when the internal names would be part of the download. There are cases when you need to change the internal names and doing this again and again for the superior source and x business entity sources is anno

(...) 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 datasource s for them. They created a new process where they associated the dictionary/process with choicefield-type (...)

(...) Hi all! I am currently struggling with 'Add privileges' action. I want to use a predefined datasource (SQL query based on WFElements), this is shown under (1) in attached picture. The datasource I am using selects all elements from a specific formtype and needs additional filtering in SQL query window (2). But I am unable to do that, every attempt so far resulted in syntax error. I am sure th (...)

(...) specified user IDs to a technical field WebCon.WorkFlow.Extensions.GDPR.Actions.SaveIdsToTechnicalField Custom source – collecting personal data WebCon.WorkFlow.Extensions.GDPR.datasource s.DictionaryDataReportdatasource Custom source – personal data usage WebCon.WorkFlow.Extensions.GDPR.datasource s.ElementsGriddatasource Custom source – external person (...)

(...) look at the possibilities of the template syntax and become a big fan of it as I did. Beginning of this year, we did a PoC and the first version of an SDK action. We decided to use JSON as a datasource , as in our opinion it offers the most versatile usage.  For most users, more complex JSON structures, e.g. with one-to-many relations, will be a challenging task. So we decided to add a (...)

(...) Currently, views do not allow dynamic filtering on views for datetime and people-picker fields. It can be done by extending the query in the datasource . The datasource can only be changed by administrators and designers. For end-users it would by great having the possibility to use placeholders for filtering datetime and people-picker fields. My idea is having placeholders like [now] / [today], which wou (...)

(...) ul and really like it for admin-purposes, it might be some kind of an detail-overkill for common users. In order to give users a more simple look of what happened so far in the workflow, I created a datasource that should work for all workflows and translations. Values are shown depending on the users browser language. It simply shows which step was left with which path, by which user, at what time. I (...)

(...) rows: "Sequence contains no matching element" - Error, and the value is not transferred into the target field. I tried with a different field in another process and another itemlist, with different datasource - same result. If I remove the target fields from the picker, it works. Changing to autocomplete works, but it is inconvenient for that purpose - picker is better as autocomplete, especially with th (...)

(...) how we can solve or workaround this problem, so that the datarow gets updated on PROD system. After some research it seems that no datarow (based on an internal view or SQL) gets the changes of its datasource after deployment. Remark: We are running an older version of Webcon BPS (2021.1.1.45), an upgrade is not possible here at the moment. Thanks a lot in advance & best regards, Nik

(...) Hi there the absence-wizard seems to be the only way to generate an absence-process in webcon. the datasource for vact-types is seemingly hardcoded. I cannot change the dropdown, delete it, nor change the system connection to add more types. if I add a new dropdown and simply hide the provided one, the data does not go where it´s supposed to go because it is not transparent where the data is written or ho (...)

(...) Hi there, does anybody know why this error occurs? Happens the following way: - Business rule retrieves datasource column (from [CacheOrganizationStructure]) COS_AD_name by means of a form field value (see 1.png) - Rule works fine if clicked on 'Test' button - This business rule is used in the cyclical action 'Update related workflow instance' with the goal to update a workflow's form values on a (...)

(...) On callback of popup item we want to set new workflow element id to dropdown, but obviously the new item is not in dropdown. Is there an easy way (with Javascript) to trigger reload of dropdowns datasource ? Thanks a lot in advance & best regards, Nik

(...) . I am at a loss. has anyone successfully connected Webcon with Dynamics Business Central ? Could anyone provide some insight (maybe even screenshots) on how to configure the Connection and datasource (s) ? All I want is use some published API webservices to inflate list items or use some webservice data as sources for dropdown fields....

(...) combination of 1. webcon integrated OAuth2 APP Authentication (APP) 2. REST WebService (or any other way to get data from BC SaaS with webcon) to connect to Business Central SAAS to use as a datasource ? could anyone provide me with screenshots on how to set it up and provide screnshots of an example datasource ? thanks in advance ps.: I successfuly used other REST sources, but OAuth / (...)