Hello, I am asking for help because with the knowledge of java at me -1. Using Join generates the following msg.payload (Object) . How can I simply extract a part of e.g. ValidityData? ( I want to write this data to MySQL so I don't even know if I need to assign it to a variable ) ot extract one...

. exactly what you have shown is a JSON format. Since you are asking about java, I understand that you are receiving this msg and interpreting it in a java program. If it is an Object then look at what class.... I'm betting on JSONObject then the method get(String key) – gets the object associated with the supplied key, throws JSONException if the key is not found Unless I have misunderstood your problem....

Hi, My problem has been solved - just extract the relevant part from the payload (something I wasn't aware could be done) - no need to rewrite it to a variable ( in my case i.e. msg.payload.ok for the ok part

[Solved] Extracting ValidityData values from an object in Node Red for writing to MySQL

| New topic

#1 18962877 06 Oct 2020 20:33

avatar avatar

Level 36

» |

Post #1
18962877 06 Oct 2020 20:33

Hello,
I am asking for help because with the knowledge of java at me -1.
Using Join generates the following msg.payload (Object)
Code: Java
Log in, to see the code
.

How can I simply extract a part of e.g. ValidityData? ( I want to write this data to MySQL so I don't even know if I need to assign it to a variable ) ot extract one part podo write it during INSERT to a mysql table.

Thank you in advance for your help!
ADVERTISEMENT
#2 18964041 07 Oct 2020 15:03

janek_wro janek_wro

Level 29

» | Helpful post? (0)

Post #2
18964041 07 Oct 2020 15:03

avatar wrote:
.
Code: JSON
Log in, to see the code
.

.
exactly what you have shown is a JSON format.

Since you are asking about java, I understand that you are receiving this msg and interpreting it in a java program.
If it is an Object then look at what class.... I'm betting on JSONObject
then the method
get(String key) – gets the object associated with the supplied key, throws JSONException if the key is not found

Unless I have misunderstood your problem....
#3 18964438 07 Oct 2020 18:34

avatar avatar

Level 36

» | Topic author Helpful post? (0)

Post #3
18964438 07 Oct 2020 18:34

Hi,
My problem has been solved - just extract the relevant part from the payload (something I wasn't aware could be done) - no need to rewrite it to a variable ( in my case
i.e. msg.payload.ok for the ok part
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

| New topic

Report a violation of the law

[Solved] Extracting ValidityData values from an object in Node Red for writing to MySQL

Didn't find an answer? Ask Artificial Intelligence