Kinetic Tabular Data Find Version 2

This handler returns the request ids (field 1) for all records in the CUSTOM:KSSRVTableData_base form that match the provided query. This is returned in XML format (like below) for use in loops.

000000000000013 000000000000381 000000000002582

It also returns the instance ids (field 179) in a similar format:

AG0050569A648CU5tSUAUcZMAgc8AC AG0050569A648ClZtSUAkMVNAgVcYC AG0050569A648CMZtSUAKUBMAgMrkC

Note that this is not necessary if you want every row out of a table that is saved in the same tree. In that case, the results of the table data create handler can be used.

Parameters

Name Description
Survey Instance ID Survey Instance ID
Survey Template Name Survey Template Name
Originating ID Associated Request GUID
Table Name Table Name
Value1 Value in Column 1
Value2 Value in Column 2
Value3 Value in Column 3
Value4 Value in Column 4
Value5 Value in Column 5
Value6 Value in Column 6
Value7 Value in Column 7
Value8 Value in Column 8
Value9 Value in Column 9
Value10 Value in Column 10
Value11 Value in Column 11
Value12 Value in Column 12
Value13 Value in Column 13
Value14 Value in Column 14
Value15 Value in Column 15
Value16 Value in Column 16
Value17 Value in Column 17
Value18 Value in Column 18
Value19 Value in Column 19
Value20 Value in Column 20

Sample Configuration

Name Description
Originating ID <=%dataset['Originating ID']%>
Table Name ContactTable
Value6 Alternate Contact
Survey Instance ID
Survey Template Name
Value1
Value2
Value3
Value4
Value5
Value7
Value8
Value9
Value10
Value11
Value12
Value13
Value14
Value15
Value16
Value17
Value18
Value19
Value20

Results

Name Description
RequestIdList The request ids (field 1) of the updated record.
InstanceIdList The instance ids (field 179) of the updated record.

Changelog

Kinetic Tabular Data Find (2013-06-17)

  • Expanding fields available to search by

Kinetic Tabular Data Find (2013-01-30)

  • Initial version. See README for details.


Related Handlers

Kinetic Assignment Record Retrieve
Retrieves 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
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 Retrieve
Retrieves a Submission Answer
Kinetic Request Answer Update
Creates a Submission Answer
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 Checkbox To XML
This handler converts a Kinetic Request checkbox answer into an XML string.
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 Rename
This handler renames 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 Review Request Url
Builds and returns the URL that corresponds to a review request view of the desired Kinetic Request submission.
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 Dataset Retrieve
Returns all dataset values for a given submission. For use inside of subtrees.
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
Updates the Validation Status, the status that is displayed to the end user, of the specified Kinetic Request submission record.
Kinetic Submission Retrieve Attribute
Retrieves 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 Retrieve
Retrieves a single CUSTOM:KS_SRV_TableData_base entry/saved table row with the instance id specified.