[WebDNA] JSONStore Levels
This WebDNA talk-list message is from 2020
It keeps the original formatting.
numero = 115089
interpreted = N
texte = 2718 Hi all, I=E2=80=99m looking at the docs for the JSONStore context. It seems = that either the context is lacking functionality or the documentation = is. I do not see a way to access nested levels in the JSON, like can be = done with XML using path=3D0:1:2 for example. Seems like there should = be a way to use dot notation to get at nested data without storing each = array in a temp db, then reparsing each level with JSONStore into = another temp db, etc. For example: I want to iterate the data sets in the =E2=80=9Cresults=E2=80= =9D array into a database. I can use JSONStore to populate a table with = the fields: page, total_results, total_pages and results. Then I can = search that table and run JSONStore on the results field using another = database, but this gets a bit complicated when working with some other = data, in which I need to access data that is 3 or 4 arrays deep. Anyone solved this puzzle in a more efficient way yet? { "page":1, "total_results":21, "total_pages":1, "results=E2=80=9D:[ { "popularity":1.936,"vote_count=E2=80=9D:7 }, { "popularity=E2=80=9D:2.732,"vote_count=E2=80=9D:23 }, { "popularity=E2=80=9D:12.088,"vote_count=E2=80=9D:75 }, { "popularity=E2=80=9D:53.221,"vote_count=E2=80=9D:5 }, { "popularity=E2=80=9D:7.001,"vote_count=E2=80=9D:31 }, { "popularity=E2=80=9D:22.223,"vote_count=E2=80=9D:88 } ] } MD= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us .
Associated Messages, from the most recent to the oldest:
2718 Hi all, I=E2=80=99m looking at the docs for the JSONStore context. It seems = that either the context is lacking functionality or the documentation = is. I do not see a way to access nested levels in the JSON, like can be = done with XML using path=3D0:1:2 for example. Seems like there should = be a way to use dot notation to get at nested data without storing each = array in a temp db, then reparsing each level with JSONStore into = another temp db, etc. For example: I want to iterate the data sets in the =E2=80=9Cresults=E2=80= =9D array into a database. I can use JSONStore to populate a table with = the fields: page, total_results, total_pages and results. Then I can = search that table and run JSONStore on the results field using another = database, but this gets a bit complicated when working with some other = data, in which I need to access data that is 3 or 4 arrays deep. Anyone solved this puzzle in a more efficient way yet? { "page":1, "total_results":21, "total_pages":1, "results=E2=80=9D:[ { "popularity":1.936,"vote_count=E2=80=9D:7 }, { "popularity=E2=80=9D:2.732,"vote_count=E2=80=9D:23 }, { "popularity=E2=80=9D:12.088,"vote_count=E2=80=9D:75 }, { "popularity=E2=80=9D:53.221,"vote_count=E2=80=9D:5 }, { "popularity=E2=80=9D:7.001,"vote_count=E2=80=9D:31 }, { "popularity=E2=80=9D:22.223,"vote_count=E2=80=9D:88 } ] } MD= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us .
Michael Davis
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Moving a record from one dataabse to another. (2000)
AddLineItem Problem (1997)
RE: Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
Generating unique SKU from [cart] - FIXED! (1997)
Generating Report Totals (1997)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)
Who owns the code? (2002)
ACGI processing for .html (1997)
Database of Tax Rates? (1997)
Banners (1997)
UPPERCASE (1997)
Plugin or CGI or both (1997)
MySQL and Numbers (2005)
[WebDNA] Version 7.x: webdna.ini and EmailerPrefs (2012)
Sitebuilder (2004)
Can a Get or Post throw off a Ping? (1998)
Simple Database close connection (2001)
no [search] with NT (1997)
[WebDNA] making a gift cert. (in effect) it's own lineitem/'product' with negative price - pros/cons? (2008)
using showpage and showcart commands (1996)