By Using below provided JSON structure you need write an api using node js and Express frame work. To perform below operation code example

Example: nodejs store json from web api

// NodeJS
const http = require("http");
var url = 'https://example.com/file.json'; // Request URL

http.get(url, function(res){
    var body = '';

    res.on('data', function(chunk){
        body += chunk;
    });

    res.on('end', function(){
        var data = JSON.parse(body); 
        console.log("Got a response: ", data.value);
    });
}).on('error', function(e){
      console.log("Got an error: ", e);
});