Building JSON data exchange project using JDE wizard
TweetJDE 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:
- Select the Excel Workbook or Access database
- Select the sheet or table
- Select the fields/cells you want to include in JSON document
- Rename keys for each field/cell. This is not required.
- 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.
- 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.
Related blogs
Querying the data using JDE
In this article we’ll show practical use of dbBee_sql variable to filter the records using search criteria.