### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [31 July 2018 18:39 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/1 "2018-07-31T18:39:06Z")
I have function node to read data from JSON file, I want read-only last value in the array. I have written the following code in function node but shown error " "TypeError: Cannot read property 'length' of undefined"``
function node code is
var array = [];
for (var i=0; i\
### Author:  [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [31 July 2018 18:58 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/2 "2018-07-31T18:58:24Z")
That looks like a string not a json object. Maybe need a json node to convert first
---
### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [31 July 2018 19:16 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/3 "2018-07-31T19:16:28Z")
Thank for your reply,
I have tried json node but still the same error. I could not access to last value in the last object, please could you guide me ?
after covert it to josn object still the same problem as shown below
---
### Author:  [@Andrei](https://discourse.nodered.org/u/Andrei)
#### Post date: [31 July 2018 19:25 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/4 "2018-07-31T19:25:14Z")
Replace the existing code from your function by this single line and check the result.
```auto
return {"payload" : msg.payload.pop()};
```
---
### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [31 July 2018 19:37 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/5 "2018-07-31T19:37:15Z")
Thanks, Sir for your nice reply, it returns the last document but what I want exactly serach through all document and display only the document that has the current date (based on timestamp), please cloud you help me with !!
---
### Author:  [@Andrei](https://discourse.nodered.org/u/Andrei)
#### Post date: [31 July 2018 20:10 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/6 "2018-07-31T20:10:41Z")
It could be done with a simple iteration but it is a little bit difficult since I do not have a dataset for testing.
Try to use this code inside a function node and please show me the result that will appear in your debug panel. This will tell me I got right the structure of your dataset.
```auto
function extract(elem) {
let extr = elem.payload.timestamp;
node.warn(extr)
return extr;
}
msg.payload.forEach(extract);
return msg;
```
---
### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [31 July 2018 20:18 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/7 "2018-07-31T20:18:24Z")
this the output
---
### Author:  [@Andrei](https://discourse.nodered.org/u/Andrei)
#### Post date: [31 July 2018 20:57 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/8 "2018-07-31T20:57:23Z")
I am not optimistic that this code will work since I could not test thoroughly and looks like your payload is not consistent (weird data inside the timestamp value) but lets give a try...
Try this code inside a function node
```auto
let today = new Date().toDateString();
let extractor = function (elem) {
let extr = elem.payload.timestamp.toDateString();
node.warn(extr);
return extr == today;
}
var output = msg.payload.filter(extractor);
node.warn(output);
return msg;
```
Explanation:
it creates a function named extractor that will return true if the timestamp in your array element equals today. Otherwise the function returns false. Every time this function returns "true" the array element will be added to the array "output"
---
### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [31 July 2018 21:19 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/9 "2018-07-31T21:19:51Z")
Thanks so much for your support, I have tried it and given this an  error
---
### Author:  [@Andrei](https://discourse.nodered.org/u/Andrei)
#### Post date: [31 July 2018 21:32 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/10 "2018-07-31T21:32:43Z")
I was expecting this error. I could only help now if you export your flow or at least the array you are trying to work out. If you share your flow don´t forget to add 3 backticks before and after otherwise it wont be possible to import and test it.
---
### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [31 July 2018 21:42 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/11 "2018-07-31T21:42:54Z")
is that clear, all objects have the same data but with different times as shown below.
this flow read from DB then convert the data to JSON Object .after that the main job for function node is read-only the document that has date equal to the current date.
please if something not clear let me know
---
### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [31 July 2018 21:45 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/12 "2018-07-31T21:45:01Z")
This flow read from DB then convert the data to JSON Object .After that the main job for function node is reading -only the documents that have the date equal to the current date.
---
### Author:  [@Andrei](https://discourse.nodered.org/u/Andrei)
#### Post date: [31 July 2018 22:01 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/13 "2018-07-31T22:01:49Z")
The issue is that the timestamp is stored in different formats. I don´t know how to overcome this issue.
---
### Author:  [@Andrei](https://discourse.nodered.org/u/Andrei)
#### Post date: [31 July 2018 22:26 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/14 "2018-07-31T22:26:32Z")
One last attempt ?
Check if this code works inside the function node, without generating errors.
```auto
let today = new Date().toDateString();
let extractor = function (elem) {
let extr = new Date(elem.payload.timestamp).toDateString();
node.warn(extr);
return extr == today;
}
var output = msg.payload.filter(extractor);
node.warn(output);
return msg;
```
---
### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [31 July 2018 22:50 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/15 "2018-07-31T22:50:47Z")
Yes ,it works without any errors
---
### Author:  [@Andrei](https://discourse.nodered.org/u/Andrei)
#### Post date: [31 July 2018 23:06 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/16 "2018-07-31T23:06:57Z")
Could you please post a screenshot of the debug panel ? Just wanted to see how the output looks like.
---
### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [31 July 2018 23:09 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/17 "2018-07-31T23:09:30Z")
yes,sure
---
### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [1 August 2018 08:16 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/18 "2018-08-01T08:16:09Z")
The code works without error but why showing all documents??????
---
### Author:  [@Andrei](https://discourse.nodered.org/u/Andrei)
#### Post date: [1 August 2018 10:39 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/19 "2018-08-01T10:39:17Z")
The code provided will only select elements of the array and display them in the debug node in yellow color (thanks to the node.warn statement). Now it is up to you to define what properties of the object you want to display. If all properties then modify the code by adding this line at the end
```auto
msg.payload = output;
```
---
### Author:  [@Ahd](https://discourse.nodered.org/u/Ahd)
#### Post date: [1 August 2018 10:42 UTC](https://discourse.nodered.org/t/read-data-from-json-array/1938/20 "2018-08-01T10:42:05Z")
Ok ,I will try that then I will let you know.Thank,for every thanks
[Next page](https://discourse.nodered.org/t/read-data-from-json-array/1938.md?page=2)