1

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

Improve this question

2 Answers 2

Reset to default
1

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

No, unfortunately they don't support JSON.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.