Building JSON data exchange project using JDE wizard

JDE project creates a gateway for serving data stored in your Excel Sheet or Access Table as a JSON document that can easily be fetched using AJAX with JavaScript or jQuery.

Building a JDE project is very easy and it can be split in few simple steps:

  1. Select the Excel Workbook or Access database
  2. Select the sheet or table
  3. Select the fields/cells you want to include in JSON document
  4. Rename keys for each field/cell. This is not required.
  5. Rename record count key and records array. This is optional step. You can use the default values unless your front-end requires some specific names.
  6. Click "Save and deploy” button

Upon deploying JDE, you’ll note that there is no embed code (neither IFRAME nor SCRIPT), no codes for Joomla and WordPress plugins, practically nothing but a link code and data preview.

It is because JDE belongs to professional projects and as such provides really unlimited options for using extracted data in your projects. Therefore, it makes no sense to build embed code that would limit that usage. Instead, we will teach you step by step how to use it in a few blog articles. First one you can find here.