How to use the OPENJSON tabular function to handle a data import to WEBCON BPS with REST nested data collections. The problem – nested data collections In the previous post I described the possibility of integration with WEBCON REST API data connection using WEBCON BPS authentication. While retrieving data, I encountered a problem where the…
Tag: workorounds
Starting a large number of WEBCON BPS sub-workflows
How to run large number of sub-workflows? Start subworkflow (SQL) action configuration. How to run thousands of instances of WEBCON BPS workflow? Problem: large number of sub-workflows Using WEBCON BPS, you may need to register thousands of sub-workflows simultaneously. Unfortunately, start such a number of workflow instances without encountering errors is impossible. Below you will…
Excel – Import and performance for item list
How to import hundreds of rows from an Excel file to the item list? What problems can you encounter when importing data into the item list? Introduction WEBCON BPS allows you to export and import data from Excel files. If the amount of data we want to import is small, there are usually no problems….
PowerShell action– the lifesaver of my WEBCON project
In this post, I will show the problems I’ve encountered while creating an application based on WEBCON BPS. How I used the Python script in WEBCON BPS using a standard “Run a PowerShell script” action. In the previous article, I wrote about how using WEBCON BPS I created an application to automatically generate a menu…