1 Reply Latest reply: Oct 15, 2013 5:32 PM by shwa999 RSS

    Resource handler query capabilities

    shwa999

      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