Can Anybody give some clues of how to build JSON as the source for data and build metadata with that?

-- Can the physical layer even connect to data in JSON format?
-- If so can it query it back and forth and apply filters dynamically?
-- If Not, can BIEE connect to, JSON converted to XML as a source and query that?

Any suggestions on how to capture data in JSON format and report in BIEE