Java Code to get Object Data Type in Talend using tJava or tJavaRow
I'm trying to get a data from an Object Type. Any idea how to create java code to retrieve data from it? I am getting data from a MongoDB database.
.------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| #1. tLogRow_2 |
+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| key | value |
+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| patient_oid | null |
| mrn | MRN23051413 |
| registereddate | 2023-08-07 12:10:29.088 |
| test | null |
| address | {"_id": {"$oid": "64d06eb518977e642aea2c31"}, "address": "20 ROSAL SAMPAGUITA MALANDAY", "area": "Malanday", "areauid": {"$oid": "5fe31af39034622774565a25"}, "city": "Marikina", "cityuid": {"$oid": "5f6ad6f56714265e8bbbba51"}, "state": "NCR, 2nd district", "stateuid": {"$oid": "5f6ad3716714265e8bb9b73b"}, "country": "Philippines", "countryuid": {"$oid": "5f6ad3706714265e8bb9b631"}, "zipcode": "1805", "zipcodeuid": {"$oid": "5fe306599034622774557943"}} |
+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
[statistics] disconnected
Job testmongodb ended at 16:18 15/08/2023. [Exit code = 0]
I want to have this kind of output
patient_oid | null
mrn | MRN23051413
registereddate | 2023-08-07 12:10:29.088
address_address | 20 ROSAL SAMPAGUITA MALANDAY
address_area | Malanday
address_city | Marikina
and so on......
The application is accepting java code hopefully someone can help how they did it in java in other application
This is the auto generated code in tJavaRow which return the same object type
Thank you in advance
Solution
Your field "address" seems to be a json. You should get it as a string from your first input component. Then you could parsethis string with a tExtractJsonFields component to extract data from it. Check documentation of tExtractJsonFields component to know more about it.
- Is there a java.time equivalent of DateTime.dayOfYear().isLeap()?
- WordNet Java API
- Why use a ReentrantLock if one can use synchronized(this)?
- How to format a ZonedDateTime to a String?
- How to short circuit when using a parallel stream with filter and findFirst
- Stream distinct with nested list counts and matching nested list item counts
- Timezone changes are not being persisted in Spring-Boot application
- how to convert decimal to hexadecimal in java
- Why does pattern matching with switch on InetAddress fail with 'does not cover all possible input values'?
- Jackson to parse bean<t> with list of T beans
- Catch a generic exception in Java?
- How to get the whole text of StAX XMLEvent object?
- The www-authenticate header breaks JettyClientHttpConnector
- Why should I use @NaturalId?
- Can't reproduce virtual thread pinning (jdk 21), yet mysql not as parallel as should be
- how to move slider towards left and right using selenium java
- Format of Date in the JavaFX.TableView
- Launch Jetty 9 Programmatically
- Spring JdbcTemplate fail to convert String to Enum (that extend specific interface), since default converter is called even if removed
- GET Request Returning Empty Object in SpringBoot
- Trying to draw box around checkbox and display text using pdfbox
- Extracting date, hour and minute from Instant.now() generated date
- Tail Call Optimisation in Java
- Spring Boot Angular18 Uploading Photo
- What is a IOException, and how do I fix it?
- What does %5B and %5D in POST requests stand for?
- Why couldn't Integer type convert to Double type automatically in Java8 stream API?
- Spring Boot default H2 jdbc connection (and H2 console)
- No content to map due to end-of-input jackson parser
- How to properly add HTTP header in WebService Client (Spring Web Services)