Make custom table data available as an Object to the javascript

Dominic Carvalho asked on January 12, 2019 10:35

Hey, I have a custom table with on column containing data, Is their a way to take all that data in the custom table and make it available as an object that I can manipulate with Javascript ?

Regards, Dominic

Recent Answers

Brenden Kehren answered on January 12, 2019 12:59

Use REST. Check out the documentation.

1 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on January 12, 2019 13:12 (last edited on January 12, 2019 13:32)

You can do in your SQL query with FOR JSON statement: SELECT * FROM yourtable FOR JSON AUTO. Then follow this example and return it to the client.

1 votesVote for this answer Mark as a Correct answer