This discussion is archived
1 Reply Latest reply: Oct 15, 2013 3:32 PM by shwa999 RSS

Resource handler query capabilities

shwa999 Newbie
Currently Being Moderated

Hi all-

 

I hope this is an easy (yes you can, no you can't) question, but I can't seem to find an example anywhere.

 

Is it possible to create a resource handler that produces > 1 level if data using a sql query?  For example:

 

{

"name": "Google",

"location":

{

"street": "1600 Amphitheatre Parkway",

"city": "Mountain View",

"state": "California",

"country": "US"

},

"employees":

[

{

"name": "Michael",

"division": "Engineering"

},

{

"name": "Laura",

"division": "HR"

},

{

"name": "Elise",

"division": "Marketing"

}

]

}

 

To be clear, I'm looking for a) is this possible to create a resource handler that could produce this json doc via a sql query and, if so, b) where might I find an example to work from?

 

Thanks all-

-josh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points