Test/DropDown

method	effectiveness
None	0
Rhythm	90
Condom	95
IUD	99.9
Tubal Ligation	99.99

[{"method":"None","effectiveness":"0"},{"method":"Rhythm","effectiveness":"90"},{"method":"Condom","effectiveness":"95"},{"method":"IUD","effectiveness":"99.9"},{"method":"Tubal Ligation","effectiveness":"99.99"}]

choice
First
Second
Third

[{"choice":"First"},{"choice":"Second"},{"choice":"Third"}]

Testing selecting using different columns from the table:

l1	v1	l2	v2	l3	v3
1_One	1	2_One	100	3_One	1000
1_Two	2	2_Two	101	3_Two	1003
1_Three	3	2_Three	102	3_Three	1003

[{"l1":"1_One","v1":"1","l2":"2_One","v2":"100","l3":"3_One","v3":"1000"},{"l1":"1_Two","v1":"2","l2":"2_Two","v2":"101","l3":"3_Two","v3":"1003"},{"l1":"1_Three","v1":"3","l2":"2_Three","v2":"102","l3":"3_Three","v3":"1003"}]

[{"l2":"2_One","l1":"1_One","v1":"1","v2":"100","l3":"3_One","v3":"1000"},{"l2":"2_Two","l1":"1_Two","v1":"2","v2":"101","l3":"3_Two","v3":"1003"},{"l2":"2_Three","l1":"1_Three","v1":"3","v2":"102","l3":"3_Three","v3":"1003"}]

[{"l3":"3_One","l1":"1_One","v1":"1","l2":"2_One","v2":"100","v3":"1000"},{"l3":"3_Two","l1":"1_Two","v1":"2","l2":"2_Two","v2":"101","v3":"1003"},{"l3":"3_Three","l1":"1_Three","v1":"3","l2":"2_Three","v2":"102","v3":"1003"}]

Test some error conditions:

No datatable2 name given:

Non-exisistent table:

Bad column names:

[{"l2":"2_One","l1":"1_One","v1":"1","v2":"100","l3":"3_One","v3":"1000"},{"l2":"2_Two","l1":"1_Two","v1":"2","v2":"101","l3":"3_Two","v3":"1003"},{"l2":"2_Three","l1":"1_Three","v1":"3","v2":"102","l3":"3_Three","v3":"1003"}]