Load external JSON file into HTML Table

Question

I tried to import a json file into my html table. But right now it is not working. I am not sure if the path is right written like that. Or what i am doing wrong. I really hope that someone cane help me.

My JSON file:

{
    "_id": "",
    "_rev": "",
    "geometry": {
        "coordinates": [],
        "type": ""
    },
    "type": "Feature",
    "properties": {
        "editor": "",
        "OS_Version": "",
        "Make_and_M": "",
        "title": "",
        "Name": "",
        "Species_Id": "",
        "timestamp": ""
    }
}

MY HTML Code:

$(function() {
    var people = [];
    $.getJSON('\\Users\\betzenben\\Dropbox\\Website\\test.json', function(json) {
        $.each(json.properties, function(i, f) {
            var tblRow = "<tr>" + "<td>" + f.title + "</td>" + "<td>" + f.Name + "</td>" + "<td>" + f.Species_Id + "</td>" + "<td>" + f.timestamp + "</td>" + "</tr>";
            $(tblRow).appendTo("#userdata tbody");
        });
    });
});

Do you get an error? What do you mean by "it is not working"? — pedromss
– pedromss, Commented Jan 18, 2016 at 16:09
Possible duplicate of Ajax in Jquery does not work from local file — SeinopSys
– SeinopSys, Commented Jan 18, 2016 at 16:23

lucian.nicolaescu · Accepted Answer · 2016-01-18 16:23:31Z

1

You need to have the file on your webserver. The file needs to be accessed like http://yourserver/file.json. Also, make sure your webserver supports the .json mime-type, otherwise use .js

You can access local files only if you are in back-end (nodejs for example), otherwise you can't.

Javascript is running on the client-side (in the browser), and you can't access the user filesystem (that will be a security issue)

answered Jan 18, 2016 at 16:23

lucian.nicolaescu

6473 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ben Over a year ago

Thank you i will do that

leguano · Accepted Answer · 2016-01-18 16:19:23Z

0

I think, you have to use jsonp to get access on a foreign domain (Same-Origin-Policy).

Hope this helps you.

answered Jan 18, 2016 at 16:19

leguano

1711 silver badge6 bronze badges

1 Comment

Jared Hooper Over a year ago

I don't think this applies. Check the URI: \\Users\\betzenben\\Dropbox\\Website\\test.json that looks like a folder

Collectives™ on Stack Overflow

Load external JSON file into HTML Table

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related