Hello!
is there a best practice how to transfer data from an external data source (eg. sql server) into a dictionary in webcon (and webcon in general)?
I heard something about a technical path?
Hello!
is there a best practice how to transfer data from an external data source (eg. sql server) into a dictionary in webcon (and webcon in general)?
I heard something about a technical path?
Hi,
you can either use import from Excel file
OR
create connection to your external server and use action "Start a subworkflow (SQL)" to add all entries to dictionary
(depending on how much data you have)
Hi,
there is a KB article linking to my blog post on importing data into Webcon which will show you two possibilities:
* Using cyclical actions
* Using REST API
https://community.webcon.com/posts/post/importing-data-into-webcon-two-approaches/483/3
After some time I'm on REST API team, as cyclical actions require some tinkering to avoid timeouts.