Hello all
I am writing a custom service broker that returns four values.
I want the output values to be outputted on the SMO tester tool in the exact format K2 SMOs output data(table format).
I have used List<string> and Datatable datatypes, but they do not work.
See attached picture showing my desired output format.
What data structure do I need to achieve this as List<T> and Datatable do not work?
Cheers
+15
Hi,
I believe you just need to return a simple array of objects. You can refer to a sample project linked to this document.
Good day Joesir,
Have you tried querying the ServiceObject using ADO.NET query tool if not. Try writing and executing a ADO.NET statement. The ADO.NET query allows you to specify specific properties in your smart object located in different sources. In your case this would be your custom DLL service broker that you have developed and registered a service instance for it in the smart object tester tool. After doing that instead of executing your smart object in tester tool you will select the option below “create smart object” and select the one that says, “ADO Query”. From there you will write an SQL statement that will Query against your Service Object to sort and filter your data and the statement will be outputed just like executing a list method for a SmartObject.
Please see through the following link and select “Step 3: Writing an ADO.NET query against a SmartObject” which has detailed steps and instructions on how the ADO.NET query statement works against ServiceObjects.
Should you find this information helpful to your problem, kindly mark it as a "Kudo and/or Accepted Solution" as this will help others seeking for relevant information in future.
Thank you;
Regards;
Dumisani
Hi
I did repo/solutions similar to your solution, i can't attach all the screenshots here but there's documentation followed to comply with repos, follow https://maverick0607.wordpress.com/2017/11/08/creating-a-custom-dll-and-integrating-it-with-k2/
Customize the content to suit your needs https://help.k2.com/en/kb001246.aspx
Should you find the above content useful kindly mark as "Accepted Solution and/or Kudo", to help other community members looking for similar solutions.
Kind regards;
Widson.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.