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.
- Replacement for the deprecated URL(URL context, String spec) constructor that also works with older Java versions
- How to use WebClient to execute synchronous request?
- SpringBoot 2 the elements were left unbound
- Manually converting a string to an integer in Java
- Java is asking to return a value even when the value is returned in the if-else ladder
- Bounded PriorityBlockingQueue
- HSEARCH000151: Unable to get input stream from object of type byte
- How to get a resources path after jlink-ing?
- Error - trustAnchors parameter must be non-empty
- Build WHERE clause dynamically based on filter in queryDSL
- Best practice to select data using Spring JdbcTemplate
- Doubling each letter in a String
- To find the next work day
- Create advanced search in JPA through user defined dynamic where clause conditions
- Flink task manager does not unload classes
- Implicit casts in Java (passing value type wrappers to methods expecting a regular Integer or Long)
- How do I send an e-mail in Java?
- In Java Failing to invoke method with parameters even though seems to match the getMethod() call
- SQL server hanged suddenly - all DB connections are active but no response - SQL server 2016
- In Java how to synchronize cache read and write operations
- Unable to connect to the remote Cassandra datacenter with the options provided in error
- Creating a hierarchy of Java subclasses
- how to return a list of employee's names with the highest pay rate in java
- "Unsupported class file error" on a Vaadin 14 project
- Does Spring @Transactional attribute work on a private method?
- How to create a BKS (BouncyCastle) format Java Keystore that contains a client certificate chain
- Prevent Kafka Streams Consumer from writing offsets / wait for one stream to consume all records before starting the second stream
- Why does my SQL while(set.next()) skips the first element?
- Combine multiple lists in Java
- How to map from Page<ObjectOne> to Page<ObjectTwo> in Spring Data 2?