Skip to main content
A
asekar5-Regular Member
5-Regular Member
December 12, 2018
Solved

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

  • December 12, 2018
  • 2 replies
  • 1895 views

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)

Best answer by asekar

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

2 replies

D
dupatel5-Regular Member
5-Regular Member
December 12, 2018

@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

A
asekar5-Regular MemberAuthor
5-Regular Member
December 12, 2018

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

A
asekar5-Regular MemberAuthorAnswer
5-Regular Member
December 13, 2018

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

Terms & ConditionsAccessibility statement