Passing an SQL into a REST Request, and returning Result in JSON Dataset?

[Robert Gilland 5]

Can I passing an SQL (select Statement )into a REST Request to a Rest Server , and receive a result in a JSON Dataset?

Can I pass an INSERT/UPDATE/DELETE Statement into a Rest Request?

[haentschman 92]

Hi...😎

how about: TMS XData: Accessing any database with SQL queries via the TMS XData REST server

 https://www.youtube.com/watch?v=2SCvzw0L27o&ab_channel=tmssoftwareTV  

[Lars Fosdal 1864]

7 hours ago, Robert Gilland said:

Can I passing an SQL (select Statement )into a REST Request to a Rest Server , and receive a result in a JSON Dataset?

Can I pass an INSERT/UPDATE/DELETE Statement into a Rest Request?

Short answer:

Yes

 

Long answer:

Yes, but don't! It would put your SQL database at risk.

 

Instead, build a proper REST API as

- it hides the underlying database

- it allows you to change the underlying database operations without changing the client

A REST API done right is far more secure and robust.