root element attribute of xml file to be extracted using javascript

Question

How to get the root element attribute from an XML file URL and pass as a bootstrap table data?

Javascript has to be used to do the above task. URl: http://xxxxxx/y.xml

For example:

<xxx-yyyyy zzzzzzz="2016-11-03T06:34:59+02:00">

I want to get the date in this root element.

Please help

Can you add your XML data too? and what is the expected result of it.. — Rajshekar Reddy, Nov 04 '16 at 06:09
is it in a external file or already loaded into the DOM? also are you using jquery or only javascript? — Rajshekar Reddy, Nov 04 '16 at 06:10
Can you show your complete URL? add the details into the question rather than in comments — Rajshekar Reddy, Nov 04 '16 at 06:11
@sindhu if its confidential then you can remove the confidential data or replace it with some junk characters and provide.. With out the complete information I think its difficult to even start thinking about a solution — Rajshekar Reddy, Nov 04 '16 at 06:14
So when you hit that URL you will get a XML data which you need to parse right? — Rajshekar Reddy, Nov 04 '16 at 06:15
Exactly. And it seems data is not in url but we need to fetch data from URL - Am I right? — Pedram, Nov 04 '16 at 06:15
@sindhu any chance that you can use Jquery ? or do you require solution in pure javascript? — Rajshekar Reddy, Nov 04 '16 at 06:18

Rajshekar Reddy · Answer 1 · 2016-11-04T07:11:38.530

1

First you need to do a AJAX call to fetch the data from your xml file.
Second inside your success method you will receive the XML data, you need to parse this data using $.parseXML() and then convert it into a jquery object using $(yourXML) after that its simple as working on your DOM objects.
You can read the attribute using the .attr() function.

Below is the example code, (here is a fiddle which demonstrates working with xml data in jquery)

$(function(){  // alternate syntax for $(document).ready(function(){..
    $.ajax({
      type: "GET" ,
      url: "http://xxxxxx/y.xml" ,
      dataType: "xml" ,               // make sure to set the dataType to xml
      success: function(xml) {

        var xmlDoc = $.parseXML(xml); //Parse the givn XML
        var $xml = $(xmlDoc);         // convert XML into jquery object
        var creationDate = $xml.find("ris-metadata").attr('creation');
        alert(creationDate);          // this will give you the required data.

        // this will update the second column data of the first row.
        $('#yourTableId tbody td:eq(1)').text(creationDate); 
       }
    });
});

edited Nov 04 '16 at 07:11

answered Nov 04 '16 at 06:34

Rajshekar Reddy

18,647
3
40
59

At what instance do you want to update this data into the table? like on page load? on button click? anything else? – Rajshekar Reddy Nov 04 '16 at 06:36
`$('#yourTableId tr td:eq(1)').text(creationDate )` .. this will add the data into the second column and all the rows.. I can provide exact code if you can share your table structure.. update the question – Rajshekar Reddy Nov 04 '16 at 06:41
So you will have only one row all the time? if not then which row must be update with the date? – Rajshekar Reddy Nov 04 '16 at 06:45
`can json be used for the second column too??` you can update your json with new value and then build the tbody – Rajshekar Reddy Nov 04 '16 at 06:45
add a id to the table and use the code which I have provide.. I have updated my answer – Rajshekar Reddy Nov 04 '16 at 06:47
1

Great efforts you @Reddy did (y) – Pedram Nov 04 '16 at 06:49
@pedram thanks mate.. My name is Raj too, but I dont belive in god :p – Rajshekar Reddy Nov 04 '16 at 06:50
@sindhu - you should not only mark it as answer - you should also do upvote ;) – Pedram Nov 04 '16 at 06:50
@Reddy - okay on facebook or so? Coz I don't remember if I have written like "I believe in God" on so. – Pedram Nov 04 '16 at 06:54
1

@sindhu you need to change that url to what ever you wanted to use. i think thats the issue.. Also check your console window for any errors, Also i have updated my code to wrap it around a `$(function(){...})` – Rajshekar Reddy Nov 04 '16 at 06:55
1

