JSON Query is a Views 3 plugin that adds native JSON query generation. It allows you to parse JSON using Views' graphical query builder.
It works much like Views XML Backend but with JSON.

Project link:

git clone --branch 7.x-1.x http://git.drupal.org/sandbox/marcofernandes/2096685.git


PA robot’s picture

Status: Needs review » Needs work

There are some errors reported by automated review tools, did you already check them? See http://pareview.sh/pareview/httpgitdrupalorgsandboxmarcofernandes2096685git

We are currently quite busy with all the project applications and we prefer projects with a review bonus. Please help reviewing and put yourself on the high priority list, then we will take a look at your project right away :-)

Also, you should get your friends, colleagues or other community members involved to review this application. Let them go through the review checklist and post a comment that sets this issue to "needs work" (they found some problems with the project) or "reviewed & tested by the community" (they found no major flaws).

I'm a robot and this is an automated message from Project Applications Scraper.

PA robot’s picture

Issue summary: View changes

Forgot the project links

marcofernandes’s picture

Status: Needs work » Needs review

Went through pareview.sh again and now it looks better. But there's some issues that I can't resolve because I'm following Views coding format.

marcofernandes’s picture

If someone wants to test but looking for a JSON service, here's one:
On query settings set Apath = geonames.

mozodev’s picture

I just tested this module with below json. (geoname api: quota exceeded)

On query settings set Apath = offer.

    "country": {
        "id": 29,
        "name": "Indonesia"
    "offer": [{
        "seller": {
            "name": "rockbein",
            "id": 2384
        "stock": 198,
        "price": 0.64,
        "currency": "IDR",
        "quality": 5
    }, {
        "seller": {
            "name": "The Private",
            "id": 1488
        "stock": 173,
        "price": 0.64,
        "currency": "IDR",
        "quality": 5
    "load": 0.360480070114

I tried to make my seller name field shown with key chooser: seller/name, but failed.
Any plan to support depth? if yes, $key should be inspected recursively, i think.

Also, when key is added on the field settings and cannot be found, it would be better to show or log errors.

Anyway nice module!

marcofernandes’s picture

Status: Needs review » Needs work

Hi mozodev.

Thanks so much for your review.

I was considering adding support to field depth on a later version but now I see that's necessary for this version. And you're also right about the error messages.

I'll set this issue to "needs work" for now.

marcofernandes’s picture

Status: Needs work » Needs review

Now with field depth support. Example (following mozodev test case): seller/name.
Error messages for now are not critical so back to "needs review".

mozodev’s picture

Status: Needs review » Reviewed & tested by the community

Just checked that field depth support is working properly..
I think field path should be validated when trying to add field...
Anyway that's ok for now.. it's not critical.. maybe good to go!

kscheirer’s picture

Status: Reviewed & tested by the community » Fixed

In your README, "usefull" should be "useful". Looks like a nice module, I couldn't find any problems.

Thanks for your contribution, marcofernandes!

I updated your account to let you promote this to a full project and also create new projects as either a sandbox or a "full" project.

Here are some recommended readings to help with excellent maintainership:

You can find lots more contributors chatting on IRC in #drupal-contribute. So, come hang out and get involved!

Thanks, also, for your patience with the review process. Anyone is welcome to participate in the review process. Please consider reviewing other projects that are pending review. I encourage you to learn more about that process and join the group of reviewers.

Thanks to the dedicated reviewer(s) as well.

Top Shelf Modules - Crafted, Curated, Contributed.

marcofernandes’s picture

Thank you @kscheirer. Typo fixed ;) .
Also many thanks to @mozodev for reviewing and for the Json source example :).

Full project here.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Anonymous’s picture

Issue summary: View changes

Change git url