Skip to main content
ishrivastava-21-Visitor
1-Visitor
August 8, 2016
Question

Sql query result to infotable or property

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.

    1 reply

    Aanjan5-Regular Member
    5-Regular Member
    August 8, 2016

    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.

    Translate
    Terms & ConditionsAccessibility statement