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.
- Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.
Import JSON from open RESTful API to MongoDB
Click “1 File To 1 Collection” at task dialog.
Select “Import File Type” with “JSON”, and 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 MongoDB collection.
4. Preview data will be in MongoDB collection.
5. Import RESTful API JSON to MongoDB.
See importing results in MongoDB collection
Import API JSON to MongoDB in command line
Save “API JSON to MongoDB” session, then you can:
- Convert API JSON to MongoDB in Windows command line.
- Convert API JSON to MongoDB in Linux command line.
- Convert API JSON to MongoDB in macOS command line.
Set scheduled tasks for importing API JSON to MongoDB
You can schedule and automate this “API JSON to MongoDB” conversion task by:
- Save session and create .bat (Windows) or .sh (Linux/macOS) file for “API JSON to MongoDB” conversion.
- Set scheduled task for “API JSON to MongoDB” conversion.