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.
- How do I use org.scribe.oauth to connect to the tumblr API?
- java stream to set the values to a list from another list
- Delete directories recursively in Java
- How can I call scikit-learn classifiers from Java?
- Java method declared to throw IOException not propagating the exception up the call stack
- How to get integer and fraction portions of a BigDecimal in Java
- How to auto add imports in IntelliJ?
- remove double quotes from csv while using open csv
- Java custom annotation for a behaviour like trim
- Cors Error when calling microservice from Vue frontend application
- Why isn't my class unloaded when I erase any link to them and to ClassLoader?
- Java UTF-8 filenames with IBM JVM (AIX)
- What would be a good use-case scenario for the Spliterator in Java 8?
- Caused by: java.lang.NoClassDefFoundError: io/jsonwebtoken/Jwts
- Are supertypes of a type just the ones that are directly extended or implemented?
- ModelAttribute returns null values to controller in Spring MVC
- Jaybird 3 and Firebird transaction information
- IntelliJ - Invalid source release: 17
- How to use JScrollPane with JTextArea in Swing?
- Java FFM - Obtaining a var handle to an array field of a structure
- Is there auto type inferring in Java?
- Springboot Keycloak Admin add role or reset password error
- Setting up IntelliJ IDEA with Java 1.8/1.7 and resolve "java: System Java Compiler was not found in classpath"
- How to add a simple horizontal line at Y value of JFreeChart TimeSeries
- java.sql.SQLException: Column Index out of range, 2 > 1
- Task app:compileDebugJavaWithJavac failed
- Column name as a parameter to Spring Data JPA Query
- Pervasive SQL Java database name
- XML to be validated against multiple xsd schemas
- How many sessions can be managed by an Java Application in Struts 2?