Skip to main content
Kinetic Community

Kinetic Table Data Create

Saves the data from a json string created from an HTML table into a Remedy form for future reporting and/or processing. To see how to create the data to feed into this handler, please see the community article here For more information, see the Detailed Description section below.

Downloads

By downloading this file, you acknowledge that you agree to our Terms of Service

kinetic_tabular_data_create_v2.zip

Note that the form provided is custom and not under support by Kinetic Support.

TableData_base.def

Detailed Description

Saves the data from a json string created from an HTML table into a Remedy form for future reporting and/or processing. To see how to create the data to feed into this handler, please see the community article here.

Note that the table name is a value you assign when using this handler to save the data. 

Each row in the table will be saved as one record in the form CUSTOM:KS_SRV_TableData_base. This form is provided in the download section. Note that this form is a customized example. This form stores a table name (identifier for the table), Associated Request GUID (Originating ID), the originating Request Template name, the originating Request Template ID, the column labels and the values for each value in the row.  In the provided form, up to 20 columns per row can be stored, the labels can be up to 254 characters, and the values can be up to 4000 characters (the out of the box size of the full answer field). If database storage space is a concern, the size of the value fields can be made smaller. If this is done, it is very important that the questions used to fill in the table have a character limit that matches the limit being put in place. Also, it is important to realize that hidden columns (columns not shown to the user) still are stored in the table. If you need more than 20 columns, you'll want to update not only the form with the new label and value fields (note that the field numbers are critical) but the find and retrieve handlers that go with it. Also, if you update the form name to match your naming schema, you'll want to be sure to update each of the handlers to reference your new form name.

One result of the create handler is the row count of the rows of data saved. The other is the instance IDs of the record for each row. This allows for looping through the rows without having to do a find handler if you want to loop through every row in the table.

The format of the XML of request IDs returned is:

<request_ids>
    <request_id>000000000000001</request_id>
    <request_id>000000000000002</request_id>
</request_ids>

The format of the XML of instance IDs returned is:

<instance_ids>
    <instance_id>AG00505696001CJTK_UQ8h_IBgSCAE</instance_id>
    <instance_id>AG00505696001CJjK_UQ5CDIBgSyAE</instance_id>
</instance_ids>

This handler can be used to store data for reporting. The Associated Request GUID (Originating ID) is a required field, but the Template Name and Instance ID are not. Note that this data may be required by your reporting process if yowant to report on data by template, rather than just by individual record. Reporting most efficiently from this form may require joining this form with the service item or service item template forms, depending on what is desired.

Parameters

Name Description
JSON String Serialized table data in JSON format
Table Name Identifier for the table
Originating ID Associated Request GUID
Template Name The originating Request Template name
Template Instance ID The originating Request Template ID

Sample Configuration

Parameter Example Configuration
JSON String <%=@answers['contactTableJSON']%>
Table Name Contact Table
Originating ID <%=@dataset['Originating ID']%>
Template Name <%=@dataset['Survey Template Name']%>
Template Instance ID <%=@dataset['Survey Instance ID']%>

Sample Configuration 2

Parameter Example Configuration
JSON String [
  {"FirstName":"John",
   "LastName":"Doe",
   "EmailAddress":"john.doe@test.com",
   "OfficePhone":"888-777-6666",
   "CellPhone":"666-777-8888",
   "ContactType":"Primary Contact"},
   {"FirstName":"JuneBug",
   "LastName":"Whatever",
   "EmailAddress":"jwhatever@test.com",
   "OfficePhone":"666-777-8888",
   "CellPhone":"555-666-7777",
   "ContactType":"Alternate Contact"}
 ]
Table Name Contact Table
Originating ID AG0050569A648C7lEqUA_lslAwSa0B
Template Name Contact Updates
Template Instance ID KSfb02da8bec9b1ca832597c3562a6e124b

Results

Name Description
Table Data Request Id List An XML list of the data rows/records created.
Table Data Instance Id List An XML list of the data rows/records created.
Table Data Row Count The count of the number of data rows saved/records created.

Change Log

Version Date Description
1   Initial version
2 2013-06-17 Updated the returned request ID list to be XML, added XML list of Instancd IDs to results
2 2017-06-21 Only load JSON in Task 3 and below to make it compatible with Task 4 and above.