Import JSON files
Moderators: chulett, rschirm, roy
Import JSON files
Hi,
I am new to XML or JSON files.
I got one JSON file from source system.
Could you please help me how to import metadata and read the data
from JSON files.
Thanks in advance.
I am new to XML or JSON files.
I got one JSON file from source system.
Could you please help me how to import metadata and read the data
from JSON files.
Thanks in advance.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"DataStage TX" is no longer part of DataStage, and is properly called WebSphere Transformation Extender, or WebSphere TX.
Your question properly belongs in the DataStage Enterprise Edition forum.
If you don't move it, Craig surely will.
Your question properly belongs in the DataStage Enterprise Edition forum.
If you don't move it, Craig surely will.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I've already moved it. This is the correct forum.
So... these JSON files? First thing I'd ask is what you need to do with them other than "read" them? Knowing what your goal / target is here will help us help you.
So... these JSON files? First thing I'd ask is what you need to do with them other than "read" them? Knowing what your goal / target is here will help us help you.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Looks like rolling up your own mechanism to parse them would be... painful. Can you get your hands on a JSON Parser? I would imagine it could be leveraged via an External Source stage and seems to me it would be the quickest / most reliable way to accomplish this task.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
JSON is very much "like" xml, but is not.......it would be nice to use the xml stages for this, but alas, it is not possible.
Java has all kinds of libraries to process JSON.....my suggestion would be to start looking at JavaPack and write your own class to decipher this JSON and send it to your output link....or (possibly) investigate a way in the java class to "zap" all the tags and indicators in the JSON structure to XML and then pass the resulting structure to your existing xml stage....
Ernie
Java has all kinds of libraries to process JSON.....my suggestion would be to start looking at JavaPack and write your own class to decipher this JSON and send it to your output link....or (possibly) investigate a way in the java class to "zap" all the tags and indicators in the JSON structure to XML and then pass the resulting structure to your existing xml stage....
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>