Import API JSON data to MongoDB

by

Posted on by

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

Try Withdata FileToMongo, a JSON to MongoDB converter for Windows, MacOS, and Linux, Import API JSON to MongoDB, Easy and Fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Import JSON_API to MongoDB locally and privately, avoid uploading JSON_API file(s) to online services.
  • Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.
  • Support Windows, Linux, and macOS.

Download Withdata FileToMongo Download FileToMongo

Import JSON from open RESTful API to MongoDB

Click “1 File To 1 Collection” at task dialog.

Import JSON from open RESTful API To MongoDB collection - task window

Select “Import File Type” with “JSON”, and select “Source File From” with “Url”.

import API JSON to MongoDB collection - select type

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

import JSON from open RESTful API to MongoDB - download from RESTful API URL to JSON file

2. Open the saved JSON file.

import JSON from open RESTful API to MongoDB - open saved JSON file

3. Config target MongoDB collection.

import JSON from open RESTful API to MongoDB - config MongoDB collection

4. Preview data will be in MongoDB collection.

import JSON from open RESTful API to MongoDB - summary

5. Import RESTful API JSON to MongoDB.

import JSON from open RESTful API to MongoDB - import to MongoDB

See importing results in MongoDB collection

import JSON from open RESTful API to MongoDB - view MongoDB collection

More about JSON_API to MongoDB Converter