자바스크립트 JSON 데이터를 자바스크립트로 가져와 데이터베이스에 저장하는 방법

Fetching JSON Data

To fetch JSON data in JavaScript, we can use the fetch API. This API allows us to make HTTP requests and retrieve the response data. Here’s an example of how to fetch JSON data:

fetch('https://api.example.com/data')
  .then(response => response.json())
  .then(data => {
    // Handle the fetched JSON data here
  })
  .catch(error => {
    // Handle errors here
  });

In the example above, we use the fetch function to make a GET request to 'https://api.example.com/data'. The response is then converted to JSON format using the json() method.

Saving Data to a Database

To save the fetched JSON data to a database, we need to send it to a server-side script that can handle the database interaction. Let’s assume we have a server-side script written in JavaScript (e.g., using Node.js and Express) that handles the database operations.

First, make sure you have a database installed and set up. In this example, we’ll use MongoDB as our database.

Install the mongodb npm package by running the following command:

npm install mongodb

Next, we can connect to the MongoDB database and save the fetched JSON data. Here’s an example of how to do it using the mongodb package:

const { MongoClient } = require('mongodb');

// Connection URL
const url = 'mongodb://localhost:27017';

// Database Name
const dbName = 'mydatabase';

// Connect to the server and insert data
MongoClient.connect(url, { useUnifiedTopology: true }, (error, client) => {
  if (error) {
    // Handle connection errors
  } else {
    const db = client.db(dbName);

    // Insert the fetched data into a collection
    db.collection('mycollection').insertMany(data, (error, result) => {
      if (error) {
        // Handle insertion errors
      } else {
        console.log('Data saved successfully');
        client.close();
      }
    });
  }
});

In the example above, we establish a connection to the MongoDB server using the MongoClient.connect method. We then specify the database name and insert the fetched JSON data into a collection using the insertMany method.

Make sure to replace 'mongodb://localhost:27017' with the appropriate URL of your MongoDB server and 'mydatabase' with the name of your database.

Conclusion

In this blog post, we have learned how to fetch JSON data in JavaScript using the fetch API and save it to a MongoDB database using Node.js and the mongodb package. This technique can be used to retrieve data from APIs and store it in a database for further analysis or persistence.

Remember to handle errors appropriately and ensure that your server-side script has proper authentication and validation to prevent any security vulnerabilities.