Parse JSON from open RESTful API and save to MySQL without programming

by

Want to parse JSON from open RESTful API and save to MySQL database? Want to schedule and automate this importing task?

Using JsonToMysql, you can import JSON from open RESTful API to MySQL database easily and fast, and schedule and automate this importing task easily, no need to program, just a few mouse clicks!

Here you can download and install JsonToMysql.

Import JSON from open RESTful API to MySQL database

Click “Wizard For Importing” at task dialog.

Import Data From JSON To MySQL - task window

Select “Source File From” with “Url”.

import online RSS feeds to MySQL - select type

1. Input the RESTful API URL, and download to JSON file.

import JSON from open RESTful API to  MySQL database - download from RESTful API URL to JSON file

2. Open the saved JSON file.

import JSON from open RESTful API to  MySQL database - open saved JSON file

3. Config target MySQL database.

import JSON from open RESTful API to  MySQL database - config  MySQL table

You can create new MySQL table by JSON struct, just a few mouse clicks.

import online RSS feeds to MySQL - create MySQL table

Select table and config fields.

import online RSS feeds to MySQL - config MySQL fields

4. Summary.

import JSON from open RESTful API to  MySQL database - summary

5. Import.

import JSON from open RESTful API to  MySQL database - import to  MySQL database

See importing results in MySQL table

import JSON from open RESTful API to Excel file - view MySQL table

You can schedule and automate this importing task by:

1) Save session and create .bat file.

2) Set scheduled task.


More about JsonToMysql – the tool to import JSON from open RESTful API to MySQL database

30-day free trial Download JsonToMysqlUS$59.95 Buy JsonToMysql