The community member is experiencing issues with the JsonQueryEngine when trying to query a JSON structure that is more complex than basic retrieval. They have provided a detailed schema with informative field descriptions, but the engine is still building what it considers to be invalid JSON paths and throwing exceptions. The community member is using GPT-3.5 as the language model and is unsure if the JsonQueryEngine is only suited for very basic, exact JSON path retrieval, or if they have misconfigured it or the data in some way.
I've run into some issues with JsonQueryEngine building what it sees as invalid JSON paths and throwing exceptions whenever I try to query the provided JSON structure for information just slightly more complex than a basic retrieval. See attached screenshot - tried to just get a count of an array of objects, yielding the path $.projectsHiredFor.length(), which failed. This is a very simple example, I've run others that fail similarly, and some don't fail but are very clearly incorrect.
We've given a detailed schema with informative field descriptions, but it doesn't seem to help. We're using GPT-3.5 as the LLM.
Is JsonQueryEngine only suited to very basic, exact JSON path retrieval, or have we misconfigured it or the data in some way?
