javatalend
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.
- Simple way templating multiline strings in java code
- Unsafe or unchecked operations for ArrayList
- Consistent time zone for date comparison
- How to convert a .nfo file to .fff file
- Bash command to check if Oracle or OpenJDK java version is installed on Linux
- Between Runtime and compile time jdk version , which one can be greater
- I get an error: An unexpected error occurred while trying to open file hola.jar
- Issue to list names of files from `resources` directory. (in JAR/EXE application)
- space is not allowed after parameter prefix ':' in SpEL support in Spring Data JPA @Query definitions
- Spring Boot Fails to Start after First Boot
- Null exception @Service in a spring @RestController using constructor injection
- How to print sequence of characters according to the number next to it?
- Idiomatic way to use for-each loop given an iterator?
- java jdb does not display code lines in step output
- Set Chrome's language using Selenium ChromeDriver
- a collection data structure to keep items sorted
- In Intellij IDEA 14.1.4: Cannot run program "C:/Program Files (x86)/Java/jdk1.8.0_45/bin/java"
- Using JDK that is bundled inside Android Studio as JAVA_HOME on Mac
- Gatling Java request to be called only once to retrieve login information for other requests that are executed multiple times
- How to fix Eclipse autocomplete not working
- Trying to send a message to a queue on weblogic
- logging.file.max-history is not working in Spring Boot
- How can I find the most frequent word in a huge amount of words (eg. 900000)
- Swapping positions of duplicate values in array (Java)
- Java - sending POST
- Dynamically adding JTable to JScrollPane
- How can I change the database table column order?
- Efficient Ways To Display Messages In RecyclerView
- How to get filtered results based on two columns from a single table using Specification and Criteria Builder in Spring Boot
- Rabbit mq error: Getting Exception in thread "main" java.io.IOException Caused by: com.rabbitmq.client.ShutdownSignalException