sql query service. no result in return while calling in mashup

[asekar]

i have an sql query service which returns me an infotable. the service is working fine. when I call the service in my mashup, there is no return data (expecting the result infotable)

[dupatel]

@asekar Is there any error in script or application log? Make sure you have bind the service invoke call with some event to trigger as sometime it happens the required service is not getting invoked/triggered .

-Durgesh

[asekar]

there isn't any error as such. I brought the same service in mashup but I don't see anything under returned data..

What do you mean by invoking the service ? I call the service in mashup which will in turn query from database

[asekar · Accepted solution]

the problem was resolved by associating a data shape to the sql service. One important thing that I noted here is that the field definitions on the data shape should match with the database column name. I'm not sure if this is mandatory though