@sindhu you have to tell me what the error is.. check your developer console window.. you can activate it by pressing F12. and see the tab named `console` – Rajshekar Reddy Nov 04 '16 at 06:56
@Reddy - ohk I got that ;) send me request we will be in touch :) – Pedram Nov 04 '16 at 06:56
@pedram i dont use twitter and Facebook.. I am only on linkedin – Rajshekar Reddy Nov 04 '16 at 06:57
@Reddy - okay I will send connection request. – Pedram Nov 04 '16 at 06:57
@pedram sure thing. – Rajshekar Reddy Nov 04 '16 at 06:57
1

@sindhu :) did you check your console window?? – Rajshekar Reddy Nov 04 '16 at 06:59
@Reddy - can't find you on LinkedIn :( – Pedram Nov 04 '16 at 07:00
1

@sindhu its not an error from the code I provided.. its saying `myFunction1` is not defined.. you'll have to check it yourself in your code.. – Rajshekar Reddy Nov 04 '16 at 07:03
`Unexpected token )` may be there is any extra `)` added while pasting my code.. if you click on the error it will take you to the code and point out the mistake. – Rajshekar Reddy Nov 04 '16 at 07:11
@sindhu yes, unless you have control over the other domain code. I am not sure with other approaches.. – Rajshekar Reddy Nov 04 '16 at 07:39
If you dont have control over the domain which you wish to communicate then you cannot do much about it. the other domain must grant you permission to communicate with it.. – Rajshekar Reddy Nov 04 '16 at 07:44
@sindhu I didnt get you. – Rajshekar Reddy Nov 04 '16 at 09:32
No, as far as I know. – Rajshekar Reddy Nov 04 '16 at 09:34
@sindhu can you confirm me what the response from the server is.. ie: check what is the value of `xml` variable in success function. – Rajshekar Reddy Nov 04 '16 at 09:53
1

you can place a debugger and inspect the value. you'll have to use developer window for that here http://stackoverflow.com/a/66431/2592042 – Rajshekar Reddy Nov 04 '16 at 10:01
I am not familiar with php but it should be possible, you can fetch that data in server side and then pass to your page.. So you will change the ajax call to call your server code which in turn will fetch data from that link and give you back. I know this can be done in .Net.. not sure how its done in php.. – Rajshekar Reddy Nov 04 '16 at 10:14
btw you didnt tell me the value of `xml` after success – Rajshekar Reddy Nov 04 '16 at 10:15
add this line of code inside your success method `debugger;` now open your developer window and execute the script (in your case reload the page.) the debugger will be hit and you can view the values in the variable. Or simply do a `alert(xml);` which is suitable only in few cases. – Rajshekar Reddy Nov 04 '16 at 10:28
ok so since its a object we cant see it properly in alert.. use the other way I mentioned. – Rajshekar Reddy Nov 04 '16 at 10:36
@sindhu so the response from the URL is not what you have posted in your question. If the response matches to what you have posted in the question this code will work. – Rajshekar Reddy Nov 04 '16 at 11:22
Yes and that is not the response which you said you will get. – Rajshekar Reddy Nov 04 '16 at 13:48
The comment you had put didn't seem to have the same response. – Rajshekar Reddy Nov 04 '16 at 15:20
@Sindhu there are many questions already on stack overflow addressing that issue. Have a check and if those are different from your scenario you can raise a new question. As far as this question is concerned I have given you a answer and if that answer solves the issue posted in this question you can mark it as answer. Have a great day – Rajshekar Reddy Nov 05 '16 at 11:27
Btw if you can use c# then there are libraries which can do this for you. – Rajshekar Reddy Nov 05 '16 at 11:31
There is something called WebClient in c# which is used to fetch data from other websites, https://www.dotnetperls.com/webclient – Rajshekar Reddy Nov 07 '16 at 07:06
@sindhu I am not into php, So I don't know if there exist any methods or not. You can try posting a question about the same. – Rajshekar Reddy Nov 07 '16 at 09:27

root element attribute of xml file to be extracted using javascript

1 Answers1