Ass title stated - Is there a way in thingworx to get rows of specific fields as result.
I have data table containing 10 fields. I queried the data table and assigned the resul output as infotable with another data shape that contains only two fields which I want to retrieve.
But when I execute the test service it returns all fields of data shape of data table. It ignores the data shape I have assigned as resultant output.
Please let me know if there is any way to select specific columns. Retrieval of all columns increase the content download time and lead for bad performance.
Use RemoveField snipped to not to output undesired fields.