Obtain payload data

General
1

I'm having trouble getting data from my payload, but specifically I want just a few pieces of data

["18,57,0,0.000000,0,6569,0.000000,19,55,0,0,0,0,0\n","18,57,0,0.000000,0,6570,0.000000,19,55,0,0,0,0,0\n","18,57,0,0.000000,0,6572,0.000000,19,55,0,0,0,0,0\n","18,57,0,0.000000,0,6573,0.000000,19,55,0,0,0,0,0\n","18,57,0,0.000000,0,6575,0.000000,19,55,0,0,0,0,0\n"]

I just want the value of 18 which is subject to change after a certain period of time or maybe the next, at some point this data will become more data and more, and I would like to know how to extract it.

2

Your data is an array with 5 elements, each one of which is a comma separated string with "18" at the beginning.

So from this data do you just want the value 18, the string "18", an array ["18", "18", "18", "18", "18"], etc?

3

the easiest way to integrate data into a chart

4

Are those 5 values for different times? If not then how do you want the chart to appear?

5

What generates that odd arrangement of data? Where does it come from and do you do any post processing to make it that format?

6

That looks like a CSV file split into lines -- if you knew what headers went with each column, you could just pass it to the csv node and get a payload object with fields for every value.

7

That data comes out of my google sheet and is saved to my drive. The data is saved in a single column.

8

Well yes it would be a csv since I am using googlesheet and all the data is saved in a single column and separated by commas.

image
image1123×175 1.52 KB

For sending and data acquisition I use this library:
google-sheets-advance

9

These values were obtained every two seconds and for the distribution of the chart I want the first value to be related to temperature 1, then the others would be a replica of other different sensors. What I plan is to plot data for about a week and the easiest way to save them in google sheet. I am using flow fuse which is the node-red but on the internet. I use this library to communicate with my Google sheet:
google-sheets-advance

10

Seems like google sheets would be better used to hold each piece of data in its own cell -- not all in one column as a comma-delimited string... just sayin'

11

I think the same thing, but maybe it is the pre-sending of data in my case I am sending it directly from an html and maybe that is the problem in the first instance.
In the image 1 are the data to send to the google sheet and so are sent, where I then process them with the CSV function to send all the data (image 2) because I did not let me send them all.

Image1:
image

Image2:

image

12

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.