Skip to main content

Fairly new to K2 as i come from a C# background now i have a question i want to ask, How do i get to use .asmx Webservices in K2 to retrieve data from Databases and use them in K2 Smartforms

Hi Gozni,


 


Please have a look at the below documentation.


https://help.k2.com/onlinehelp/k2blackpearl/devref/4.7/default.htm#WorkflowWebServiceASMX.htm


 


Kind regards


Hi Gozni,


 


Please see link below:


https://help.k2.com/onlinehelp/k2five/devref/5.0/default.htm#Runtime/WF-Web/WebServASMX.htm


 


Kind Regards


Luyanda


 


Please Note: K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.


What i actually mean is , I have written a Webservice in Visual Studio and MSSQL, now i want to use the information called up from my Webservices (Database Columns) inside the K2 smartform like a Data Label. Thats apparently what i mean on here, my apologies for my English if misunderstood.

Hi Gozni, I think I can help you here. Hopefully I am understanding you correctly, but it sounds like you wrote some web services that read data from SQL Server? if so, you need to deploy those web services somewhere, doesn't have to be the same server that K2 resides on but a real web server with IIS running. Then, use the SmartObject Service Tester to Register your Web Service. You'll need the full URL to the asmx to plug into the dialog for registering the web service. K2 with then go out and analyze the service interface and provide hooks to each function that you can then wrap in SmartObjects. It is the SmartObject that you will then use to execute the functions and return the data to your forms.

I understand that was a pretty high-level explanation, I hope it gives you a start.


Exactly what i wanted @  @tbyrne777 Could you assist with a video or something? Would be greatly appreciated.


Hi Gozni,


 


You can use Service Broker to expose the back-end systems like SQL, Active Directory, SharePoint and others, however please look at the documentation on integration: https://help.k2.com/onlinehelp/k2five/userguide/5.1/default.htm#K2-Management-Site/Integration/ServiceTypes.htm


 


Kind Regards


Luyanda


 


Please Note: K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.


Hi Gozni - in the link that Luyanda provided above, jump to the "Service Instances" section. This gives a number of quality screenshots that describe the process of registering new integration points (Web Services in your case, but K2 supports a number of other integration types)


Good day 


I have provided some screen shot containing steps to follow, in addition i have attached a link that will directly tak you to the whole code: https:


//help.k2.com/onlinehelp/k2five/devref/5.0/default.htm#Runtime/SmO-Client/Using.htm%3FTocPath%3DRuntime%2520APIs%2520and%2520Services%7CSmartObjects%7CSmartObject%2520Client%2520API%7C_____1


 


Please Note: K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.


Kind regards


Thabang


Reply