Introduction

Data Import & Export, Database Management, Data Reports, Users Import & Export

Export any table to JSON: transform your Joomla Database into a JSON API

  • Favourite
  • Report

Export any table to JSON: transform your Joomla Database into a JSON API!

Pick one or more tables you want to expose, and enable them in the admin interface

That's it! Then just call index.php?option=comjsonexport&table=yourtable

Export any custom SQL query

How?

Create a MySQL View and execute any SQL query you want

The result will be exportable like a normal table.

Major advantages provided

  • choose which tables you want
  • optionally add a password to protect your data
  • select all fields (*), or just a few
  • set LIMIT and OFFSET parameters to the query URL to paginate the results

The results are sent using JSON to the requester.

Examples of what can it be used for

  • Integration with other sites
  • Create an API
  • Integrations with ecommerce tools: extract your orders!
  • Create email lists
  • Backup and export data
  • Sync with other software or websites
  • Basically any custom integration you might think of.
83
84
Functionality

Does the job - exports the JSON

92
Ease of use

Fairly easy to use

80
Support
76
Documentation
85
Value for money

Ok

I used this to: I take the export then open it with the best JSON online viewer: http://www.jsondata.ninja
100

A unique joomla extension that lets you export site data in JSON format. Although, I modified the extension to export as JSONP (for cross domain purposes); without needing assistance. Easily extensible.



It will be perfect if we could choose the rows that we want exporting (JOINs) to save user bandwidth (as there is no point in downloading the whole *_content table if our app only needs two rows.).

100

Brilliant


Posted on 01 June 2013

Installed, enabled the exporting of the table I needed, and my custom integration worked in a few minutes! Highly recommended to get JSON out of the Joomla database. Couldn't be easier, thanks!

Map Locations Map Locations
Paid download

Map Locations

By joocode
Maps & Locations
The most powerful maps extension for Joomla!. Provides over 130 different map designs, multiple maps, places listing, responsive design, custom markers, Street View and more! Provides over 130 different map designs Create multiple maps Responsive design Over 700 custom markers already included - and you can upload your own! Add places from our modern admin interface that shows the list of pla...
CSV Export CSV Export
Paid download

CSV Export

By joocode
Data Import & Export
Get your data in CSV format Export any table to CSV: transform your Joomla Database into a Excel file or Google Spreadsheet! How? Pick one or more tables you want to expose, and enable them in the admin interface That's it! Then just call index.php?option=comcsvexport&table=yourtable Export any custom SQL query How? Create a MySQL View and execute any SQL query you want The result will be...

JSON Export

Version:
2016.12.05
Developer:
joocode
Last updated:
May 23 2017
Date added:
Nov 19 2014
License:
GPLv2 or later
Type:
Paid download
Includes:
c
Compatibility:
3
Download

Uses Joomla! Update System

Score:


Write a review