12-02-2011
[XQuery] How to Convert from JSON Message to XML Message with XQuery
Hi guys,
I'm in a job of converting a restful webservice to soap. Tool for convertation uses XQuery.
Now i need to convert a message like this:
{
"firstName": "John",
"midName": null,
"lastName": "Smith",
"married": false,
"address": {
"streetAddress": "21 2nd Street",
"city": "New York",
"state": "NY",
"postalCode": 10021
},
"phoneNumbers": [ "212 555-1234", "646 555-4567" ]
}
is equivalent to the following XML representation:
<pair name="firstName" type="string">John</pair>
<pair name="midName" type="null"/>
<pair name="lastName" type="string">Smith</pair>
<pair name="married" type="boolean">false</pair>
<pair name="address" type="object">
<pair name="streetAddress" type="string">21 2nd Street</pair>
<pair name="city" type="string">New York</pair>
<pair name="state" type="string">NY</pair>
<pair name="postalCode" type="number">10021</pair>
</pair>
<pair name="phoneNumbers" type="array">
<item type="string">212 555-1234</item>
<item type="string">646 555-4567</item>
</pair>
I guest this a general case so there must be an example for this somewhere on the internet but i haven't found it yet. So i put on forum and hope someone already knows this.
Thank for u help.
Regards,
Tien86.
Last edited by tien86; 12-02-2011 at 05:01 AM..
8 More Discussions You Might Find Interesting
1. Programming
Hii can anyone pls tell how to limit the max no of message in a posix message queue. I have made changes in proc/sys/fs/mqueue/msg_max
But still whenever i try to read the value of max. message in the queue using attr.mq_curmsgs (where struct mq_attr attr) its giving the default value as 10.... (0 Replies)
Discussion started by: mohit3884
0 Replies
2. Shell Programming and Scripting
I need help to extract a following SOAP-ENV:Header XML message from the log.
XML message need to be extracted:
***************************
<SOAP-ENV:Header>
<ServiceGatewayHeader>
<SourceApplicationId>OXL</SourceApplicationId>
<Version>1.0</Version>
<UserId>TEST</UserId>... (4 Replies)
Discussion started by: tjshankar
4 Replies
3. Shell Programming and Scripting
Hi,
I need to move the XML files from the UNIX to the message queue. Please help me out to write the code..
Thanks,
Mohana Krishnan (0 Replies)
Discussion started by: krishnan_6015@y
0 Replies
4. UNIX for Dummies Questions & Answers
Hi
I have a log file which contain XML message. I want to extract the value between the tag : <businessEventId>13201330</businessEventId> i.e., 13201330.
I tried the following commands but as the message is very long, unable to do it. Attached is the log file. Please provide inputs.
--... (3 Replies)
Discussion started by: Sapna_Sai
3 Replies
5. Programming
Hi!
I am working in an application jsp-java-xml , and i need to validate queries in xquery.
For example
If I put (in a text field)
"for $x in XXX/yyy return data($x/tittle)"
I need a bean(class) that show if the text is correct or not.
And, if were posible, show the syntax error too.
... (2 Replies)
Discussion started by: avatarrr
2 Replies
6. Shell Programming and Scripting
Dear all
I have a log file and the content like this
file name: temp.log
<?xml version="1.0" encoding="cp850"?>
<!DOCTYPE aaabbb SYSTEM '/dtdpath'>
<aaabbb>
<tranDtl>
<msgId>000001</msgId>
</tranDtl>
.....
</aaabbb>
...
... (1 Reply)
Discussion started by: on9west
1 Replies
7. Programming
Hello men.
How can i build a simple increment for $a by Xquery such as ?
let $a := 0
for $i in (1 to 10)
let $a := $a + 1
return $a
why a in this loop always is '1'
Thank you for reading, its will really helpful for my job if i can solve this problem :D:D (3 Replies)
Discussion started by: tien86
3 Replies
8. Shell Programming and Scripting
Hello everyone,
I have created a workflow that will pull down data via a RESTful API in JSON, then my code parses and modifies said data. The problem I have is that these APIs I am working with only accept XML to PUT/POST data, and I am looking for an easy way to convert my JSON file to XML.
... (2 Replies)
Discussion started by: Zaphod_B
2 Replies
LEARN ABOUT DEBIAN
xqilla
XQILLA(1) User Commands XQILLA(1)
NAME
xqilla - run XQuery and XPath 2 expressions
SYNOPSIS
xqilla [OPTION]... QUERY-FILE...
DESCRIPTION
Run XQuery and XPath 2 expressions from QUERY-FILE.
-h Show help and exit
-p Parse in XPath 2 mode (default is XQuery mode)
-P Parse in XPath 1.0 compatibility mode (default is XQuery mode)
-s Parse XSLT 2.0
-f Parse using W3C Full-Text extensions
-u Parse using W3C Update extensions
-e Parse using XQilla specific extensions
-d Run the query in interactive debugging mode
-x Use the Xerces-C data model (default is the FastXDM)
-i file
Load XML document and bind it as the context item
-b baseURI
Set the base URI for the context
-v name value
Bind the name value pair as an external variable
-o file
Write the result to the specified file
-n number
Run the queries a number of times
-q Quiet mode - no output
-t Output an XML representation of the AST
The xqilla command line tool can be used to run XQuery and XPath 2 expressions. It is also a good example of how to use the Simple API of
the XQilla library.
REPORTING BUGS
Report bugs to <https://sourceforge.net/projects/xqilla/support>.
COPYRIGHT
Copyright (C) 2001-2008 DecisionSoft Limited.
Copyright (C) 2004-2008 Oracle.
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may
obtain a copy of the License at <http://www.apache.org/licenses/LICENSE-2.0>
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITH-
OUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and
limitations under the License.
SEE ALSO
The full documentation for the XQilla library is available at <http://xqilla.sourceforge.net/Documentation>.
xqilla January 2010 XQILLA(1)