[MarkLogic Dev General] Using Json Extensions
Justin.Makeig at marklogic.com
Wed Mar 14 15:36:00 PDT 2012
Are you trying to convert XML to JSON? In your example, you’re calling fn:data() on the XML input. fn:data returns the atomic value of whatever you give it. In your case, you get back the text of all of your nodes as a single string. Calling xdmp:to-json on a string returns that string. In order to create nested JSON structures with xdmp:to-json, you’ll have provide it map:map instances <http://developer.marklogic.com:8040/5.0doc/docapp.xqy#search.xqy?query=map%3Amap<http://developer.marklogic.com:8040/5.0doc/docapp.xqy#search.xqy?query=map:map>>. Translating XML structures to JSON in the general case is actually pretty tricky business. Today, there’s an open-source, community-supported library called mljson <https://github.com/marklogic/mljson> that provides some conversion capabilities. You might take a look at that. If the structure of the XML you’re converting into JSON is pretty predictable you might consider building a custom translation either into map:map or a raw JSON string using XSLT or XQuery. We’re also looking to improve the built-in JSON support in MarkLogic as well. If you could provide some more details on what you’re trying to accomplish others on this list or I may be able to help more.
Senior Product Manager
justin.makeig at marklogic.com<mailto:justin.makeig at marklogic.com>
Phone: +1 650 655 2387
On Mar 14, 2012, at 2:56 PM, Jonathan Cook - FM&T wrote:
But what comes out isn't Json?
"highwebdomesticIDX10447671Europe2010-06-29T09:56:21+00:002012-03-12T12:05:58+00:002012-03-14T16:33:29+00:00PUBLISHEDen-GBNews v6cpsSTYOECD sees signs of Europe pick-upThe eurozone shows \"tentative\" signs of recovery, says the Organisation for Economic Co-operation and Development.2012-03-12T11:57:15+00:002012-03-12T12:04:31+00:00en-GBEuropean flagsSTYEurogroup eye on Greece and SpainFinance ministers from eurozone nations are set to discuss Greece's bailout and Spain's deficit at a meeting on Monday.2012-03-12T09:58:04+00:002012-03-12T13:37:24+00:00en-GBProtests in MadridSTYQ&A: Greek debt swap2012-03-07T10:14:44+00:002012-03-09T12:39:11+00:00en-GB2012-02-16T09:20:32+00:00Spain sees its economy contract2012-03-09T11:23:34+00:00Flanders: Where are we now?2012-03-09T08:53:51+00:00Hewitt: Greece deal is temporary reliefSTYVolkswagen forecasts record salesVolkswagen says sales could hit a record in 2012 as strong growth continues in emerging markets.2012-03-12T08:06:40+00:002012-03-12T14:39:54+00:00en-GBVW logo2012-02-24T10:50:53+00:00Volkswagen annual profits doubleSTYBMW sees its profits accelerate2012-03-08T12:17:53+00:002012-03-08T13:03:21+00:00en-GBSTYCarmakers show their sharing side2012-02-28T13:33:34+00:002012-03-05T21:41:45+00:00en-GBSTYSwatch and Tiffany in legal fightSwatch and Tiffany are suing each other following the collapse of their joint venture last year.2012-03-12T07:28:36+00:002012-03-12T08:01:35+00:00en-GBSwatch Gents Watch2012-01-10T11:54:18+00:00Swatch eyes further sales growthSTYSarkozy threat over open bordersPresident Nicolas Sarkozy tells a campaign rally that France will withdraw from Europe's open borders agreement unless illegal immigration is tackled.2012-03-11T16:00:57+00:002012-03-11T16:59:10+00:00en-GBPresident Nicolas SarkozySTYQ&A: Schengen Agreement2011-04-26T10:36:50+00:002012-03-12T13:43:40+00:00en-GBSTYFrance 'has too many foreigners'2012-03-06T21:34:01+00:002012-03-07T06:47:09+00:00en-GB2012-03-07T22:34:11+00:00Sarkozy: Too many foreigners in FranceSTYGKN 'planning Volvo engine deal'GKN is reported to be in advanced talks to buy the aircraft engine unit of Volvo for \u00A3800m.2012-03-11T08:46:56+00:002012-03-11T08:59:40+00:00en-GBGripen combat jetSTYABN Amro takes large Greek lossDutch bank ABN Amro says its underlying net profit for 2011 was undermined by bad debt charges, including 880m euros for Greece.2012-03-09T09:23:30+00:002012-03-09T10:34:28+00:00en-GBABN is expected to be split up when the takeover is completedABN Amro officeSTYRecord deliveries at Airbus ownerEuropean aerospace giant EADS reports higher annual profits as it delivers a record amount of its Airbus aircraft to customers.2012-03-08T07:04:20+00:002012-03-08T11:44:09+00:00en-GBAirbus A320STYChina 'bars Airbus deals' on levy2012-03-08T10:45:09+00:002012-03-08T18:25:40+00:00en-GB2012-02-15T12:00:28+00:00Airbus inquiry into wing cracksSTYUK interest rates remain at 0.5%UK interest rates are kept at 0.5% by the Bank of England, marking three years since they were first cut to the record low.2012-03-08T11:45:59+00:002012-03-08T15:25:11+00:00en-GBBank of England2012-03-06T19:01:17+00:00Flanders: QE for whom?STYThree years of record-low rates2012-03-01T15:45:02+00:002012-03-04T18:18:13+00:00en-GBSTYQE knocks \u00A390bn off pension funds2012-03-07T12:24:34+00:002012-03-08T07:06:43+00:00en-GBSTYFamily split on low interest rates2012-03-02T12:01:59+00:002012-03-03T00:07:21+00:00en-GBSTYAllied Irish to shed 2,500 jobsAllied Irish Banks, the parent company of First Trust in Northern Ireland, confirms that it is cutting its workforce across the UK and Ireland by 2,500.2012-03-08T10:39:35+00:002012-03-08T11:07:48+00:00en-GBAllied Irish Banks is to cut its workforce by 2,500AIBSTYBMW sees its profits accelerateGerman carmaker BMW says it made a record profit margin in its core car business last year, helped by strong demand from China.2012-03-08T12:17:53+00:002012-03-08T13:03:21+00:00en-GBSales to China are still growing fastBMW logoSTYRetailer Carrefour in profit fallNet profits at French supermarket group Carrefour, the world's second-biggest retailer by revenue, fell by 14% in 2011.2012-03-08T09:55:37+00:002012-03-08T10:30:41+00:00en-GBA branch of CarrefourSTYForeign visitors boost EurostarEurostar says passenger numbers rose 2% to 9.7 million last year, with business helped by a rise in visitors from outside the EU.2012-03-08T07:34:58+00:002012-03-08T09:33:21+00:00en-GBEurostar train at St PancrasSTYPower fault brings Eurostar chaos2012-03-05T22:37:09+00:002012-03-06T10:25:26+00:00en-GBSTYEurotunnel swings back to profit2012-03-01T12:50:23+00:002012-03-01T12:55:05+00:00en-GBSTYLufthansa pushed into loss by BMIGerman airline Lufthansa reports an annual loss of 13m euros as a result of losses and disposal costs at its BMI subsidiary.2012-03-07T17:11:30+00:002012-03-07T17:17:29+00:00en-GBLufthansa tail finsSTYAdidas sees record profit in 2011Sportswear firm Adidas unveils its best-ever annual profits, as hopes rise this year's Olympics will help it break more records.2012-03-07T08:04:09+00:002012-03-07T09:41:38+00:00en-GBAdidas hopes the UEFA championships will help deliver record earningsAdidas hopes the UEFA championships will help deliver record earnings2011-08-04T06:19:47+00:00Adidas increases profit forecast2011-03-02T07:22:10+00:00Adidas sees record sales for 2010STYStocks down on Greek swap fearsStock markets decline sharply on concerns ahead of a key deadline to secure Greece's future in the euro.2012-03-06T16:30:10+00:002012-03-06T21:22:37+00:00en-GBAnxious trader at the Frankfurt Stock ExchangeSTYQ&A: Greek debt crisis2011-06-16T15:21:08+00:002012-03-02T09:32:06+00:00en-GB2012-01-30T11:39:21+00:00Why Greece won't go away2011-06-21T10:59:31+00:00Timeline of Eurozone crisisSTYSwiss eye tax rise for foreignersSwitzerland moves closer towards enforcing higher rates of tax on the country's 5,000 wealthiest foreign residents.2012-03-06T15:52:50+00:002012-03-06T16:00:03+00:00en-GBSwiss parliament in BernSTYRange Rover shows convertible 4x4Jaguar Land Rover unveils a convertible Range Rover Evoque design study at the Geneva motor show, while Mini shows off a new vehicle, the Clubvan.2012-03-06T13:22:44+00:002012-03-06T13:42:37+00:00en-GBThe Evoque Cabrio is the latest concept car from Jaguar Land RoverEvoque Cabrio2011-10-31T12:46:54+00:00Infiniti tees up as BMW rival2011-09-15T15:02:50+00:00Mercedes to help Nissan make luxury carsSTYEU calls for more women managersThe EU considers legislating to get more women into top management jobs in Europe, arguing that firms are too slow to act.2012-03-05T12:52:55+00:002012-03-05T13:33:30+00:00en-GBEU Justice Commissioner Viviane Reding2012-03-05T09:39:01+00:00Peston: Time to force women into boardrooms?2011-02-23T17:50:22+00:00More women in boardroom demandedSTYEurozone's retail sales increaseRetail sales across the eurozone rose unexpectedly in January, figures show, but a separate survey indicates economic activity remains weak.2012-03-05T10:23:49+00:002012-03-05T11:17:13+00:00en-GBGermany's retail sales fell in JanuaryGermany's retail sales fell in January2012-01-06T10:40:06+00:00Euro unemployment stays at record2011-11-07T11:08:13+00:00Eurozone retail sales disappointSTYGlencore profits from commoditiesCommodities trading giant Glencore reports a sharp rise in revenues on the back of higher prices for raw materials.2012-03-05T08:12:13+00:002012-03-05T08:36:44+00:00en-GBGlencore headquarters2012-02-07T08:55:34+00:00Glencore and Xstrata: a merger of egosSTYMoody's downgrades Greece againMoody's cuts Greece's credit rating again to \"C\", the lowest level on its scale, warning of default despite a recent debt write-off deal.2012-03-02T23:42:49+00:002012-03-03T00:03:29+00:00en-GBGreek Parliament building2012-02-22T12:18:52+00:00Fitch cuts Greece's rating againSTYSpanish 'to miss deficit target'Spain Prime Minister Mariano Rajoy says his country will miss its budget deficit target this year, as EU leaders agree a new treaty on budget discipline.2012-03-02T13:14:01+00:002012-03-02T14:00:13+00:00en-GBSpanish Prime Minister Mariano Rajoy2012-02-16T09:20:32+00:00Spain sees its economy contract2012-02-15T06:22:55+00:00Europe struck by growth slowdownSTYEU leaders sign new fiscal treatyAll but two of the EU's 27 leaders sign a new treaty to enforce budget discipline within the bloc and rein in debts.2012-03-02T08:34:27+00:002012-03-02T15:50:11+00:00en-GBDanish PM Helle Thorning-Schmidt (left) signs fiscal treaty, with Germany's Chancellor Angela Merkel2012-03-02T15:37:50+00:00Hewitt: Hope comes to eurozoneSTYQ&A: Fiscal compact2011-12-06T20:05:16+00:002012-03-02T10:37:00+00:00en-GBSTYSpain 'to miss deficit target'2012-03-02T13:14:01+00:002012-03-02T14:00:13+00:00en-GBSTYPM claims EU summit win on growth2012-03-01T20:54:46+00:002012-03-02T17:12:49+00:00en-GB2012-03-02T12:02:04+00:00Cameron 'made voice heard'STYGermany retail sales slide backGerman retail sales fell unexpectedly in January by 1.6%, the biggest drop since May last year, official figures show.2012-03-02T09:36:26+00:002012-03-02T10:02:05+00:00en-GBGerman shoppers2012-02-13T14:49:36+00:00Germany: Reasons to be cheerfulSTYBarclays taps ECB for 8.2bn eurosBarclays confirms that it borrowed 8.2bn euros (\u00A36.7bn) from the European Central Bank in low-interest three-year loans.2012-03-02T09:48:04+00:002012-03-02T15:34:13+00:00en-GBBarclays Bank signs2012-03-02T14:45:46+00:00Peston: British banks borrow \u00A331bnSTYECB provides 530bn euros of loans2012-02-29T09:35:20+00:002012-02-29T13:11:13+00:00en-GBSTYItaly's debts increased in 2011Italy's government debt rose during 2011 while its economy struggled to grow, official figures show.2012-03-02T10:52:50+00:002012-03-02T11:42:04+00:00en-GBView of Venice2012-01-17T22:56:44+00:00Risks of Italy's austerity measures2012-02-13T14:49:36+00:00Germany looks on the bright side2012-02-14T10:31:55+00:00Greek recession deepens in 2011STYC&W Worldwide shares in new leapShares in Cable & Wireless Worldwide (CWW) jump sharply for the second time in three weeks on hopes of a takeover battle.2012-03-01T12:48:56+00:002012-03-01T13:05:05+00:00en-GBModemSTYEurotunnel swings back to profitEurotunnel, the operator of the Channel Tunnel, returned to profit in 2011 with a record 19 million passengers.2012-03-01T12:50:23+00:002012-03-01T12:55:05+00:00en-GB2011-03-04T08:26:59+00:00Eurotunnel reports 57m euro loss"
From: general-bounces at developer.marklogic.com<mailto:general-bounces at developer.marklogic.com> on behalf of Will Thompson
Sent: Wed 14.03.2012 21:12
To: MarkLogic Developer Discussion
Subject: Re: [MarkLogic Dev General] Using Json Extensions
That's is how xdmp:to-json works for XML nodes.
From: general-bounces at developer.marklogic.com<mailto:general-bounces at developer.marklogic.com> [mailto:general-bounces at developer.marklogic.com] On Behalf Of Jonathan Cook - FM&T
Sent: Wednesday, March 14, 2012 2:00 PM
To: MarkLogic Developer Discussion
Subject: [MarkLogic Dev General] Using Json Extensions
Has anyone successfully got the json extensions working, I have been playing around with the below but you don't get json coming out, just a long string of the element values from the xml?
let $newsml := doc('http://www.bbc.co.uk/asset/b5c53243-e52f-e059-e040-850a02846523/highweb/domestic')
General mailing list
General at developer.marklogic.com<mailto:General at developer.marklogic.com>
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the General