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).

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!

HitmanInWis’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.

HitmanInWis’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.

wayaslij’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

StatusFileSize
new90.13 KB
new27.85 KB
new23.69 KB

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