Data sources

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?

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

SQL: Unknown error:Incorrect syntax near ')'...

0 6

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 an interval (thus using 'Change value of single field is not available as an action) - In (...)

Import-Export Template Process with zip archive - ERROR

2 1

Hello, I tried to import some templates from DEV environment to TEST environment and when I uploaded the .zip archive the following error occured on the .xlsx report: "Value cannot be null. Parameter name: securityProvider" Does anyone know why do we get this error? Thanks!

Active Directory Contacts as Data Source

0 7

Hi everyone, Does anyone has an idea on how to retrieve all "objectClass=contact" from Active Directory and use the result as a Data Source? Thank 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

Integration with Sales Force

0 4

Hello Community, Does anyone established the connection between Sales Force and Webcon? I have all the documentation on the Webcon side for the REST API but I'm finding some difficulties on the Sales Force side as I'm not sure on where and how to configure the necessary steps to get the connection between the 2 systems. Thank you all for the attention!

Datarow is not updated after deployment

0 0

Hi community! We implemented a document template with certain fields coming from a custom datarow (based on SQL-Query). We deployed the solution and the document template to PROD and everything was fine. After that we added one new field to the datarow (SQL query was modified) as a new requirement and added the new field also to document template. On DEV system everything looks fine, we deployed the solution to PROD and suddenly this new field is missing in Word Add-In (in the selection of d (...)

Initialize Item List with SQL Query from Oracle DB

0 4

Hello all, Does anyone configured an Item List to be initialized with a SQL query that will query from another database? In this case I want to query from an Oracle DB and initialize the columns with the columns from the query: select milestone as {DCNCOL:185}, milestone_date as {DCNCOL:186}, amount as {DCNCOL:187}, currency_code as {DCNCOL:188}, amount_euro as {DCNCOL:189} from PL_Invoicing I'm trying to this but it's not working. Hope anyone has ideas for this! Thank yo (...)

Interact with Microsoft Business Central

1 1

Are there best practices how interaction with business central (formerly known as MS Dynamics NAV) can take place? What would be the preferred interface? I remember a communication with Webcon where comon data source was mentioned. Where are we here?