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

latest posts

Hi,
We have a client that uses sharepoint to work with documents, for contracts. There is an item list that is used to manage these documents (so far, only upload and download) and they would like to also be able to delete some of the already uploaded documents. There is a main folder for each contract and there are a couple of subfolders for attachments, depending on when they where added.

As far as i understand, i will need to use the action 'Delete a list element'. I see that i can either give it an ID or use a CAML query (first time user here; just started reading about it).
I most definetely need to use the CAML query since there can be more than one document that needs deleting but i am also curios about that ID.

Where can i get that ID from? I tried testing with the Document ID found in SharePint, at info, but got an error ('Cannot convert "{0}" to correct (integer) value of deleted element ID'). If i use 1 it gives back 'There is no Web named "/sites/contracte/Documents/2024/Contract_1/_vti_bin/sites.asmx"'.
Does the CAML query support finding more documents if they are in different folders/subfolders as long as it does not go further back in the List address?
Does the List address need to be all the way to the folder where the documents are or can i stop at the contracts folder?

I would like to make this as dynamic as possible since there is a high chance for other subfolders to appear.
I found some discussions on the forum and will go through these, as well as read more about CAML. Any info and further reading materials will be appreciated.

*the version is 2021.1.3.205, standalone
Thanks in advance,
George

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 action because some of this data match and system had no problem (in first row "MPK", and in third row "Alokacja" - but in other rows same data "MPK" dosen't match). When i try match this manualy it's work fine.
Someone had similiar issues? What i am missing?
Thanks for help

I've figured it out.
In case someone runs into the same issue, you have to edit and save those actions that will cause errors. It will regenerate the XML correctly.
Seems like in the past you were able to choose a column for the user or group attribute and it would remain saved in ACT_Configuration column.

Currently saving over the action removes the "<tocolumn>Login</tocolumn>" field, replacing it with "<tocolumn />" that the current version works with.

A simple sql to start with: SELECT * FROM WFActions WHERE ACT_ActionKindID=13 AND ACT_Configuration LIKE '%<TO%COLUMN>%'

I haven't tested it, but I assume It'll result in an error as well for DW (CC) and UDW (BCC). If not, then instead of '%<TO%COLUMN>%', use '%<TOCOLUMN>%'.

MVP

Hi Stanisław,
By default - when you create a report it takes into account who is displaying that report, so with correct configuration one report might be enough for all companies.

Every time new element (document/form) is created in webcon it's assigned to a company (COM_ID, WFD_COMID in database) - there is always a default one (not sure if WEBCON or Headquarters).

Based on that, value which is assigned to all elements, you can define privileges on two levels, which also take into account companies:
* Process
* Workflow/Form

When there are 3 companies defined, then on process/workflow privileges level there will be 4 tabs to manage privileges:
* General
* Company A
* Company B
* Company C

If you specify privileges in 'General' tab it gives access to all instances - so users with 'Access to all elements' will see all elements from all companies.
On the other hand if you will use 'Company A' tab, then specified users will get access to elements with assigned 'Company A'.

'Default for' configuration will handle choosing right company for specific people, but you can also define 'Start new elements' privileges on Process or Workflow/Form level to make sure, that users won't have possibility to start elements for other company.

I'm not sure what do you mean by several forms - have you registered new documents with selected company, or there are multiple form types?
Multiple forms are not required to handle multiple companies - one is enough, but I'm not sure if it's not just a business case which just deals with many form types :)

Hello community,

I would like to build a form that will be used in a multi-company environment. I have configured the companies and assigned specific employee groups in the "default for" tab. For employees from different companies, I have created several forms where I fill in the default 'company' field. Based on this, I would like to create a report that will allow employees from company A to view only the forms related to company A. I will also need an 'administrative' view that will allow a specific group of users to view the report from all companies simultaneously.

Thank you in advance for your help.

MVP

I Mihali, I've checked Swagger UI*, and there are no data sources available through api - closest we can get, are connections, but thats not it.

/api/data/v4.0/db/{dbId}/elements/resolveFieldValue/{idguid} this endpoint based on Swagger description:
"Gets available values for selected picker/choose form field"
It will not return directly Fixed Values List content, but it should also consider all filters which are on specific field for specific element ID.
You could though create some technical element, which would be used as some kind of helper to get to those values.

I think there is something wrong in the URL based on the error - i can easily use this endpoint, are you sure that you've authorized with API application with granted permissions? Based on Swagger:
At least one permission required: App.Elements.Admin.All; App.Elements.ReadWrite.All; User.Elements.Admin.All; User.Elements.Admin.<ProcGuid>; User.Elements.ReadWrite.All; User.Elements.ReadWrite.<ProcGuid>?

It also requires passing workflow id, and formtype id as queryparams, so whole request might look like this:
https://mycompany-webcon/api/data/beta/db/{db_id}/elements/resolveFieldValue/{field_id}?workflow={workflow_id}&formType={formtype_id}

You could also consider querying them directly from the database.
There is WFDataSources table, and WFS_StaticValues column.


* On each webcon instance there is Swagger available under https://{instance}/api, you can read about it here: https://developer.webcon.com/docs/rest-api/

Hi,

Are "Fixed values list"s' content available through API? Not dictionaries or other process types, but "Fixed values list" object types only.
The need is to synchronize Webcon data with other systems, assuming Webcon repository is master.

I found this article https://community.webcon.com/forum/thread/2491 which states that there would exist /api/data/v4.0/db/{dbId}/elements/resolveFieldValue/{idguid}, but this kind of call results in 404 - not found error.

I did not find resolveFieldValue anywhere else, or any other solution for that matter, thus current question.

Thank you,
Mihail

WEBCON

Hi Andreia,

If your goal is to allow users to work on documents simultaneously, then you should refer to the third article: https://community.webcon.com/posts/post/working-with-onedrive-files/341/18
This article explains how to configure OneDrive connection in Designer Studio using AAD client credentials and what kind of permissions does the AAD app need ("Connection to OneDrive – configuration" section).

To obtain the credentials that you ask for (on your attached screenshot), you have to register an AAD app. I think you can follow this tutorial: https://learn.microsoft.com/en-us/azure/healthcare-apis/register-application

OneDrive owner is an account with OneDrive access, which will be used to store files shared by WEBCON BPS actions. The owner account has to have MFA disabled.

PS. I keep saying "Azure AD" out of habit, but I think it was recently renamed to Microsoft Entra ID :)