What is the proper way to retrieve the value of the key "order" from this JSON object (containing semicolons in the name)?

Question

What is the proper way to retrieve the value of the key "order" from this JSON object (containing semicolons in the name)?

Vijay Anand inquired about this particular matter yesterday, unfortunately, the discussion was closed before receiving any solutions:

HTTP Response:

{
  "entry": {
    "@xml:base": "https://API_PROC_SRV/",
    "@xmlns": "http://www.w3.org/2005/Atom",
    "@xmlns:m": "http://schemas.microsoft.com/ado/2007/08/dataservices/metadata",
    "@xmlns:d": "http://schemas.microsoft.com/ado/2007/08/dataservices",
    "id": "https://API_PROC_SRV/A_Order",
    "title": {
      "@type": "text",
      "#text": "A_Order()"
    },
    "updated": "2020-02-29T07:33:28Z",
    "category": {
      "@term": "Type",
      "@scheme": "http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"
    },
    "link": [],
    "content": {
      "@type": "application/xml",
      "m:properties": {
        "d:Order": "123456789"
      }
    }
  }
}

Javascript code:

var json = response;
var order = json.object.entry.content['m:properties']['d:Order']; // Attempting to retrieve Order details from the above response.

Error (for example, jsbin.com):

"TypeError: Cannot read property 'entry' of undefined
    at null.js:27:25
    at https://static.jsbin.com/js/prod/runner-4.1.7.min.js:1:13924
    at https://static.jsbin.com/js/prod/runner-4.1.7.min.js:1:10866"

According to JSLint, the JSON response is valid.

json.object.entry appears to be incorrect ... however

Q: What is the correct syntax in Javascript to access the value of "order" (referred to as d:Order), particularly when both m:properties and d:Order contain colons in their names?

PS: I have suggested Vijay's original enquiry for reopening ... although chances seem slim. Hence, my new question.

javascript json

Answer 1

Answer №1

To successfully extract the data, you must properly parse the JSON object. Keep in mind that there is no reference to an object property; instead, it should be json.entry.content.

response = `{
  "entry": {
    "@xml:base": "https://API_PROC_SRV/",
    "@xmlns": "http://www.w3.org/2005/Atom",
    "@xmlns:m": "http://schemas.microsoft.com/ado/2007/08/dataservices/metadata",
    "@xmlns:d": "http://schemas.microsoft.com/ado/2007/08/dataservices",
    "id": "https://API_PROC_SRV/A_Order",
    "title": {
      "@type": "text",
      "#text": "A_Order()"
    },
    "updated": "2020-02-29T07:33:28Z",
    "category": {
      "@term": "Type",
      "@scheme": "http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"
    },
    "link": [],
    "content": {
      "@type": "application/xml",
      "m:properties": {
        "d:Order": "123456789"
      }
    }
  }
}`;
var json = JSON.parse(response);
var order = json.entry.content['m:properties']['d:Order'];
console.log(order);

Answer 2

To successfully extract the data, you must properly parse the JSON object. Keep in mind that there is no reference to an object property; instead, it should be json.entry.content.

response = `{
  "entry": {
    "@xml:base": "https://API_PROC_SRV/",
    "@xmlns": "http://www.w3.org/2005/Atom",
    "@xmlns:m": "http://schemas.microsoft.com/ado/2007/08/dataservices/metadata",
    "@xmlns:d": "http://schemas.microsoft.com/ado/2007/08/dataservices",
    "id": "https://API_PROC_SRV/A_Order",
    "title": {
      "@type": "text",
      "#text": "A_Order()"
    },
    "updated": "2020-02-29T07:33:28Z",
    "category": {
      "@term": "Type",
      "@scheme": "http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"
    },
    "link": [],
    "content": {
      "@type": "application/xml",
      "m:properties": {
        "d:Order": "123456789"
      }
    }
  }
}`;
var json = JSON.parse(response);
var order = json.entry.content['m:properties']['d:Order'];
console.log(order);

What is the proper way to retrieve the value of the key "order" from this JSON object (containing semicolons in the name)?

Answer №1

Similar questions

Focusing solely on the data table by performing a lookup using the keyword "list"

I am wondering if it is feasible for a POST route to invoke another POST route and retrieve the response ('res') from the second POST in Express using Node.js

Capture and set the new value of the Datetime picker in MUI upon user's acceptance click

Using jQuery to retrieve a file that has been uploaded through an input field with the type of 'file'

Ensure password confirmation is correct

Receive a warning in the Heroku log stating "(node) sys is outdated. Util should be used instead" while the script is executed

Having trouble with the "initSdk" property being undefined in your React Native Appsflyer integration?

The localStorage is currently being updated, however there seems to be an issue with the output where false is being mistakenly interpreted

Debugging the Force-Directed D3 Graph

Uploading information to a server using Angular.js

Managing traffic in Google Kubernetes Engine (GKE)

Multi-line input in ExtJs

Is there a delay in Javascript identifying user existence when retrieving values from ajax?

Having trouble with the Keydown event - the image isn't moving as expected

Dealing with errors effectively in AngularJS $http requests

Is it possible to import files in Vue JavaScript?

Properly handling the use of single and double quotation marks in variable declarations within a JavaScript file

Store information in Factory and retrieve it in the controller

Language for describing JSON data structures

What could be causing my array to update when the method is called live but not during unit tests?