Using Node.JS, how do I read a JSON file into (server) memory?
Asked Answered
U

14

852

Background

I am doing some experimentation with Node.js and would like to read a JSON object, either from a text file or a .js file (which is better??) into memory so that I can access that object quickly from code. I realize that there are things like Mongo, Alfred, etc out there, but that is not what I need right now.

Question

How do I read a JSON object out of a text or js file and into server memory using JavaScript/Node?

Unipod answered 4/4, 2012 at 12:22 Comment(0)
S
1544

Sync:

var fs = require('fs');
var obj = JSON.parse(fs.readFileSync('file', 'utf8'));

Async:

var fs = require('fs');
var obj;
fs.readFile('file', 'utf8', function (err, data) {
  if (err) throw err;
  obj = JSON.parse(data);
});
Swinson answered 4/4, 2012 at 12:27 Comment(12)
I think JSON.parse is synchronous, its directly from v8, which means even with the Async way, people have to be careful with large JSON files. since it would tie up node.Neukam
For the sake of completeness. Their exists a npm called jsonfile.Alidis
what's wrong with this ? @Swinson Async-json-error gist codeNiigata
I cant believe it was so difficult to find this simple thing. Every answer I got from google was doing an HTTPRequest or using JQuery or doing it in the browserGrope
two points: (1) The synchronous answer should just be let imported = require("file.json"). (2) JSON.parse must be asynchronous, because I used this code to load a 70mb JSON file into memory as an object. It takes milliseconds this way, but if I use require(), it chugs.Clubby
One more point: this is async, but it isn't streaming. For that, you'll need a library (e.g., Oboe.js). The difference is async won't block your execution thread, but unless you're streaming you'll still see massive spikes in memory consumption (like 450mb of memory to process a 70mb JSON file).Clubby
@KyleBaker JSON.parse is synchronous. require just does a whole lot more than JSON.parse. JSON.parse is just parsing JSON. require is parsing JavaScript. I'm sure you can figure out why the latter is slower.Len
Great, Thank You :) i was trying with require("file.json") which was working fine but my file.json 's path was not fix for every os so it was failing now it works great. thanksTolerable
For people finding this answer in 2019 and on, Node.js has had native json support for many, many versions through require, with this answer is no longer being applicable if you just want to load a json file. Just use let data = require('./yourjsonfile.json') and off you go (with the booknote that if the performance of require is impacting your code, you have problems well beyond "wanting to load a .json file")Fosque
The asynchronous example is a bit deceiving, since you store the data in obj, which is not available for the rest of the running synchronous code. See: How do I return the response from an asynchronous call? The better option for the asynchronous example might be var fs = require("fs").promises then var pObj = fs.readFile("file").then(JSON.parse) where pObj is a promise containing the parsed JSON data when resolved.Dancy
This returns the buffer and not the file contents. does not answer the questionnCynosure
Would JSON.Parse have the advantage that it's not possible to inject actual javascript, whereas require does allow that?Mandeville
C
491

The easiest way I have found to do this is to just use require and the path to your JSON file.

For example, suppose you have the following JSON file.

test.json

{
  "firstName": "Joe",
  "lastName": "Smith"
}

You can then easily load this in your node.js application using require

var config = require('./test.json');
console.log(config.firstName + ' ' + config.lastName);
Compress answered 19/10, 2014 at 2:14 Comment(10)
Just so folks know, and if I remember correctly, require in node runs synchronously. Dive in deep hereKildare
@Ram It works for me may be your location of test.json would be different from his example. I am using node 5.0Mcintyre
Another issue/benefit with such method is the fact that required data is cached unless you specifically delete the cached instanceLorenzalorenzana
"require" is meant to be used to load modules or config file you are using through out the lifespan of your application. does not seem right to use this to load files.Froissart
I'd say this is potentially a security threat. If the json file you're loading contains JS code, would requireing it run that code? If so then you really need to control where your json files are coming from or an attacker could run malicious code on your machine.Delindadelineate
This is a sound solution for small DevOps scripts or batch operations. You have to balance human time with performance. As far as something you can commit to memory and use quickly for these appropriate cases, this is is tops. Not every task involves Big Data™ and hostile execution environments.Vertex
From the documentation, it looks like file with json extension will be parsed as text files, so would it still be secruity issue. nodejs.org/api/modules.html#modules_file_modulesStrictly
here's another good article to help you make an informed decisionAdjudication
@Strictly What kind of security issue exactly? My cursory experiments show that no code gets executed. Then, here's the part that loads the json file. JSONParse is probably obtained by copying the JSON.parse function. So I'd say it's safe to assume that requiring json files is okay securitywise (nothing gets executed).Larkspur
found this answer, and the file I wanted to try and load was called "test.json" nice work Travis you solved my exact request 2 years before I even knew I needed itLimulus
D
68

