Sql query result to infotable or property

[ishrivastava-2]

Hello,

I am writing sql query service to retrive data from database.I want to assign service  result to infotable and thing property.Can anyone tell me how to do that.

1. Sql query service result to infotable so that i can map those result to mashup.

2. Sql query service result to thing property.

[Aanjan]

Isha, you already have a Sql query service right? You can simply set the output of the service to INFOTABLE and then you can bind the result to a widget (be it List or Grid etc) in a Mashup. Make sure that the service type says 'Sql query' instead of the default 'Local (Javascript)'. If you are setting the values through a Mashup, you can call SetProperties in the Mashup Builder section for that specific Thing as well.