From: Harris, B. T. (GSFC-5870) <ber...@na...> - 2023-01-26 18:57:49
|
And I still have the problem with <exist:json-ignore-whitespace-text-nodes value="yes" /> Bernie From: "Harris, Bernard T. (GSFC-5870)" <ber...@na...> Date: Thursday, January 26, 2023 at 1:52 PM To: Joe Wicentowski <jo...@gm...> Cc: Exist-open <exi...@li...> Subject: Re: [Exist-open] [EXTERNAL] json-ignore-whitespace-text-nodes I saw it but did not think it was applicable since I was not explicitly calling serialize. But just now, I added an extra line to my example <rest:response> <output:serialization-parameters> <output:method value="json" /> <output:json-ignore-whitespace-text-nodes value="yes" /> </output:serialization-parameters> <http:response> <http:header name="Content-Type" value="application/json" /> </http:response> </rest:response>, And reran the test. It does not change the output. I still get a bunch of “#text” stuff. Bernie From: Joe Wicentowski <jo...@gm...> Date: Thursday, January 26, 2023 at 1:42 PM To: "Harris, Bernard T. (GSFC-5870)" <ber...@na...> Cc: Exist-open <exi...@li...> Subject: Re: [Exist-open] [EXTERNAL] json-ignore-whitespace-text-nodes Hi Bernie, Did you by chance see my earlier response with links to code demonstrating how to use the json-ignore-whitespace-text-nodes property? Joe On Thu, Jan 26, 2023 at 1:32 PM Harris, Bernard T. (GSFC-5870) <ber...@na...<mailto:ber...@na...>> wrote: https://cdaweb.gsfc.nasa.gov/registry/hdp/restxqJson-0.1.xar contains an example app that demonstrates my problem. Once the application is install, $ curl http://localhost:8100/exist/restxq/test { "collection" : { "resource" : { "Spase" : { "xsi:schemaLocation" : http://www.spase-group.org/data/schema https://www.spase-group.org/data/schema/spase-2_4_0.xsd<https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.spase-group.org%2Fdata%2Fschema%2520https%3A%2Fwww.spase-group.org%2Fdata%2Fschema%2Fspase-2_4_0.xsd&data=05%7C01%7Cbernard.t.harris%40nasa.gov%7C8eef6bc44fc249de20b008daffccc15d%7C7005d45845be48ae8140d43da96dd17b%7C0%7C0%7C638103553796310665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=JDLepR8iMWsG2SJ8bXCDAatYqmV9Y8CReHu99XeqE7U%3D&reserved=0>, "#text" : ["\n ", "\n ", "\n" ], "Version" : "2.4.0", "NumericalData" : { "#text" : ["\n ", "\n ", "\n " ], "ResourceID" : "spase://NASA/NumericalData/ACE/CRIS/L2/PT1H", "ResourceHeader" : { "#text" : ["\n ", "\n ", "\n ", "\n " ], "ResourceName" : "ACE Cosmic Ray Isotope Spectrometer (CRIS) 1-Hour Level 2 Data", "DOI" : https://doi.org/10.48322/g72t-0814<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdoi.org%2F10.48322%2Fg72t-0814&data=05%7C01%7Cbernard.t.harris%40nasa.gov%7C8eef6bc44fc249de20b008daffccc15d%7C7005d45845be48ae8140d43da96dd17b%7C0%7C0%7C638103553796310665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=lGrJL%2BI77%2FMd%2F56pG93TJtx%2BxHHUNuFX7sfZMjUQAoA%3D&reserved=0>, "ReleaseDate" : "2022-05-17T12:34:56.789" } } } } } Demonstrates the problem. If you change the code to let $example := 2 so that the xml does not come from the db, the json will not contain all the “#text” stuff. Let me know if you need anything else. Thanks for looking at this. Bernie Harris From: "Harris, Bernard T. (GSFC-5870)" <ber...@na...<mailto:ber...@na...>> Date: Thursday, January 26, 2023 at 5:26 AM To: Joe Wicentowski <jo...@gm...<mailto:jo...@gm...>> Cc: Exist-open <exi...@li...<mailto:exi...@li...>> Subject: Re: [Exist-open] [EXTERNAL] json-ignore-whitespace-text-nodes I’m still attempting to reproduce in a minimal amount of code but it is taking a lot of time. But maybe just seeing the output will be enough for you to know what is wrong. This is a RESTXQ application and I first noticed the problem on exist 6.0.1 but have also now reproduced it on 4.4. Here is a little bit of the output $ curl -s -H "Accept: application/json" http://localhost:8100/exist/restxq/Spase/NumericalData?ResourceID=spase://NASA/NumericalData/ACE/MAG/L2/PT16S |jq |head -15 { "collection": { "resource": { "Spase": { "xsi:schemaLocation": http://www.spase-group.org/data/schema https://www.spase-group.org/data/schema/spase-2_3_2.xsd<https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.spase-group.org%2Fdata%2Fschema%2520%2520https%3A%2Fwww.spase-group.org%2Fdata%2Fschema%2Fspase-2_3_2.xsd&data=05%7C01%7Cbernard.t.harris%40nasa.gov%7C8eef6bc44fc249de20b008daffccc15d%7C7005d45845be48ae8140d43da96dd17b%7C0%7C0%7C638103553796310665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=fIKPZfwfeBYomcQtNKigX4mnl95WBz1z9WhoIKBsU6E%3D&reserved=0>, "#text": [ "\n ", "\n ", "\n" ], "Version": "2.3.2", "NumericalData": { "#text": [ "\n ", "\n ", The problem is all the extra #text values. They don’t appear in the xml output. Years ago when I developed something similar without RESTXQ, this declare option exist:serialize "json-ignore-whitespace-text-nodes=yes"; eliminated the extra #text stuff. But that does not work in my RESTXQ app. and it will take me more time to create a minimal RESTXQ example. I would apricate any help you can give but understand if you need example code. Bernie From: Joe Wicentowski <jo...@gm...<mailto:jo...@gm...>> Date: Wednesday, January 25, 2023 at 6:07 AM To: "Harris, Bernard T. (GSFC-5870)" <ber...@na...<mailto:ber...@na...>> Cc: Exist-open <exi...@li...<mailto:exi...@li...>> Subject: Re: [Exist-open] [EXTERNAL] json-ignore-whitespace-text-nodes Could you provide more info? How to reproduce? Expected vs. actual results? What version of eXist? On Wed, Jan 25, 2023 at 5:39 AM Harris, Bernard T. (GSFC-5870) via Exist-open <exi...@li...<mailto:exi...@li...>> wrote: I noticed the same thing. But I was working with RESTXQ (and exist-db 6.0.1) for the first time and thought I might need to do things differently than the way it had worked in the past. I would like to know if this is a bug or if there is a different way to accomplish the same thing. Bernie Harris From: Eduard Drenth <ed...@fr...<mailto:ed...@fr...>> Date: Sunday, January 22, 2023 at 11:22 AM To: Exist-open <exi...@li...<mailto:exi...@li...>> Subject: [EXTERNAL] [Exist-open] json-ignore-whitespace-text-nodes json-ignore-whitespace-text-nodes not supported anymore? Eduard Drenth, Software Architekt ed...@fr...<mailto:ed...@fr...> Doelestrjitte 8 8911 DX Ljouwert (058) 213 14 14 +31 62 094 34 28 https://www.fryske-akademy.nl/<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.fryske-akademy.nl%2F&data=05%7C01%7Cbernard.t.harris%40nasa.gov%7C8eef6bc44fc249de20b008daffccc15d%7C7005d45845be48ae8140d43da96dd17b%7C0%7C0%7C638103553796310665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=iKPW3w5hT7zCv%2F3FORRs7AbwmaNL%2F8Ll5EaNkkQIwns%3D&reserved=0> https://frysker.nl/<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffrysker.nl%2F&data=05%7C01%7Cbernard.t.harris%40nasa.gov%7C8eef6bc44fc249de20b008daffccc15d%7C7005d45845be48ae8140d43da96dd17b%7C0%7C0%7C638103553796310665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=9eMUDr0ES2uRkRPhhe%2FVP33hpglV1%2B8Q10JBfpWss6M%3D&reserved=0> https://frisian.eu/<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffrisian.eu%2F&data=05%7C01%7Cbernard.t.harris%40nasa.gov%7C8eef6bc44fc249de20b008daffccc15d%7C7005d45845be48ae8140d43da96dd17b%7C0%7C0%7C638103553796310665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=%2B0l%2FnBilBZdzESuGGLthhiE2DERf%2BKAvBwJm3V%2FBZ3U%3D&reserved=0> [cid:image001.png@01D9318E.2445EDE0] gpg: pgp.key-server.io/pks/lookup?search=eduarddrenth<https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpgp.key-server.io%2Fpks%2Flookup%3Fsearch%3Deduarddrenth&data=05%7C01%7Cbernard.t.harris%40nasa.gov%7C8eef6bc44fc249de20b008daffccc15d%7C7005d45845be48ae8140d43da96dd17b%7C0%7C0%7C638103553796310665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=ilxi51ZR4iMEUnOL4MxFWG0jyflw5fmnaGXqq5KYqqA%3D&reserved=0> _______________________________________________ Exist-open mailing list Exi...@li...<mailto:Exi...@li...> https://lists.sourceforge.net/lists/listinfo/exist-open<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fexist-open&data=05%7C01%7Cbernard.t.harris%40nasa.gov%7C8eef6bc44fc249de20b008daffccc15d%7C7005d45845be48ae8140d43da96dd17b%7C0%7C0%7C638103553796310665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=T4finZMlulTU9YjweRgqGS84auNJj9ehC3SoKcoJtZ4%3D&reserved=0> -- Sent from my iPhone |