using jQuery to get cross domain csv file

Question

I'm trying to load some .csv file from remote servers (so I have to deal with domain problem), and I'm using jsonp with the following code

sql="a csv file link"

$.ajax({
url:sql,
dataType:'jsonp',
}).done(function(){
    console.log("done");
}).error(function(){
console.log("err");
}).fail(function(){
console.log("fail");
}).success(function(){
console.log("success");
});

Some how, this piece of code gives me 2 different result.

1) On certain csv file links, it seems to be getting the complete csv file. However, there is an error saying that the csv file has a "syntax error", and .error and .fail is executed.

2) On some other csv file links (something like.http:// host.com:port/file.csv? select from table), somehow nothing happens. The .done/.success are not called, nor the .fail/.error are called

Can anyone tell me the solution or possible causes of those above problems?

Thanks!

Community · Accepted Answer · 2017-05-23 10:24:18Z

1

If the remore server allows JSONP, use something like the following:

sql="a csv file link"+"?callback=myFunc";

Where myFunc is a user defined function to process the data from the remote server.

Another technique is to use a proxy as described here: https://stackoverflow.com/a/2559062/1186628

[Update]

here is a very simple example of what myFunc might look like:

function myFunc(data){
     alert(data);
}

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Apr 5, 2013 at 20:06

mohamed elbou

1,8571 gold badge18 silver badges21 bronze badges

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

1 Comment

user1948847 Over a year ago

umm, could you give an example of the myFunc?? Really appreciated :)

Collectives™ on Stack Overflow

using jQuery to get cross domain csv file

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related