Withdata Software

Parse JSON from open RESTful API and save to Visual FoxPro

Want to parse JSON from open RESTful API and save to Visual FoxPro database?

Try Withdata FileToDB, a desktop JSON to Visual FoxPro converter for Windows, MacOS, and Linux, Import JSON to Visual FoxPro, Easy and Fast.

Download FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Import JSON from open RESTful API to Visual FoxPro database

Choose Visual FoxPro and logon.

Click “Wizard – 1 File To 1 Table” at task dialog.

Select “Source File From” with “Url”.

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

2. Open the saved JSON file.

3. Config target Visual FoxPro database.

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

Select table and config fields.

4. Summary.

5. Import RESTful JSON to Visual FoxPro.

See importing results in Visual FoxPro table

Import API JSON_API to Visual FoxPro in command line

Save “JSON_API to Visual FoxPro” session, then you can:

Set scheduled tasks for importing API JSON_API to Visual FoxPro

You can schedule and automate this importing task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “JSON to Visual FoxPro” conversion.
  2. Set scheduled task for “JSON to Visual FoxPro” conversion.

More about FileToDBJSON to Visual FoxPro converter