Sponsored Content
Top Forums Programming [XQuery] How to Convert from JSON Message to XML Message with XQuery Post 302578613 by tien86 on Friday 2nd of December 2011 03:30:54 AM
Old 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

How to limit max no of message in a posix message queue

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

Need to extract XML message from log

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

Move xml files from unix to message queue.

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

Unable to extract a tag from a very long XML message

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

Validate queries XQUERY

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

Extract XML message from a log file using awk

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

[Xquery] How to do a increment in a For loop

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

Convert json to xml

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
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)
All times are GMT -4. The time now is 05:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy