Actions

Start a subworkflow (SQL) with automatically filled Item List

0 2

Hello. Is it generally impossible to use the above action type to create a new workflow item with a "filled" item list or do I have a mistake in my doing? I have a table (item list) where I want to start subworkflows from (depending on field value) where this line of the item list is "copied" to the new workflow. Creating the WF item is easy, but the table stays empty. Is this a bug in my query or doesn't it work at all? Kind regards Klaus

Start Subworkflow (SQL) from a SQL Data Source

0 3

I am trying to write a SQL statement to start a workflow but the data source needs to be a SQL data source rather than the Webcon database. I have defined the SQL data source (ConnectWise Companies) and it is working OK. I think the problem is what do I use in the "From" part of my SQL statement. If I omit the From part, when I test my query it does not recognise the column names and says "Invalid column name Company ID, Invalid Column name GroupID" I have tried using the Objects tab in the (...)

How get value from Header in Rest API response ?

0 4

I want to use "Invoke rest web service request" action and in response I don't have json but message in Header: Response-Code: Forbidden (403) Response-Body: {"type":"/challenge","title":"Challenge requested","status":403,"detail":"Request to perform challenges described","instance":"fe66c6a2-2cc5-42f9-a4ce-96bea7cd716b"} Response-Header: Date: Thu, 28 Sep 2023 07:06:57 GMT Connection: keep-alive Vary: Origin, Access-Control-Request-Method, Access-Control-Request-Headers x-challe (...)

URL fields, changing address and name

0 4

Hi all, Is there any possibility to change an URL field adding the link in the address and the text we want in the name? I want to create an URL link using a field from (through Change field action) the form but I don´t to display a more friendly name than the address. Thank you!

Cannot find 'On entry' action

0 2

Hi everyone, I am quite embarrassed to have to ask this question because the answer is probably quite simple. Currently, I am reviewing a Webcon process that I created some time ago. In doing so, I started to implement some things (e.g. sending emails) in a better way. Now I have noticed that I have an "on entry" action in the step actions in some paths (which was previously responsible for sending emails). Where can I find this "on entry" automation? The automation is obviously not (...)

Global actions - On start (cyclical) - Error description ?

0 12

Hello everyone In a process I run a cyclic action in the Global Actions. This action contains a "Start a subworkflow (SQL)". When the subworkflow action is executed I just get the message 'Incorrect syntax near '}'.' in the *Last error* field. As seen on the screenshot There is no '}' in the SQL query of the subworkflow action... So now I am facing the mystery where exactly this error occurs at all and what exactly is the cause. Does anyone know where I can find more information about t (...)

Using dictionary process data in action “start a subworkflow (SQL)”

0 10

Hello community, I am building application with one Dictionary process, and one standard process with 2 workflows. I would like to start second workflow many times as subworkflow of fist workflow and assign it to the several users/users groups (one per subworkflow) selected from Dictionary process. I am trying to use action “start a subworkflow (SQL)”. My understanding is that “start a subworkflow (SQL)” action (configuration of Data settings – Query returning data) works as follows: SE (...)

PowerShell - Connect-MsolService

0 0

Hi, Is anyone having trouble calling a PowerShell script that connects to MsolService? After updating WebCon to version 2023, the action calling the script ends with the error as below.

Not adding attachment - when using cyclical action create SQL subworkflow

0 4

Hi Guys I need your help. I start tasks based on a workflow but attachments do not transfer. If I do it manually as a action on path then the attachments move to subworkflow and its ok. But if I use a cyclical action to call the same action -> "create SQL subworkflow", tasks are created but without attachments :/ Example in the attachment, I trigger the same action: Uruchom zadanie TEST (en: Run the TEST task) I use version 2022.1.4.223

User > API authorization

0 7