Answer for 2022, using ES6 module syntax and async/await

In modern JavaScript, this can be done as a one-liner, without the need to install additional packages:

import { readFile } from 'fs/promises';

let data = JSON.parse(await readFile("filename.json", "utf8"));

Add a try/catch block to handle exceptions as needed.

Diageotropism answered 12/3, 2021 at 15:25 Comment(4)
Where would you put the try catch?Rumba
I was looking for this, thank you! Works great when I know that the file's content is JSON data, but the extension is customized. The usual require('./jsonfile.xyz') cannot be used in this situation.Ranaerancagua
Why not use readFileSync and remove the await? JSON.parse(readFileSync("filename.json", "utf8"));Careen
Because file I/O can be (is) slow and if used in the synchronous manner, the server cannot do anything else in the meantime. See also #16827873Masto
R
62

Asynchronous is there for a reason! Throws stone at @mihai

Otherwise, here is the code he used with the asynchronous version:

// Declare variables
var fs = require('fs'),
    obj

// Read the file and send to the callback
fs.readFile('path/to/file', handleFile)

// Write the callback function
function handleFile(err, data) {
    if (err) throw err
    obj = JSON.parse(data)
    // You can now play with your datas
}
Rosio answered 4/4, 2012 at 12:33 Comment(3)
agreed :), added async as wellSwinson
Great :-) I don't like inline callbacks though, it can lead to callback nightmares that I'd rather avoid.Rosio
It's there for a reason.. unless you want it synchronously.Burkhard
E
57

At least in Node v8.9.1, you can just do

var json_data = require('/path/to/local/file.json');

and access all the elements of the JSON object.

Emergent answered 11/11, 2017 at 3:10 Comment(4)
This approach loads file only once. If you will change the file.json after new require (without restarting program) data will be from first load. I do not have source to back this, but I had this in app I am buildingKotick
Your answer is woefully incomplete. What that gets you is an object, and it doesn't even bother to implement tostring().Scrag
@DavidA.Gray The question wants to be able to access the objects as objects, not as strings. Asides from the singleton issue Lukas mentioned this answer is fine.Boyne
Using require will also execute arbitrary code in the file. This method is insecure and I would recommend against it.Cocaine
S
20

In Node 8 you can use the built-in util.promisify() to asynchronously read a file like this

const {promisify} = require('util')
const fs = require('fs')
const readFileAsync = promisify(fs.readFile)

readFileAsync(`${__dirname}/my.json`, {encoding: 'utf8'})
  .then(contents => {
    const obj = JSON.parse(contents)
    console.log(obj)
  })
  .catch(error => {
    throw error
  })
Soloman answered 31/8, 2017 at 12:36 Comment(4)
.readFile is already async, if you're looking for the sync version, its name is .readFileSync.Origin
If you want to use promises, there's also fs/promises as of Node 10. Note: the API is experimental: nodejs.org/api/fs.html#fs_fs_promises_apiMurrumbidgee
@Origin .readFile is asynchronous, but not async. Meaning, the function is not defined with async keyword, nor does it return a Promise, so you can't do await fs.readFile('whatever.json');Dillydally
@Dillydally how about a CodeSandBox?Origin
I
8

Using fs-extra package is quite simple:

