| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Convert XML to JSON |
« View previous topic :: View next topic » |
| Author |
Message
|
| mqbugman |
 Posted: Tue Nov 21, 2023 5:22 am Post subject: Convert XML to JSON |
 |
|
Newbie
Joined: 21 Nov 2023
Posts: 1
|
Hello!
Currently, I've been working on a flow that calls a webservice using the HTTP Request connector and assembles the response in JSON. However, the webservice's response XML contains some XSD notations in the tags, for example:
<s:Envelope xmlns:s="url">
<s:Header></s:Header>
<s:Body>
<FiltrarUsuarioResponse xmlns="url">
<FiltrarUsuarioResultxmlns:a="url" xmlns:i="url">
<a:TB_USUARIO z:Id="i1" xmlns:z="url">
<a:field>VALUE<a:field>
...
These XSD declarations in the tags are preventing me from retrieving the values to assemble the JSON output. Can you help me? |
|
| Back to top |
|
 |
| timber |
| Posted: Wed Nov 22, 2023 4:32 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
|
Definitely. Please supply your current code and explain exactly what is going wrong, and it should be fairly simple. |
|
| Back to top |
|
|
| yamsever |
| Posted: Wed Dec 13, 2023 2:25 am Post subject: |
|
|
Newbie
Joined: 20 Sep 2023
Posts: 1
|
| To handle XSD declarations in XML tags during conversion to JSON, you might want to consider using a dedicated XML-to-JSON conversion tool or library that can handle schema notations. This ensures a smoother conversion process, allowing you to retrieve values more effectively. Additionally, you can explore options like removing or ignoring the XSD declarations before conversion. |
|
| Back to top |
|
|
| gbaddeley |
| Posted: Wed Dec 13, 2023 3:03 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
Very sleek and glossy first post from a new user. AI spam bots strike again? I suspect that we will never hear from yamsever again as a real person, but I am quite prepared to eat my words.
_________________
Glenn |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
