Databases
StackOverflow2013
Postsdbo
PONavigating through JSON with JavaScript
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONavigating through JSON with JavaScript
    primarykey
    data
    text
    <p>OK, I have been searching through this site to find anything similar or enlightening, but I am completely stuck. I am getting some valid JSON and need to parse through it to extract prices. I'm not getting very far.</p> <p>Here's the JSON:</p> <pre><code>{ "result": "success", "prices": { "vdc": { "monthly": "1.00" }, "network": { "private": { "monthly": "2.00" }, "public": { "\/22 (1,111 IP Addresses)": { "monthly": "3.00" }, "\/21 (2,222 IP Addresses)": { "monthly": "4.00" }, "\/20 (3,333 IP Addresses)": { "monthly": "5.00" }, "\/19 (5,555 IP Addresses)": { "monthly": "6.00" }, "\/18 (6,666 IP Addresses)": { "monthly": "7.00" }, "\/17 (7,777 IP Addresses)": { "monthly": "8.00" }, "\/16 (8,888 IP Addresses)": { "monthly": "9.00" }, "\/25 (111 IP Addresses)": { "monthly": "10.00" }, "\/26 (55 IP Addresses)": { "monthly": "11.00" }, "\/27 (22 IP Addresses)": { "monthly": "12.00" }, "\/28 (11 IP Addresses)": { "monthly": "13.00" }, "\/29 (5 IP Addresses)": { "monthly": "14.00" }, "\/23 (900 IP Addresses)": { "monthly": "15.00" }, "\/24 (333 IP Addresses)": { "monthly": "16.00" } } }, "blocks": { "22": { "monthly": "17.00" }, "21": { "monthly": "18.00" }, "20": { "monthly": "19.00" }, "19": { "monthly": "20.00" }, "18": { "monthly": "21.00" }, "17": { "monthly": "22.00" }, "16": { "monthly": "23.00" }, "25": { "monthly": "24.00" }, "26": { "monthly": "25.00" }, "27": { "monthly": "28.00" }, "28": { "monthly": "29.00" }, "29": { "monthly": "30.00" }, "23": { "monthly": "24.00" }, "24": { "monthly": "25.00" } }, "server": { "cpu": { "monthly": "26.00" }, "ram": { "monthly": "27.00" } }, "volume": { "gb": { "monthly": "28.00" } }, "snapshot": { "gb": { "monthly": "29.00" } } } } </code></pre> <p>Tested and validated at jsonlint [dot] com.</p> <p>After much trying, testing, trying, banging head against my keyboard, trying...this is what I currently have, but it's not producing the desired results (I'll tell you what those are, right after the code snippet).</p> <pre><code>function gp(x){ for(var i in x){ console.log('700: ', x[i] ); if(x[i] != 'success'){ console.log(733); console.log(x[i]); for(var j in x[i]){ console.log(736); console.log(x[i][j]); } } } } </code></pre> <p>In the console, I see something like this:</p> <p><img src="https://i.stack.imgur.com/uL1SP.png" alt="enter image description here"></p> <p>What I really would like to see (or find or parse to) is, for example, the monthly price for "gb" from the "volume" element (or is it an item?).</p> <p>Ideally, I would like to find "volume", "ram" and "cpu" – verify that it's the volume, ram and cpu – then get the monthly price. I did try a few things with JSON parsing, but obviously, I haven't mastered that quite yet either.</p> <p>Any help would be greatly appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USxivo
    1. USAce
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONavigating through JSON with JavaScript
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. PONavigating through JSON with JavaScript
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI think you're talking about *navigating* an object, not *parsing*. The word "parse" is about interpreting a string to recognize a syntax. It looks like you've already had your JSON string parsed into an object.
      singulars
      1. PONavigating through JSON with JavaScript
      1. USPointy
    2. COSo I should look for help with navigating an object then, right. OK. I really appreciate your feedback. Thanks.
      singulars
      1. PONavigating through JSON with JavaScript
      1. USAce
    3. COhow did you get your json in the first place. is it by using ajax or post or what exactly. knowing that might help to post a suitable answer for you
      singulars
      1. PONavigating through JSON with JavaScript
      1. USmamdouh alramadan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload