Actions

Hi Karol,

Thank you so much. I had the wrong mode selected and it didn't occur to me that this might be the issue. Solved. :)

Cheers,
Martin

Hi,

if you don't want to convert it to PDF, but just register a workflow based on the file, it should work for any file type.

Regards.

Hello everyone!

Does anyone know if there is a way to start a workflow instance based on xml file stored in a folder on the disk? Unfortunately the HotFolder functionality allows starting workflows only for a few supported file types. Any chance to workaround this limitation?

Thank you,
Martin

Hi Agnieszka, Hi Daniel

I'm assuming that Daniel is right - we can't map collection items into single fields - Webcon expects item list.

There shouldn't be a need to store the body inside of a multi-line field though - it should be accessible through business rule on mapping page as 'Input value' parameter.
I'm parsing XML from REST-like API which returns XML instead of JSON. In attachment example mapping, and business rule used to get the XML content.

With JSON though it might be more tricky as OPENJSON requires database Compatibility Level at 130, and by default Webcon database are at 120 according to this*
You should be able to check it with this SQL:
SELECT compatibility_level
FROM sys.databases WHERE name = 'BPS_Content';

However i'm thinking right now, that you might be able to create an empty database with high compatibility level, create a new connection, and use that connection to query with OPENJSON available.

*https://community.webcon.com/posts/post/compatibility-level-of-webcon-bps-databases-good-practices/323/3

Hi Agnieszka,

I haven't used a similar example but I would check the following:
- property value
It's of type collection and I would assume, that you won't be able to assign a value from a collection to a single field. You would need to select an item list as the destination field for the collection.
- collection/array with objects
I haven't had this case where the collection/array contains objects. I don't know whether this will work.

If you can't make it work with an item list, you try to store the Response:Body in a multi line field and use SQL to extract the information.
https://learn.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-ver16&redirectedfrom=MSDN

Best regards,
Daniel

Hello Experts,
We're currently on BPS version 2021.1.2.143 (getting ready for upgrade)
I try to invoke a REST API to update form fields, and I get a proper response from the service, however, it doesn't update the fields.
I'm using OData Query to filter and expand the data, and load the response definition from the service.
The action configuration and action log with response are on my pictures.

What can I be doing wrong? The response is complete, however it doesnt populate the fields.

Thank you in advance for your help.

Hi Joanna,

this is quite simpel, if you know how to implement it.

You will need to have a cancel path on each step of the child workflow from where it could move to cancel.
In the parent workflow cancel path you will add a "move workflow (sql)" function.
Instead of defining a fixed path I would define the path dynamically.

Pseudo code:
select WFD_ID
case
when WFD_STPID = "In progress step id" then "Cancel path of in progress step"
when WFD_STPID = "Other step id" then "Cancel path of other step"
else -1 end PATH_ID
from WFElements
where WFD_WFDID = 12345

I haven't checked the name of the PATH_ID, you can click on the blue info icon to verify it.

Best regards,
Daniel

Hello,

The question I have sounds very easy, how do I cancel all the remaining subworkflows that are not already "answered" to?

Parent - 12345 - will wait for all 3 subworkflows to be done
Child 1 - 12346 - finished
Child 2 - 12347 - in progress
Child 3 - 12348 - in progress

All I need is, if I cancel 12345, then 12347 and 12348 will automatically be classed as finished. Can you help at all?
Thank you!!

2022.1.4.404

Hi,

what version of webcon do you have?

Thanks,
Raluca