Skip to main content
Kinetic Community

What to do with answers placed in a Table

Once you have collected answers in a table format and saved them into a JSON as specified in this solution, you will then want to use them. This solution describes some possibilities how to process/use these answers.

Usage

What you do with the table stored in the JSON string will entirely depend on what you want to do with it. 

You may want to include the table in a notification/email. Most emails are sent in HTML format these days. Use this handler to build a simple HTML table from the stored JSON and then you can include the HTML output in your email where you want to include the table. (Example Send Table in Email tree on example item)

You may want to loop through the rows in the table and perform actions based on each a data point in a column. To do this, you will need to convert the JSON into XML with this handler. Details of constructing a loop in this data are included in the handler page. This same thing can be accomplished, with a little more precision by using the JSON Parse handler to first parse out the desired column, then loop through those results. This gives you the ability to filter out unique values if desired. (Examples of both in the Loop Through One Column tree on example item)

You may want to push the data into a incident, change, or plain text email. To do this, you can use this handler to convert the stored JSON into CSV and push the comma delimited output into the desired location. 

You may want to store this data in a format that is easier to read than JSON for reporting purposes. There are a multiple possible solutions for this. One of the simplest is to use this handler to convert the stored JSON into CSV and push the comma delimited output into a hidden question on the service item using the create answer handler. (Example in Place Table as CSV in item for reporting purposes on example item)

To be able to loop through all the data in the rows, instead of just one column, by row and a more advanced reporting solution involves saving the data into Remedy and then retreiving the data out. An example of this approach is described in this Create Tabular Data handler page and the cooresponding Find and Retrieve handler pages. (Examples in Loop Through Rows tree on example item)

Example

The pictured examples are included in the updated Table of Answers service item attached. Note that you must load the related/refrenced handlers into your systems before the examples will function. Example trees are inactive. Activate them one at time to test one of the examples. See the details for each example by following the links below.

Send Table in Email

Loop Through One Column

Place Table as CSV in item for reporting purposes

Loop Through Rows