Kinetic Table Data Create logo

Kinetic Table Data Create Version 2

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: http://community.kineticdata.com/10KineticRequest/Solutions/PuttingAnswersintoYUITables. Each row in the table will be saved as one record in this form. One result 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: 000000000000001 000000000000002 The format of the XML of instance IDs returned is: AG00505696001CJTKUQ8hIBgSCAE AG00505696001CJjKUQ5CDIBgSyAE</instanceid> 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 you want to report on data by template, rather than just by individual record.

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

Name Description
JSON String:
Table Name:
Originating ID:
Template Name:
Template Instance ID:

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.

Changelog

Kinetic Table Data Create V2 (2013-06-17)

  • Updated the returned request ID list to be XML

  • Added XML list of Instancd IDs to results

Kinetic Table Data Create V1

  • Initial version. See README for details.


Related Handlers

KAPP Assignment Group Membership Lookup
Retrieves the login and email information for the assignee or group members of the specified group.
Kinetic Assignment Record Retrieve
Retrieves a specific record from the KS_RQT_Assignment form.
Kinetic Cost Calculate Costs
Returns an XML listing record ids found in the KS_SRV_Helper form.
Kinetic Helper Record Create
Creates a specific record in the KS_SRV_Helper form.
Kinetic Helper Record Find All
Returns an XML listing record ids found in the KS_SRV_Helper form.
Kinetic Helper Record Find
Returns the first record id to a specific search in the KS_SRV_Helper form.
Kinetic Helper Record Retrieve
Retrieves a specific record from the KS_SRV_Helper form.
Kinetic Helper Record Update
Updates a specific record in the KS_SRV_Helper form.
Kinetic Request Answer Create
Creates a Submission Answer
Kinetic Request Answer Update
Creates a Submission Answer
Kinetic Request All Answers Retrieve
Retrieves Submission Answers
Kinetic Request Approval Create
Creates an approval submission for the submission record specified by the 'Lookup Id' parameter, typically the Instance Id of the originating base request.
Kinetic Request Attribute Create
Populates Attributes Records (Settings Tab) for Service Items from a CSV data file
Kinetic Request Checkbox To XML
This handler converts a Kinetic Request checkbox answer into an XML string.
Kinetic Request Email Message Create
Creates a Kinetic message record using the specified message template. Once the Kinetic Request message poller process the record, an email message is generated and sent to the target recipient.
Kinetic Request Service Item Add Attribute
This handler adds an attribute to the given service item.
Kinetic Request Service Item Detect
This handler checks to see if a given service item already exists.
Kinetic Request Service Item Remove Attribute
This handler removes a specific attribute that is defined for the given service item. If multiple instances of the same attribute are defined for the same service item, they are all removed.
Kinetic Request Service Item Rename
This handler renames a given service item.
Kinetic Request Service Item Update Status
This handler updates the status of a given service item.
Kinetic Request Base Submission Retrieve
Retrieves a specific Kinetic Request base record from the KS_SRV_CustomerSurvey_base form.
Kinetic Request Submission Build Attachment URL
Builds and returns URL for a file download of an attachment that was uploaded as a question answer.
Kinetic Request Submission Build Review Request Url
Builds and returns the URL that corresponds to a review request view of the desired Kinetic Request submission.
Kinetic Request Submission Close All Open
Updates the Validation Status, the status that is displayed to the end user, of the specified submission record and sets the Request Status to "Closed" for all open requests associated with the provided originating ID.
Kinetic Request Submission Create Answers
This handler creates answer records related to the specified submission given one or multiple JSON answer sets.
Kinetic Request Submission Create
Creates a new base submission using the information specified.
Kinetic Request Submission Dataset Retrieve
Returns all dataset values for a given submission. For use inside of subtrees.
Kinetic Request Submission Format Answers HTML
Builds a simple result string by formatting a specified subset of answers for the source Kinetic Request submission.
Kinetic Request Submission Format Answers
Builds a simple result string by formatting a specified subset of answers for the source Kinetic Request submission.
Kinetic Request Submission Get Answer Set
This handler builds a JSON answer set for the current submission. The JSON structure maps question labels to their corresponding answers.
Kinetic Request Submission Update Status 7
Updates the Status field (ID 7 not validation Status).
Kinetic Request Submission Update Status
Updates the Validation Status, the status that is displayed to the end user, of the specified Kinetic Request submission record.
Kinetic Submission Complete
Sets a submission to complete and triggers the complete workflow, such as firing triggers
Kinetic Submission Retrieve Attribute
Retrieves the Kinetic Request base request with the specified values
Kinetic Submission Update Attribute
Updates the Kinetic Request base request with the specified values
Kinetic Tabular Data Find
Retrieves request IDs (field 1) and Instance IDs (field 179) for Remedy entries for the form used for storing table data.
Kinetic Tabular Data Retrieve
Retrieves a single CUSTOM:KS_SRV_TableData_base entry/saved table row with the instance id specified.