Hi, I need to add an event to the AAD group calendar. Webcon uses/is synced with local AD. AD is synchronized with AAD. On the AAD side, an application with API permissions has been added Adding AAD groups and adding users to groups via graph API from webcon works fine. But, for example, if you want to add an event to the group's calendar POST method https://graph.microsoft.com/v1.0/groups/{group_id}/calendar/events The api needs to run in the context of the logged in user, not in th (...)

Calendar

0 2

Hi everyone, I was wondering if it is possible to create an entry in an Outlook calendar with Webcon. I saw the action "Exchange Events" and as I understood it according to the documentation, it should be possible with this action. However, I do not fully understand the different settings for this action. How can I specify, if I have multiple calendars in Outlook, in which calendar I want to write my entry? Or did I misunderstand something? Thank you for your help in advance! Bes (...)

Execute Action (or Automation) from Item List row

0 4

Hello everyone! I have an item list with a dropdown field where user chooses a WFD_ID value. I would like to execute an action (Update related workflow instance or Invoke REST web service) passing the WFD_ID chosen in the mentioned field to the action. Is something like that even possible? I can't find a solution myself. Thank you, M.

Create Excel File

0 2

Hello, I have a short question. I want to generate an Excel file with my data from the BPS datasource. I created an Excel template with a worksheet(test) and a table(myTable) and a action create excel. I write the assignment like this: test!myTable and my data to the right cell. But I always get an error. (Invalid cell name) If I just want one data set and just write the cell names for each like test!A2, it works perfectly. What am I doing wrong? Thanks for some hints, Mario

How to get previous action

1 5

Hi Guys, knowing i am a newbie, i just have a maybe quite simple question. Can i get the ID of the 'calling' action on the entry path of an action? Would like to check which ist the caller and depending on the result send an email or not. Thats it ;-) Thanks for some hints, Gerd

Hyperlink function after export-import

0 1

Hello, After upgrading to 2023.1.1.89 I'm getting error "Attempting to launch workflow instance for a form type not connected with the current workflow." I found out that the reason for this error is wrong workflow ID in hyperlink function. Everything works well on dev environment but after export and import on test environment hyperlink is not working causing above error. It seems that Workflow ID tag isn't "translated" during the import process and remains the same on TEST like it was on D (...)

Changing/Deleting table entries in a process step

0 4

Use case: We are using an offer process/workflow, where we fill in the costs in a table - e.g. columns "descripition, quantity, price per unit, total price." In case the offer is accepted and we'll need a change request of the costs we need a two separate process steps. The first step will start the change request, opening two additional columns in the table - "quantity for change request, total price for change request". This can be done for every existing row in the table. In the next wor (...)

Add attachment from current instance to another workflow

0 6

Hi, If I am reading documentation correctly action Add attachment allows copy/move attachment from another workflow to current instance. My case is opposite: 1. I have an invoice approval workflow which in the end requires (business requirement) adding payment confirmation (PDF) from banking systems. Manual process is very time consuming. 2. Each payment confirmation has in transfer's description instance signature from the invoice workflow. 3. I've created another workflow, which is mo (...)

Missing barcode actions

0 2

Hi, I am using webcon bps designer studio v. 2022.1.2.31 and I don't have actions like "Read barcode" or "Add a barcode". I just don't have these types of actions to choose from. Any idea why?

Configure action "on timeout"

0 4

There are two date fields in our workflow. To pass the process to the next workflow step, we use an action "on timeout". Checking for a date field works. However, we need a condition for the timeout that takes both date fields into account: If date field 2 is non-empty take this date for the timeout, otherwise take date 1 for the timeout. Can this be implemented with an "on timeout" action and if so, how?

Rest Web service - item lists

0 2

Hi! Is possible using REST WEB SERVICE to sent: { "type": 0, "firm": 0, "id": 0, "ord": 0, "description": "string", "lines": [ //Item list { "ord": 0, "value": 0, "type": 0, "percent": 0, "direction": 0, "dimensions": [ { "id": 0, "type": 0 }, { "id": 0, "type": 0 } ] } ] } When I use 'Json grid' I do (...)