calling SQL Server Endpoint web service

Question

I understand that SQL Server endpoint returns data using SOAP. Does anyone know if they can return JSON data? Thanks!

Answer 1

No, unfortunately they don't support JSON.

Answer 2

Native HTTP endpoints can only return SOAP messages.

However it's possible to switch off the generation of the SOAP envelope, if you specify FORMAT = NONE in the FOR SOAP section of the declaration. You could use this to provide an HTTP wrapper to your own stored procedure(s) which JSON-ise SQL server data (see books online for a detailed description of the very specific requirements your procedure must fulfill).

You should be aware that native endpoints are deprecated in SQL 2008.