Kinetic Tabular Data Retrieve logo

Kinetic Tabular Data Retrieve Version 4

Retrieves a single CUSTOM:KSSRVTableData_base entry with the Instance Id specified. This is equivalent to retrieving a row of data that the customer entered into a table. This allows for activity on an entire row of data, usually within a loop, rather that just a single column of data (which can be accessed just by turning the json into XML and looping through that result)

Parameters

Name Description
Instance ID: The instance id associated to the Table Data record to retrieve

Sample Configuration

Name Description
Instance ID:

Results

Name Description
CustomerSurveyInstanceID The 'CustomerSurveyInstanceID' of the retrieved CUSTOM:KS_SRV_TableData_base record.
Survey_Template_Name The 'Survey_Template_Name' of the retrieved CUSTOM:KS_SRV_TableData_base record.
SurveyInstanceID The 'SurveyInstanceID' of the retrieved CUSTOM:KS_SRV_TableData_base record.
Table Name The 'Table Name' of the retrieved CUSTOM:KS_SRV_TableData_base record.
Label1 The 'Label1' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 1 of the saved table.
Value1 The 'Value1' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 1 of this row the saved table.
Label2 The 'Label2' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 2 of the saved table.
Value2 The 'Value2' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 2 of this row the saved table.
Label3 The 'Label3' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 3 of the saved table.
Value3 The 'Value3' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 3 of this row the saved table.
Label4 The 'Label4' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 4 of the saved table.
Value4 The 'Value4' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 4 of this row the saved table.
Label5 The 'Label5' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 5 of the saved table.
Value5 The 'Value5' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 5 of this row the saved table.
Label6 The 'Label6' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 6 of the saved table.
Value6 The 'Value6' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 6 of this row the saved table.
Label7 The 'Label7' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 7 of the saved table.
Value7 The 'Value7' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 7 of this row the saved table.
Label8 The 'Label8' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 8 of the saved table.
Value8 The 'Value8' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 8 of this row the saved table.
Label9 The 'Label9' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 9 of the saved table.
Value9 The 'Value9' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 9 of this row the saved table.
Label10 The 'Label10' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 10 of the saved table.
Value10 The 'Value10' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 10 of this row the saved table.
Label11 The 'Label11' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 11 of the saved table.
Value11 The 'Value11' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 11 of this row the saved table.
Label12 The 'Label2' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 12 of the saved table.
Value12 The 'Value12' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 12 of this row the saved table.
Label13 The 'Label13' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 13 of the saved table.
Value13 The 'Value13' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 13 of this row the saved table.
Label14 The 'Label14' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 14 of the saved table.
Value14 The 'Value14' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 14 of this row the saved table.
Label15 The 'Label15' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 15 of the saved table.
Value15 The 'Value15' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 15 of this row the saved table.
Label16 The 'Label16' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 16 of the saved table.
Value16 The 'Value16' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 16 of this row the saved table.
Label17 The 'Label17' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 17 of the saved table.
Value17 The 'Value17' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 17 of this row the saved table.
Label18 The 'Label18' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the header of column 18 of the saved table.
Value18 The 'Value18' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 18 of this row the saved table.
Label19
Value19 The 'Value19' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 19 of this row the saved table.
Label120
Value20 The 'Value20' of the retrieved CUSTOM:KS_SRV_TableData_base record. This is the value of column 20 of this row the saved table.
Instance ID:

Changelog

kinetictabulardata_retrieve (2012-09-18)

  • Initial version. See README for details.

V2 - Increased row count from 10 to 20

V3 - Corrected Init to contain correct label names


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 Assignment Record Update
Updates the Request Due Date, Work Order Due Date, and/or Priority field(S) on a specific record from the KS_RQT_Assignment 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 Retrieve
Retrieves 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 Attribute
This handler checks to see if a specific attribute is defined for 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 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
Updates the Validation Status, the status that is displayed to the end user, of the specified Kinetic Request submission record and sets the Request Status to "Closed".
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 Update Answers
This handler creates or update answer records related to the specified submission given one or multiple JSON answer sets.
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 Table Data Create
Creates an entry in the CUSTOM:KS_SRV_TableData_base form
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.