Does anyone know of any modules out there that would allow creation of a view with source data being JSON or XML retrieved from a web service? I have a situation with a "central" drupal site, and then multiple client drupal sites that want to get data from the central site. I can return the data from the central site as JSON via the Services module combined with the Views Datasource and REST Server modules, but then I lose the ability to leverage the power of views (like automatic pagination for instance).

Members fund testing for the Drupal project. Drupal Association Learn more

Comments

srebelo’s picture

Hello!

There is a module that exports views in several types, including XML - http://drupal.org/project/views_data_export

I hope it helps!

brettbirschbach’s picture

Thanks srebelo, but in this case I'm looking for the exact opposite. I want to create a view that can *consume* JSON/XML instead of produce it.

dawehner’s picture

Status: Active » Fixed

In general you can only use pluggable query backends in views3 and above.

There is one for xml: http://drupal.org/project/xml_views
But there is none for json.

brettbirschbach’s picture

Thank you for the reply. I'll have to take a look.

Status: Fixed » Closed (fixed)

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

andrewfn’s picture

Version: 6.x-2.9 » 7.x-3.x-dev
Status: Closed (fixed) » Active

I would be very interested in such a feature--it seems to be the missing part of the picture. You suggest this is possible in Views 3? This looks similar to this issue for the Web service client module: #1215570: Views Integration for 'Web service client' module

dawehner’s picture

Well the views module provides you a sane api to provide such an integration, but this will probably not land in views itself, because it's kind of an api module.

@see above with xml_views.

adrien.felipe’s picture

I would say you can also use feeds to import nodes from the json or xml and then display them with a view

dawehner’s picture

There was even a google summer of code project to use a views-query-backend to import data via feeds :)

nw’s picture

So as far as I can tell, the current state of art is:

* Views 3 has a pluggable query back end:
* GSoC proposal for "Views Query Backends" at http://groups.drupal.org/node/57168 but no evidence there of the project having started up
* YQL Views Query (http://drupal.org/project/yql_views_query). A GSoC 2010 project which stagnated over a year ago. Drupal 7/ Views 3.
* XML Views (http://drupal.org/project/xml_views). Stagnated about a year ago. Drupal 6/Views 3
* WS Client (http://drupal.org/project/wsclient) is a nice D7 module, which wraps around external SOAP & REST services. It could act as a data provider for Views 3, but I've seen no evidence of an implementation.

martinbutt’s picture

Hi,

I have set up a group for discussing how we could bring this to life. Your input is appreciated.

http://groups.drupal.org/views-web-service-input

Cheers,
Martin

dropchew’s picture

This should do it.

http://drupal.org/project/views_xml_backend

Does anyone know if there's a similar module or in the works for json...?

clevername’s picture

Category: support » feature
Priority: Normal » Minor

I'm sponsoring a project for plugging in JSON Web Services into the Views backend. If anyone is interested, here's the link: http://www.freelancer.com/projects/PHP-AJAX/Drupal-JSON-Views-Module.html

I'll post an update here once the project evolves.

yarco’s picture

Oh, my friend. I comes from freelancer (or from drupal long time ago).

I did a half done work. See the image:
Json Data:
Json Data
Configure Field:
Configure field
View:
View

You could see currently it doest support filter etc. Only a very basic version......

clevername’s picture

Great, here's the link to the sandbox page if you want to upload to git: http://drupal.org/sandbox/clevername/1630546

JayShoe’s picture

There is a similar project which uses "web service client" and a sandbox called "web service client views". You can see the details here.

Web Service Client Views

Pasqualle’s picture

another sandbox for json backend https://drupal.org/sandbox/marcofernandes/2096685

discipolo’s picture