Sync:

const fs = require('fs-extra')

const packageObj = fs.readJsonSync('./package.json')
console.log(packageObj.version) 

Async:

const fs = require('fs-extra')

const packageObj = await fs.readJson('./package.json')
console.log(packageObj.version) 
Inveracity answered 29/5, 2019 at 20:30 Comment(0)
J
7

using node-fs-extra (async await)

const readJsonFile = async () => {
    const myJsonObject = await fs.readJson('./my_json_file.json');
    console.log(myJsonObject);
}

readJsonFile() // prints your json object
Jamaaljamaica answered 9/7, 2019 at 13:18 Comment(0)
A
6

Answer for 2023, using Import Attributes

import jsObject from "./test.json" assert {type: "json"};
console.log(jsObject)

Dynamic import

const jsObject = await import("./test.json", {assert: {type: "json"}});
console.log(jsObject);

Further information: tc39 / proposal-import-attributes

Aerospace answered 25/11, 2022 at 9:8 Comment(0)
N
2

https://nodejs.org/dist/latest-v6.x/docs/api/fs.html#fs_fs_readfile_file_options_callback

var fs = require('fs');  

fs.readFile('/etc/passwd', (err, data) => {
  if (err) throw err;
  console.log(data);
});  

// options
fs.readFile('/etc/passwd', 'utf8', callback);

https://nodejs.org/dist/latest-v6.x/docs/api/fs.html#fs_fs_readfilesync_file_options

You can find all usage of Node.js at the File System docs!
hope this help for you!

Niigata answered 2/11, 2016 at 20:19 Comment(0)
V
2
function parseIt(){
    return new Promise(function(res){
        try{
            var fs = require('fs');
            const dirPath = 'K:\\merge-xml-junit\\xml-results\\master.json';
            fs.readFile(dirPath,'utf8',function(err,data){
                if(err) throw err;
                res(data);
        })}
        catch(err){
            res(err);
        }
    });
}

async function test(){
    jsonData = await parseIt();
    var parsedJSON = JSON.parse(jsonData);
    var testSuite = parsedJSON['testsuites']['testsuite'];
    console.log(testSuite);
}

test();
Validate answered 20/4, 2019 at 2:51 Comment(0)
B
0

So many answers, and no one ever made a benchmark to compare sync vs async vs require. I described the difference in use cases of reading json in memory via require, readFileSync and readFile here.

Buccinator answered 30/1, 2020 at 7:28 Comment(0)
M
0

with ECMAscript module the answer above middly work. For ECMAscript we would obtain something of the type:

(asynchronous 'cause I run it on my server to obtain data I need before running some functions)

import { readFile } from 'fs/promises';

function import_json(path){
  return new Promise(async (resolve,reject)=>{
    try{
      const jsonData = await readFile(path, 'utf8');
      console.log(jsonData)
      resolve(JSON.parse(jsonData))
    }catch(e){
      reject("Error from import_json(): " + e)
    }
  })
}

async function(){
  const my_awesome_data = await import_json("./example_data.json")
}
Muff answered 4/3 at 6:57 Comment(0)
E
-1

If you are looking for a complete solution for Async loading a JSON file from Relative Path with Error Handling

  // Global variables
  // Request path module for relative path
    const path = require('path')
  // Request File System Module
   var fs = require('fs');


// GET request for the /list_user page.
router.get('/listUsers', function (req, res) {
   console.log("Got a GET request for list of users");

     // Create a relative path URL
    let reqPath = path.join(__dirname, '../mock/users.json');

    //Read JSON from relative path of this file
    fs.readFile(reqPath , 'utf8', function (err, data) {
        //Handle Error
       if(!err) {
         //Handle Success
          console.log("Success"+data);
         // Parse Data to JSON OR
          var jsonObj = JSON.parse(data)
         //Send back as Response
          res.end( data );
        }else {
           //Handle Error
           res.end("Error: "+err )
        }
   });
})

Directory Structure:

enter image description here

Emergence answered 5/10, 2017 at 5:4 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.