Discussion about new FoxEssCloud Open API issues

[tiagomlalves]

Hi,

I'm opening this issue as a way to ask for opinions on the new FoxEssCloud Open API. I'm seeing issues (missing data, potential bugs) and I wonder if others have experienced the same. This is not related to HA or this plugin so feel free to redirect me to another forum if you feel there's a better place for such discussion.

For example, when trying to fetch /op/v0/device/report/query for Get device production report, fetching all generation, feedIn, and gridConsumption metrics, I see only values for generation while in their website, I can see:

which clearly shows there's full data available - just not exposed in the API.

Another example is when I'm fetching from /op/v0/device/history/query for Get device history data which replaced their old raw endpoint. Here, they provide begin and end parameters to fetch data for a single day. However, they are being ignored and I always get data for past three days regardless the timestamps I pass.

I've opened support tickets for these - just to check what others with more experience using FoxESS Cloud API think about this.

[FozzieUK]

When I make the /op/v0/device/report/query calls - they work for me.

e.g.
getReport OA request:{"sn":"60BH123456AB12","year":2024,"month": 2,"dimension":"month","variables":["feedin","generation","gridConsumption","chargeEnergyToTal","dischargeEnergyToTal","loads"]}

Returns:
{'errno': 0, 'msg': 'success', 'result': [{'unit': 'kWh', 'values': [0.7000000000000455, 6.5, 0.39999999999997726, 0.1999999999999318, 0.10000000000002274, 0.10000000000002274, 2.5, 5.2000000000000455, 0.2999999999999545, 1.0, 0.5, 2.2999999999999545, 0.40000000000009095, 0.2999999999999545, 0.6000000000000227, 0.2999999999999545, 0.3000000000000682, 0.5, 1.0, 0.8999999999999773, 1.1000000000000227, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'feedin'}, {'unit': 'kWh', 'values': [10.199999999999818, 14.400000000000546, 14.399999999999636, 19.699999999999818, 14.800000000000182, 15.600000000000364, 20.0, 18.300000000000182, 12.5, 17.199999999999818, 13.899999999999636, 21.0, 15.699999999999818, 17.100000000000364, 14.0, 18.699999999999818, 16.600000000000364, 16.800000000000182, 17.0, 16.299999999999272, 17.0, 2.800000000000182, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'generation'}, {'unit': 'kWh', 'values': [21.200000000000728, 13.900000000000546, 28.400000000000546, 29.800000000000182, 40.80000000000018, 38.19999999999982, 26.399999999999636, 40.19999999999982, 43.400000000000546, 25.800000000000182, 34.399999999999636, 25.0, 34.100000000000364, 27.300000000000182, 38.80000000000018, 16.399999999999636, 24.599999999999454, 21.099999999999454, 20.399999999999636, 23.699999999999818, 22.800000000000182, 20.700000000000728, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'gridConsumption'}, {'unit': 'kWh', 'values': [11.0, 8.299999999999727, 14.400000000000091, 14.300000000000182, 19.799999999999727, 18.59999999999991, 9.199999999999818, 21.800000000000182, 19.90000000000009, 7.5, 14.5, 6.899999999999636, 16.90000000000009, 15.0, 19.200000000000273, 6.800000000000182, 16.90000000000009, 13.400000000000091, 13.300000000000182, 13.199999999999818, 13.900000000000091, 12.599999999999909, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'chargeEnergyToTal'}, {'unit': 'kWh', 'values': [7.5, 11.600000000000364, 12.5, 18.899999999999636, 14.900000000000091, 15.5, 14.200000000000273, 18.299999999999727, 10.0, 13.300000000000182, 11.900000000000091, 13.599999999999909, 13.599999999999909, 15.400000000000091, 11.900000000000091, 15.0, 13.299999999999727, 13.800000000000182, 13.0, 13.299999999999727, 14.200000000000273, 2.799999999999727, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'dischargeEnergyToTal'}, {'unit': 'kWh', 'values': [19.200000000000728, 13.0, 27.699999999999818, 35.400000000000546, 35.0, 34.69999999999982, 34.20000000000073, 30.899999999999636, 35.0, 35.5, 33.900000000000546, 36.399999999999636, 32.30000000000018, 28.5, 32.30000000000018, 27.899999999999636, 25.0, 24.699999999999818, 22.800000000000182, 25.199999999999818, 24.199999999999818, 10.400000000000546, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'loads'}]} {"errno":0,"msg":"success","result":[{"unit":"kWh","values":[0.7000000000000455,6.5,0.39999999999997726,0.1999999999999318,0.10000000000002274,0.10000000000002274,2.5,5.2000000000000455,0.2999999999999545,1.0,0.5,2.2999999999999545,0.40000000000009095,0.2999999999999545,0.6000000000000227,0.2999999999999545,0.3000000000000682,0.5,1.0,0.899999999999

I don’t use the other query but I know others do, if I get 20 minutes spare i’ll test it.

[tiagomlalves]

@FozzieUK Thanks for the reply. I see that you're using dimension: "month" - I'll check that. The empty results I got was when using dimension: "day" and fetching data from 2024-02-19. I'll try "month" on my side. Do you think you could please try with "day" too?

[FozzieUK]

@tiagomlalves I was using the dimension: “day” and that did respond correctly, the only reason I moved onto “month” is it appears FoxESS have a data processing problem with the hours - internally they query for the start and end of an hour, which typically only returns 55 minutes of data, it was like that on their old API as well. So I now use “month” and look for todays values in the index to get more accurate totals. They have been told but whether they fix it remains to be seen.
There haven’t been any significant changes in there but I’ll check again to see if dimension: day is working - but note: if any of the values are empty because there has been no power reported the openapi will not return anything.

[FozzieUK]

Yes, there you go “day” still works in the report query.

getReport OA request:{"sn":"60BH123456AB12","year":2024,"month": 2,"day":23,"dimension":"day","variables":["feedin","generation","gridConsumption","chargeEnergyToTal","dischargeEnergyToTal","loads"]}

Returns the following -

{'errno': 0, 'msg': 'success', 'result': [{'unit': 'kWh', 'values': [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.10000000000002274, 0.20000000000004547, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'feedin'}, {'unit': 'kWh', 'values': [0.0, 0.0, 0.0, 0.0, 0.0, 0.1999999999998181, 0.3999999999996362, 0.4000000000005457, 0.5, 0.5, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'generation'}, {'unit': 'kWh', 'values': [3.7000000000007276, 1.9000000000005457, 2.300000000000182, 1.199999999999818, 0.9000000000005457, 0.4000000000005457, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'gridConsumption'}, {'unit': 'kWh', 'values': [3.100000000000364, 1.5, 0.40000000000009095, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'chargeEnergyToTal'}, {'unit': 'kWh', 'values': [0.0, 0.0, 0.0, 0.0, 0.0, 0.09999999999990905, 0.40000000000009095, 0.40000000000009095, 0.09999999999990905, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'dischargeEnergyToTal'}, {'unit': 'kWh', 'values': [0.3999999999996362, 0.3999999999996362, 1.9000000000005457, 1.2000000000007276, 0.8999999999996362, 0.5, 0.3999999999996362, 0.3999999999996362, 0.3000000000001819, 0.2000000000007276, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], 'variable': 'loads'}]}

[FozzieUK]

@tiagomlalves

I just tried the device production request, I set begin to the timestamp now -7,200 seconds (i.e. 2 hours ago) and end as the timestamp now, and requested the variable "pvPower" and it responds correctly:

getReport OA request:{"sn":"60BH123456AB12","begin":"1708679904330", "end":"1708687104330", "variables":["pvPower"]}

Result is :

{'errno': 0, 'msg': 'success', 'result': [{'datas': [{'unit': 'kW', 'data': [{'time': '2024-02-23 09:23:07 GMT+0000', 'value': 1.065}, {'time': '2024-02-23 09:33:07 GMT+0000', 'value': 0.6419999999999999}, {'time': '2024-02-23 09:38:07 GMT+0000', 'value': 1.404}, {'time': '2024-02-23 09:43:07 GMT+0000', 'value': 0.712}, {'time': '2024-02-23 09:48:07 GMT+0000', 'value': 0.385}, {'time': '2024-02-23 09:53:07 GMT+0000', 'value': 0.757}, {'time': '2024-02-23 09:58:07 GMT+0000', 'value': 0.272}, {'time': '2024-02-23 10:03:07 GMT+0000', 'value': 0.25}, {'time': '2024-02-23 10:08:07 GMT+0000', 'value': 0.28300000000000003}, {'time': '2024-02-23 10:13:07 GMT+0000', 'value': 0.401}, {'time': '2024-02-23 10:18:07 GMT+0000', 'value': 0.519}, {'time': '2024-02-23 10:23:07 GMT+0000', 'value': 0.485}, {'time': '2024-02-23 10:28:07 GMT+0000', 'value': 0.589}, {'time': '2024-02-23 10:33:07 GMT+0000', 'value': 0.955}, {'time': '2024-02-23 10:38:07 GMT+0000', 'value': 0.905}, {'time': '2024-02-23 10:43:07 GMT+0000', 'value': 0.742}, {'time': '2024-02-23 10:48:07 GMT+0000', 'value': 0.897}, {'time': '2024-02-23 10:53:07 GMT+0000', 'value': 0.717}, {'time': '2024-02-23 10:58:07 GMT+0000', 'value': 0.41700000000000004}, {'time': '2024-02-23 11:03:07 GMT+0000', 'value': 0.327}, {'time': '2024-02-23 11:08:07 GMT+0000', 'value': 0.569}, {'time': '2024-02-23 11:13:07 GMT+0000', 'value': 1.6059999999999999}, {'time': '2024-02-23 11:18:07 GMT+0000', 'value': 2.9290000000000003}], 'name': 'PVPower', 'variable': 'pvPower'}], 'deviceSN': '60BH123456AB12'}]}

Are you setting the content type in your headers? - it should be: 'Content-Type': 'application/json',

[tiagomlalves]

@FozzieUK, thanks for sharing some working examples.

When posting to https://www.foxesscloud.com/op/v0/device/report/query to retrieve data for 2024-02-19, with the request:

{
  "method": "POST",
  "headers": {
    "Content-Type": "application/json",
    "token": ************,
    "signature": "5a0ca7326e7e0e9aa84e82e45479f08e",
    "timestamp": "1708701071406",
    "lang": "en",
    "User-Agent": "curl/7.64.1"
  },
  "body": {
    "sn": "60GS2520297B039",
    "year": 2024,
    "month": 2,
    "day": 19,
    "dimension": "day",
    "variables": ["generation", "feedin", "gridConsumption", "chargeEnergyToTal", "dischargeEnergyToTal"]
  }
}

The response I get is:

{
  "errno":0, "msg":"success",
  "result":[
    {"unit":"kWh","values":[0,0,0,0,0,0,0,0,0.900000000000091,1.5,1.900000000000091,2,1.699999999999818,1.699999999999818,1.400000000000091,0.900000000000091,0.3000000000001819,0.09999999999990905,0,0,0,0,0,0],"variable":"generation"},
    {"unit":"kWh","values":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"variable":"feedin"},
    {"unit":"kWh","values":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"variable":"gridConsumption"},
    {"unit":"kWh","values":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"variable":"chargeEnergyToTal"},
    {"unit":"kWh","values":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"variable":"dischargeEnergyToTal"}
  ]
}

I've used the same User-Agent as in your code / Open API examples and it doesn't matter. Using different dates returns different values for "generation" (as expected) but other variables are all zeroed.

I've checked using "dimension": "month" (using fewer variables) and the output I got was:

{
  "errno":0,"msg":"success",
  "result":[
    {"unit":"kWh","values":[11.700000000000273,11.699999999999818,11.900000000000091,9.699999999999818,7.900000000000091,8.800000000000182,5.900000000000091,0.3999999999996362,7.300000000000182,10.5,2.400000000000091,11.599999999999909,1.599999999999909,7.700000000000273,8.5,5.199999999999818,10.800000000000182,13.599999999999909,13.599999999999909,13.699999999999818,12.800000000000182,3.699999999999818,9.600000000000364,0,0,0,0,0,0],"variable":"generation"},
    {"unit":"kWh","values":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"variable":"feedin"},
    {"unit":"kWh","values":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"variable":"gridConsumption"},
    {"unit":"kWh","values":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"variable":"loads"}
  ]
}

All variables except for generation return zero.

I'm checking now fetching historical data.

[tiagomlalves]

Example for historical data on 2024-02-19 to https://www.foxesscloud.com/op/v0/device/history/query where filters aren't working:

{
  "method": "POST",
  "headers": {
    "Content-Type": "application/json",
    "token": ***********,
    "signature": "fa6332c10586b382f4ac3e1daaa8ccaa",
    "timestamp": "1708702363609",
    "lang": "en",
    "User-Agent": "curl/7.64.1"
  },
  "body": {
    "sn": "60GS2520297B039",
    "begin:": 1708308000000,
    "end": 1708380000000,
    "variables": ["pvPower"]
  }
}```

Results in:

{"errno":0,"msg":"success","result":[{"datas":[{"unit":"kW","data":[{"time":"2024-02-20 15:37:00 WET+0000","value":0.949},{"time":"2024-02-20 15:42:05 WET+0000","value":0.908},{"time":"2024-02-20 15:47:10 WET+0000","value":0.858},{"time":"2024-02-20 15:52:15 WET+0000","value":0.785},{"time":"2024-02-20 15:57:20 WET+0000","value":0.712},{"time":"2024-02-20 16:02:25 WET+0000","value":0.656},{"time":"2024-02-20 16:07:30 WET+0000","value":0.603},{"time":"2024-02-20 16:12:35 WET+0000","value":0.543},{"time":"2024-02-20 16:17:40 WET+0000","value":0.494},{"time":"2024-02-20 16:22:45 WET+0000","value":0.452},{"time":"2024-02-20 16:27:50 WET+0000","value":0.386},{"time":"2024-02-20 16:32:55 WET+0000","value":0.303},{"time":"2024-02-20 16:38:00 WET+0000","value":0.301},{"time":"2024-02-20 16:43:05 WET+0000","value":0.237},{"time":"2024-02-20 16:48:10 WET+0000","value":0.237},{"time":"2024-02-20 16:53:15 WET+0000","value":0.213},{"time":"2024-02-20 16:58:20 WET+0000","value":0.203},{"time":"2024-02-20 17:03:25 WET+0000","value":0.179},{"time":"2024-02-20 17:08:30 WET+0000","value":0.151},{"time":"2024-02-20 17:13:35 WET+0000","value":0.107},{"time":"2024-02-20 17:18:40 WET+0000","value":0.103},{"time":"2024-02-20 17:23:45 WET+0000","value":0.089},{"time":"2024-02-20 17:28:51 WET+0000","value":0.063},{"time":"2024-02-20 17:33:56 WET+0000","value":0.058},{"time":"2024-02-20 17:39:01 WET+0000","value":0.062},{"time":"2024-02-20 17:44:06 WET+0000","value":0.042},{"time":"2024-02-20 17:49:11 WET+0000","value":0.041},{"time":"2024-02-20 17:54:16 WET+0000","value":0.021},{"time":"2024-02-20 17:59:21 WET+0000","value":0.019},{"time":"2024-02-20 18:04:26 WET+0000","value":0},{"time":"2024-02-20 18:09:31 WET+0000","value":0},{"time":"2024-02-20 18:14:36 WET+0000","value":0},{"time":"2024-02-20 18:19:41 WET+0000","value":0},{"time":"2024-02-20 18:24:46 WET+0000","value":0},{"time":"2024-02-20 18:29:51 WET+0000","value":0},{"time":"2024-02-20 18:34:56 WET+0000","value":0},{"time":"2024-02-20 18:40:01 WET+0000","value":0},{"time":"2024-02-20 18:45:06 WET+0000","value":0},{"time":"2024-02-20 18:50:11 WET+0000","value":0},{"time":"2024-02-20 18:55:16 WET+0000","value":0},{"time":"2024-02-20 19:00:21 WET+0000","value":0},{"time":"2024-02-20 19:05:26 WET+0000","value":0},{"time":"2024-02-20 19:10:31 WET+0000","value":0},{"time":"2024-02-21 07:10:41 WET+0000","value":0},{"time":"2024-02-21 07:15:46 WET+0000","value":0},{"time":"2024-02-21 07:20:51 WET+0000","value":0},{"time":"2024-02-21 07:25:56 WET+0000","value":0},{"time":"2024-02-21 07:31:01 WET+0000","value":0},{"time":"2024-02-21 07:36:06 WET+0000","value":0},{"time":"2024-02-21 07:41:11 WET+0000","value":0.247},{"time":"2024-02-21 07:46:16 WET+0000","value":0.329},{"time":"2024-02-21 07:51:21 WET+0000","value":0.402},{"time":"2024-02-21 07:56:26 WET+0000","value":0.519},{"time":"2024-02-21 08:01:31 WET+0000","value":0.581},{"time":"2024-02-21 08:06:36 WET+0000","value":0.75},{"time":"2024-02-21 08:11:41 WET+0000","value":0.863},{"time":"2024-02-21 08:16:46 WET+0000","value":0.817},{"time":"2024-02-21 08:21:51 WET+0000","value":0.914},{"time":"2024-02-21 08:26:56 WET+0000","value":1.015},{"time":"2024-02-21 08:32:01 WET+0000","value":0.959},{"time":"2024-02-21 08:37:06 WET+0000","value":0.995},{"time":"2024-02-21 08:42:11 WET+0000","value":1.046},{"time":"2024-02-21 08:47:16 WET+0000","value":0.983},{"time":"2024-02-21 08:52:21 WET+0000","value":1.032},{"time":"2024-02-21 08:57:26 WET+0000","value":1.108},{"time":"2024-02-21 09:02:31 WET+0000","value":1.18},{"time":"2024-02-21 09:07:36 WET+0000","value":1.317},{"time":"2024-02-21 09:12:41 WET+0000","value":1.289},{"time":"2024-02-21 09:17:46 WET+0000","value":1.413},{"time":"2024-02-21 09:22:51 WET+0000","value":1.565},{"time":"2024-02-21 09:27:56 WET+0000","value":1.641},{"time":"2024-02-21 09:33:01 WET+0000","value":1.677},{"time":"2024-02-21 09:38:06 WET+0000","value":1.611},{"time":"2024-02-21 09:43:11 WET+0000","value":1.726},{"time":"2024-02-21 09:48:16 WET+0000","value":1.412},{"time":"2024-02-21 09:53:21 WET+0000","value":1.673},{"time":"2024-02-21 09:58:26 WET+0000","value":1.619},{"time":"2024-02-21 10:03:31 WET+0000","value":1.621},{"time":"2024-02-21 10:08:36 WET+0000","value":1.71},{"time":"2024-02-21 10:13:41 WET+0000","value":1.744},{"time":"2024-02-21 10:18:46 WET+0000","value":1.918},{"time":"2024-02-21 10:23:51 WET+0000","value":1.722},{"time":"2024-02-21 10:28:56 WET+0000","value":1.664},{"time":"2024-02-21 10:34:01 WET+0000","value":1.707},{"time":"2024-02-21 10:39:06 WET+0000","value":1.95},{"time":"2024-02-21 10:44:11 WET+0000","value":1.957},{"time":"2024-02-21 10:49:16 WET+0000","value":2.04},{"time":"2024-02-21 10:54:21 WET+0000","value":1.899},{"time":"2024-02-21 10:59:26 WET+0000","value":2.018},{"time":"2024-02-21 11:04:31 WET+0000","value":2.06},{"time":"2024-02-21 11:09:36 WET+0000","value":2.117},{"time":"2024-02-21 11:14:41 WET+0000","value":2.179},{"time":"2024-02-21 11:19:46 WET+0000","value":2.224},{"time":"2024-02-21 11:24:52 WET+0000","value":2.189},{"time":"2024-02-21 11:29:57 WET+0000","value":2.186},{"time":"2024-02-21 11:35:02 WET+0000","value":2.235},{"time":"2024-02-21 11:40:07 WET+0000","value":2.241},{"time":"2024-02-21 11:45:12 WET+0000","value":2.266},{"time":"2024-02-21 11:50:17 WET+0000","value":2.247},{"time":"2024-02-21 11:55:22 WET+0000","value":2.242},{"time":"2024-02-21 12:00:27 WET+0000","value":2.254},{"time":"2024-02-21 12:05:32 WET+0000","value":2.22},{"time":"2024-02-21 12:10:37 WET+0000","value":2.04},{"time":"2024-02-21 12:15:42 WET+0000","value":2.021},{"time":"2024-02-21 12:20:47 WET+0000","value":2.06},{"time":"2024-02-21 12:25:52 WET+0000","value":1.949},{"time":"2024-02-21 12:30:57 WET+0000","value":2.038},{"time":"2024-02-21 12:36:02 WET+0000","value":2.13},{"time":"2024-02-21 12:41:07 WET+0000","value":2.164},{"time":"2024-02-21 12:46:12 WET+0000","value":2.168},{"time":"2024-02-21 12:51:17 WET+0000","value":2.105},{"time":"2024-02-21 12:56:22 WET+0000","value":2},{"time":"2024-02-21 13:01:27 WET+0000","value":1.897},{"time":"2024-02-21 13:06:32 WET+0000","value":2.159},{"time":"2024-02-21 13:11:37 WET+0000","value":1.962},{"time":"2024-02-21 13:16:42 WET+0000","value":1.955},{"time":"2024-02-21 13:21:47 WET+0000","value":1.857},{"time":"2024-02-21 13:26:52 WET+0000","value":1.686},{"time":"2024-02-21 13:31:57 WET+0000","value":1.546},{"time":"2024-02-21 13:37:02 WET+0000","value":1.499},{"time":"2024-02-21 13:42:07 WET+0000","value":1.898},{"time":"2024-02-21 13:47:12 WET+0000","value":1.853},{"time":"2024-02-21 13:52:17 WET+0000","value":1.794},{"time":"2024-02-21 13:57:22 WET+0000","value":1.714},{"time":"2024-02-21 14:02:27 WET+0000","value":1.605},{"time":"2024-02-21 14:07:32 WET+0000","value":1.573},{"time":"2024-02-21 14:12:37 WET+0000","value":1.607},{"time":"2024-02-21 14:17:42 WET+0000","value":1.528},{"time":"2024-02-21 14:22:47 WET+0000","value":1.466},{"time":"2024-02-21 14:27:52 WET+0000","value":1.368},{"time":"2024-02-21 14:32:57 WET+0000","value":1.349},{"time":"2024-02-21 14:38:02 WET+0000","value":1.238},{"time":"2024-02-21 14:43:07 WET+0000","value":1.2},{"time":"2024-02-21 14:48:12 WET+0000","value":1.226},{"time":"2024-02-21 14:53:17 WET+0000","value":1.253},{"time":"2024-02-21 14:58:22 WET+0000","value":1.023},{"time":"2024-02-21 15:03:27 WET+0000","value":0.983},{"time":"2024-02-21 15:08:32 WET+0000","value":0.989},{"time":"2024-02-21 15:13:37 WET+0000","value":0.979},{"time":"2024-02-21 15:18:42 WET+0000","value":1.072},{"time":"2024-02-21 15:23:47 WET+0000","value":0.879},{"time":"2024-02-21 15:28:52 WET+0000","value":0.969},{"time":"2024-02-21 15:33:57 WET+0000","value":0.935},{"time":"2024-02-21 15:39:02 WET+0000","value":0.706},{"time":"2024-02-21 15:44:07 WET+0000","value":0.665},{"time":"2024-02-21 15:49:12 WET+0000","value":0.556},{"time":"2024-02-21 15:54:17 WET+0000","value":0.676},{"time":"2024-02-21 15:59:22 WET+0000","value":0.576},{"time":"2024-02-21 16:04:27 WET+0000","value":0.533},{"time":"2024-02-21 16:09:32 WET+0000","value":0.506},{"time":"2024-02-21 16:14:37 WET+0000","value":0.508},{"time":"2024-02-21 16:19:42 WET+0000","value":0.489},{"time":"2024-02-21 16:24:47 WET+0000","value":0.45},{"time":"2024-02-21 16:29:52 WET+0000","value":0.426},{"time":"2024-02-21 16:34:57 WET+0000","value":0.406},{"time":"2024-02-21 16:40:02 WET+0000","value":0.38},{"time":"2024-02-21 16:45:07 WET+0000","value":0.354},{"time":"2024-02-21 16:50:12 WET+0000","value":0.353},{"time":"2024-02-21 16:55:17 WET+0000","value":0.315},{"time":"2024-02-21 17:00:22 WET+0000","value":0.3},{"time":"2024-02-21 17:05:27 WET+0000","value":0.258},{"time":"2024-02-21 17:10:32 WET+0000","value":0.24},{"time":"2024-02-21 17:15:37 WET+0000","value":0.223},{"time":"2024-02-21 17:20:42 WET+0000","value":0.203},{"time":"2024-02-21 17:25:47 WET+0000","value":0.182},{"time":"2024-02-21 17:30:52 WET+0000","value":0.157},{"time":"2024-02-21 17:35:57 WET+0000","value":0.149},{"time":"2024-02-21 17:41:02 WET+0000","value":0.124},{"time":"2024-02-21 17:46:07 WET+0000","value":0.105},{"time":"2024-02-21 17:51:12 WET+0000","value":0.062},{"time":"2024-02-21 17:56:17 WET+0000","value":0.06},{"time":"2024-02-21 18:01:22 WET+0000","value":0.041},{"time":"2024-02-21 18:06:27 WET+0000","value":0.019},{"time":"2024-02-21 18:11:32 WET+0000","value":0},{"time":"2024-02-21 18:16:37 WET+0000","value":0},{"time":"2024-02-21 18:21:42 WET+0000","value":0},{"time":"2024-02-21 18:26:47 WET+0000","value":0},{"time":"2024-02-21 18:31:52 WET+0000","value":0},{"time":"2024-02-21 18:36:57 WET+0000","value":0},{"time":"2024-02-21 18:42:02 WET+0000","value":0},{"time":"2024-02-21 18:47:07 WET+0000","value":0},{"time":"2024-02-21 18:52:12 WET+0000","value":0},{"time":"2024-02-21 18:57:17 WET+0000","value":0},{"time":"2024-02-21 19:02:22 WET+0000","value":0},{"time":"2024-02-21 19:07:27 WET+0000","value":0},{"time":"2024-02-21 19:12:32 WET+0000","value":0},{"time":"2024-02-22 07:29:18 WET+0000","value":0},{"time":"2024-02-22 07:34:23 WET+0000","value":0.008},{"time":"2024-02-22 07:39:28 WET+0000","value":0},{"time":"2024-02-22 07:44:33 WET+0000","value":0},{"time":"2024-02-22 07:49:38 WET+0000","value":0},{"time":"2024-02-22 07:54:43 WET+0000","value":0},{"time":"2024-02-22 07:59:48 WET+0000","value":0},{"time":"2024-02-22 08:04:53 WET+0000","value":0.173},{"time":"2024-02-22 08:09:58 WET+0000","value":0.153},{"time":"2024-02-22 08:15:03 WET+0000","value":0.131},{"time":"2024-02-22 08:20:08 WET+0000","value":0.183},{"time":"2024-02-22 08:25:13 WET+0000","value":0.111},{"time":"2024-02-22 08:30:18 WET+0000","value":0.174},{"time":"2024-02-22 08:35:23 WET+0000","value":0.203},{"time":"2024-02-22 08:40:28 WET+0000","value":0.218},{"time":"2024-02-22 08:45:33 WET+0000","value":0.181},{"time":"2024-02-22 08:50:38 WET+0000","value":0.105},{"time":"2024-02-22 08:55:43 WET+0000","value":0.084},{"time":"2024-02-22 09:00:48 WET+0000","value":0.374},{"time":"2024-02-22 09:05:53 WET+0000","value":0.425},{"time":"2024-02-22 09:10:58 WET+0000","value":0.277},{"time":"2024-02-22 09:16:03 WET+0000","value":0.351},{"time":"2024-02-22 09:21:08 WET+0000","value":0.478},{"time":"2024-02-22 09:26:13 WET+0000","value":0.25},{"time":"2024-02-22 09:31:18 WET+0000","value":0.458},{"time":"2024-02-22 09:36:23 WET+0000","value":0.233},{"time":"2024-02-22 09:41:28 WET+0000","value":0.134},{"time":"2024-02-22 09:46:33 WET+0000","value":0.157},{"time":"2024-02-22 09:51:38 WET+0000","value":0.152},{"time":"2024-02-22 09:56:43 WET+0000","value":0.133},{"time":"2024-02-22 10:01:48 WET+0000","value":0.096},{"time":"2024-02-22 10:06:53 WET+0000","value":0.131},{"time":"2024-02-22 10:11:58 WET+0000","value":0.129},{"time":"2024-02-22 10:17:03 WET+0000","value":0.16},{"time":"2024-02-22 10:22:08 WET+0000","value":0.222},{"time":"2024-02-22 10:27:13 WET+0000","value":0.259},{"time":"2024-02-22 10:32:18 WET+0000","value":0.394},{"time":"2024-02-22 10:37:23 WET+0000","value":0.589},{"time":"2024-02-22 10:42:28 WET+0000","value":0.243},{"time":"2024-02-22 10:47:33 WET+0000","value":0.155},{"time":"2024-02-22 10:52:38 WET+0000","value":0.25},{"time":"2024-02-22 10:57:43 WET+0000","value":0.428},{"time":"2024-02-22 11:02:48 WET+0000","value":0.521},{"time":"2024-02-22 11:07:53 WET+0000","value":0.928},{"time":"2024-02-22 11:12:58 WET+0000","value":0.786},{"time":"2024-02-22 11:18:03 WET+0000","value":0.555},{"time":"2024-02-22 11:23:08 WET+0000","value":0.449},{"time":"2024-02-22 11:28:13 WET+0000","value":0.494},{"time":"2024-02-22 11:33:18 WET+0000","value":0.593},{"time":"2024-02-22 11:38:23 WET+0000","value":0.519},{"time":"2024-02-22 11:43:28 WET+0000","value":0.667},{"time":"2024-02-22 11:48:33 WET+0000","value":0.611},{"time":"2024-02-22 11:53:38 WET+0000","value":0.842},{"time":"2024-02-22 11:58:43 WET+0000","value":0.954},{"time":"2024-02-22 12:03:48 WET+0000","value":0.644},{"time":"2024-02-22 12:08:53 WET+0000","value":0.557},{"time":"2024-02-22 12:13:58 WET+0000","value":0.559},{"time":"2024-02-22 12:19:03 WET+0000","value":0.412},{"time":"2024-02-22 12:24:08 WET+0000","value":0.636},{"time":"2024-02-22 12:29:13 WET+0000","value":0.606},{"time":"2024-02-22 12:34:18 WET+0000","value":0.727},{"time":"2024-02-22 12:39:23 WET+0000","value":0.581},{"time":"2024-02-22 12:44:28 WET+0000","value":0.722},{"time":"2024-02-22 12:49:33 WET+0000","value":0.498},{"time":"2024-02-22 12:54:38 WET+0000","value":0.502},{"time":"2024-02-22 12:59:43 WET+0000","value":0.477},{"time":"2024-02-22 13:04:48 WET+0000","value":0.415},{"time":"2024-02-22 13:09:53 WET+0000","value":0.258},{"time":"2024-02-22 13:14:58 WET+0000","value":0.285},{"time":"2024-02-22 13:20:03 WET+0000","value":0.252},{"time":"2024-02-22 13:25:08 WET+0000","value":0.341},{"time":"2024-02-22 13:30:13 WET+0000","value":0.301},{"time":"2024-02-22 13:35:18 WET+0000","value":0.383},{"time":"2024-02-22 13:40:23 WET+0000","value":0.332},{"time":"2024-02-22 13:45:28 WET+0000","value":0.213},{"time":"2024-02-22 13:50:33 WET+0000","value":0.199},{"time":"2024-02-22 13:55:38 WET+0000","value":0.243},{"time":"2024-02-22 14:00:43 WET+0000","value":0.234},{"time":"2024-02-22 14:05:48 WET+0000","value":0.485},{"time":"2024-02-22 14:10:53 WET+0000","value":0.639},{"time":"2024-02-22 14:15:58 WET+0000","value":0.388},{"time":"2024-02-22 14:21:03 WET+0000","value":1.031},{"time":"2024-02-22 14:26:08 WET+0000","value":0.841},{"time":"2024-02-22 14:31:13 WET+0000","value":0.502},{"time":"2024-02-22 14:36:18 WET+0000","value":0.258},{"time":"2024-02-22 14:41:23 WET+0000","value":0.376},{"time":"2024-02-22 14:46:29 WET+0000","value":0.411},{"time":"2024-02-22 14:51:34 WET+0000","value":0.614},{"time":"2024-02-22 14:56:39 WET+0000","value":0.546},{"time":"2024-02-22 15:01:44 WET+0000","value":0.362},{"time":"2024-02-22 15:06:49 WET+0000","value":0.218},{"time":"2024-02-22 15:11:54 WET+0000","value":0.429},{"time":"2024-02-22 15:16:59 WET+0000","value":0.278},{"time":"2024-02-22 15:22:04 WET+0000","value":0.494},{"time":"2024-02-22 15:27:09 WET+0000","value":0.566},{"time":"2024-02-22 15:32:14 WET+0000","value":1.145},{"time":"2024-02-22 15:37:19 WET+0000","value":0.415},{"time":"2024-02-22 15:42:24 WET+0000","value":0.984},{"time":"2024-02-22 15:47:29 WET+0000","value":0.676},{"time":"2024-02-22 15:52:34 WET+0000","value":0.547},{"time":"2024-02-22 15:57:39 WET+0000","value":0.586},{"time":"2024-02-22 16:02:44 WET+0000","value":0.428},{"time":"2024-02-22 16:07:49 WET+0000","value":0.477},{"time":"2024-02-22 16:12:54 WET+0000","value":0.506},{"time":"2024-02-22 16:17:59 WET+0000","value":0.407},{"time":"2024-02-22 16:23:04 WET+0000","value":0.399},{"time":"2024-02-22 16:28:09 WET+0000","value":0.36},{"time":"2024-02-22 16:33:14 WET+0000","value":0.202},{"time":"2024-02-22 16:38:19 WET+0000","value":0.305},{"time":"2024-02-22 16:43:24 WET+0000","value":0.281},{"time":"2024-02-22 16:48:29 WET+0000","value":0.442},{"time":"2024-02-22 16:53:34 WET+0000","value":0.313},{"time":"2024-02-22 16:58:39 WET+0000","value":0.346},{"time":"2024-02-22 17:03:44 WET+0000","value":0.26},{"time":"2024-02-22 17:08:49 WET+0000","value":0.206},{"time":"2024-02-22 17:13:54 WET+0000","value":0.197},{"time":"2024-02-22 17:18:59 WET+0000","value":0.087},{"time":"2024-02-22 17:24:04 WET+0000","value":0.085},{"time":"2024-02-22 17:29:09 WET+0000","value":0.103},{"time":"2024-02-22 17:34:14 WET+0000","value":0.108},{"time":"2024-02-22 17:39:19 WET+0000","value":0.078},{"time":"2024-02-22 17:44:24 WET+0000","value":0.145},{"time":"2024-02-22 17:49:29 WET+0000","value":0.111},{"time":"2024-02-22 17:54:34 WET+0000","value":0.067},{"time":"2024-02-22 17:59:39 WET+0000","value":0.064},{"time":"2024-02-22 18:04:44 WET+0000","value":0.044},{"time":"2024-02-22 18:09:49 WET+0000","value":0.02},{"time":"2024-02-22 18:14:54 WET+0000","value":0.018},{"time":"2024-02-22 18:19:59 WET+0000","value":0},{"time":"2024-02-22 18:25:04 WET+0000","value":0},{"time":"2024-02-22 18:30:09 WET+0000","value":0},{"time":"2024-02-22 18:35:14 WET+0000","value":0},{"time":"2024-02-22 18:40:19 WET+0000","value":0},{"time":"2024-02-22 18:45:24 WET+0000","value":0},{"time":"2024-02-22 18:50:29 WET+0000","value":0},{"time":"2024-02-22 18:55:34 WET+0000","value":0},{"time":"2024-02-22 19:00:39 WET+0000","value":0},{"time":"2024-02-22 19:05:44 WET+0000","value":0},{"time":"2024-02-22 19:10:49 WET+0000","value":0},{"time":"2024-02-22 19:15:54 WET+0000","value":0},{"time":"2024-02-22 19:20:59 WET+0000","value":0},{"time":"2024-02-22 19:26:04 WET+0000","value":0},{"time":"2024-02-22 19:31:09 WET+0000","value":0},{"time":"2024-02-22 19:36:14 WET+0000","value":0},{"time":"2024-02-22 19:41:19 WET+0000","value":0},{"time":"2024-02-22 19:46:24 WET+0000","value":0},{"time":"2024-02-22 19:51:29 WET+0000","value":0},{"time":"2024-02-22 19:56:34 WET+0000","value":0},{"time":"2024-02-22 20:01:39 WET+0000","value":0},{"time":"2024-02-22 20:06:44 WET+0000","value":0},{"time":"2024-02-22 20:11:49 WET+0000","value":0},{"time":"2024-02-22 20:16:54 WET+0000","value":0},{"time":"2024-02-22 20:21:59 WET+0000","value":0},{"time":"2024-02-22 20:27:04 WET+0000","value":0},{"time":"2024-02-22 20:32:09 WET+0000","value":0},{"time":"2024-02-22 20:37:14 WET+0000","value":0},{"time":"2024-02-22 20:42:19 WET+0000","value":0},{"time":"2024-02-22 20:47:24 WET+0000","value":0},{"time":"2024-02-22 20:52:29 WET+0000","value":0},{"time":"2024-02-22 20:57:34 WET+0000","value":0},{"time":"2024-02-22 21:02:39 WET+0000","value":0},{"time":"2024-02-22 21:07:44 WET+0000","value":0},{"time":"2024-02-22 21:12:49 WET+0000","value":0},{"time":"2024-02-22 21:17:54 WET+0000","value":0},{"time":"2024-02-22 21:22:59 WET+0000","value":0},{"time":"2024-02-22 21:28:04 WET+0000","value":0},{"time":"2024-02-22 21:33:09 WET+0000","value":0},{"time":"2024-02-22 21:38:14 WET+0000","value":0},{"time":"2024-02-22 21:43:19 WET+0000","value":0},{"time":"2024-02-22 21:48:24 WET+0000","value":0},{"time":"2024-02-22 21:53:29 WET+0000","value":0},{"time":"2024-02-23 07:16:21 WET+0000","value":0},{"time":"2024-02-23 07:21:26 WET+0000","value":0.018},{"time":"2024-02-23 07:26:31 WET+0000","value":0},{"time":"2024-02-23 07:31:36 WET+0000","value":0},{"time":"2024-02-23 07:36:41 WET+0000","value":0.067},{"time":"2024-02-23 07:41:46 WET+0000","value":0.118},{"time":"2024-02-23 07:46:51 WET+0000","value":0.112},{"time":"2024-02-23 07:51:56 WET+0000","value":0.166},{"time":"2024-02-23 07:57:01 WET+0000","value":0.528},{"time":"2024-02-23 08:02:06 WET+0000","value":0.709},{"time":"2024-02-23 08:07:11 WET+0000","value":0.766},{"time":"2024-02-23 08:12:16 WET+0000","value":0.845},{"time":"2024-02-23 08:17:21 WET+0000","value":0.918},{"time":"2024-02-23 08:22:26 WET+0000","value":1.073},{"time":"2024-02-23 08:27:31 WET+0000","value":1.552},{"time":"2024-02-23 08:32:36 WET+0000","value":0.488},{"time":"2024-02-23 08:37:41 WET+0000","value":0.156},{"time":"2024-02-23 08:42:46 WET+0000","value":0.196},{"time":"2024-02-23 08:47:51 WET+0000","value":0.447},{"time":"2024-02-23 08:52:56 WET+0000","value":1.427},{"time":"2024-02-23 08:58:01 WET+0000","value":1.595},{"time":"2024-02-23 09:03:06 WET+0000","value":1.642},{"time":"2024-02-23 09:08:11 WET+0000","value":1.653},{"time":"2024-02-23 09:13:16 WET+0000","value":1.689},{"time":"2024-02-23 09:18:21 WET+0000","value":1.689},{"time":"2024-02-23 09:23:26 WET+0000","value":1.751},{"time":"2024-02-23 09:28:31 WET+0000","value":2.235},{"time":"2024-02-23 09:33:36 WET+0000","value":0.913},{"time":"2024-02-23 09:38:41 WET+0000","value":0.29},{"time":"2024-02-23 09:43:46 WET+0000","value":0.373},{"time":"2024-02-23 09:48:51 WET+0000","value":1.388},{"time":"2024-02-23 09:53:56 WET+0000","value":2.097},{"time":"2024-02-23 09:59:01 WET+0000","value":2.057},{"time":"2024-02-23 10:04:06 WET+0000","value":1.934},{"time":"2024-02-23 10:09:11 WET+0000","value":2.173},{"time":"2024-02-23 10:14:16 WET+0000","value":2.198},{"time":"2024-02-23 10:19:21 WET+0000","value":0.709},{"time":"2024-02-23 10:24:26 WET+0000","value":0.456},{"time":"2024-02-23 10:29:31 WET+0000","value":2.4},{"time":"2024-02-23 10:34:36 WET+0000","value":2.6},{"time":"2024-02-23 10:39:41 WET+0000","value":0.327},{"time":"2024-02-23 10:44:46 WET+0000","value":0.469},{"time":"2024-02-23 10:49:51 WET+0000","value":0.874},{"time":"2024-02-23 10:54:56 WET+0000","value":2.659},{"time":"2024-02-23 11:00:01 WET+0000","value":2.603},{"time":"2024-02-23 11:05:06 WET+0000","value":2.607},{"time":"2024-02-23 11:10:11 WET+0000","value":0.911},{"time":"2024-02-23 11:15:16 WET+0000","value":2.579},{"time":"2024-02-23 11:20:21 WET+0000","value":2.611},{"time":"2024-02-23 11:25:26 WET+0000","value":2.531},{"time":"2024-02-23 11:30:31 WET+0000","value":0.723},{"time":"2024-02-23 11:35:36 WET+0000","value":2.598},{"time":"2024-02-23 11:40:41 WET+0000","value":2.6},{"time":"2024-02-23 11:45:46 WET+0000","value":0.369},{"time":"2024-02-23 11:50:51 WET+0000","value":2.604},{"time":"2024-02-23 11:55:56 WET+0000","value":0.766},{"time":"2024-02-23 12:01:01 WET+0000","value":0.84},{"time":"2024-02-23 12:06:06 WET+0000","value":1.112},{"time":"2024-02-23 12:11:11 WET+0000","value":1.313},{"time":"2024-02-23 12:16:16 WET+0000","value":2.441},{"time":"2024-02-23 12:21:21 WET+0000","value":2.613},{"time":"2024-02-23 12:26:26 WET+0000","value":0.702},{"time":"2024-02-23 12:31:31 WET+0000","value":0.54},{"time":"2024-02-23 12:36:36 WET+0000","value":0.791},{"time":"2024-02-23 12:41:41 WET+0000","value":2.609},{"time":"2024-02-23 12:46:46 WET+0000","value":0.942},{"time":"2024-02-23 12:51:51 WET+0000","value":1.156},{"time":"2024-02-23 12:56:56 WET+0000","value":0.993},{"time":"2024-02-23 13:02:01 WET+0000","value":0.965},{"time":"2024-02-23 13:07:06 WET+0000","value":0.355},{"time":"2024-02-23 13:12:12 WET+0000","value":0.636},{"time":"2024-02-23 13:17:17 WET+0000","value":1.375},{"time":"2024-02-23 13:22:22 WET+0000","value":1.141},{"time":"2024-02-23 13:27:27 WET+0000","value":1.365},{"time":"2024-02-23 13:32:32 WET+0000","value":0.666},{"time":"2024-02-23 13:37:37 WET+0000","value":0.628},{"time":"2024-02-23 13:42:42 WET+0000","value":2.097},{"time":"2024-02-23 13:47:47 WET+0000","value":2.139},{"time":"2024-02-23 13:52:52 WET+0000","value":1.708},{"time":"2024-02-23 13:57:57 WET+0000","value":0.902},{"time":"2024-02-23 14:03:02 WET+0000","value":0.721},{"time":"2024-02-23 14:08:07 WET+0000","value":1.072},{"time":"2024-02-23 14:13:12 WET+0000","value":0.427},{"time":"2024-02-23 14:18:17 WET+0000","value":0.389},{"time":"2024-02-23 14:23:22 WET+0000","value":0.428},{"time":"2024-02-23 14:28:27 WET+0000","value":2.072},{"time":"2024-02-23 14:33:32 WET+0000","value":0.578},{"time":"2024-02-23 14:38:37 WET+0000","value":0.511},{"time":"2024-02-23 14:43:42 WET+0000","value":1.357},{"time":"2024-02-23 14:48:47 WET+0000","value":0.61},{"time":"2024-02-23 14:53:52 WET+0000","value":0.38},{"time":"2024-02-23 14:58:57 WET+0000","value":1.514},{"time":"2024-02-23 15:04:02 WET+0000","value":0.474},{"time":"2024-02-23 15:09:07 WET+0000","value":0.521},{"time":"2024-02-23 15:14:12 WET+0000","value":0.472},{"time":"2024-02-23 15:19:17 WET+0000","value":0.532},{"time":"2024-02-23 15:24:22 WET+0000","value":0.994},{"time":"2024-02-23 15:29:27 WET+0000","value":1.105}],"name":"PVPower","variable":"pvPower"}],"deviceSN":"60GS2520297B039"}]}

[FozzieUK]

@tiagomlalves on your last example where the filters weren’t working

{
  "method": "POST",
  "headers": {
    "Content-Type": "application/json",
    "token": ***********,
    "signature": "fa6332c10586b382f4ac3e1daaa8ccaa",
    "timestamp": "1708702363609",
    "lang": "en",
    "User-Agent": "curl/7.64.1"
  },
  "body": {
    "sn": "60GS2520297B039",
    "begin:": 1708308000000,
    "end": 1708380000000,
    "variables": ["pvPower"]
  }
}

you are missing opening and closing quotes on your timestamp placeholders, it should be:-

{
  "method": "POST",
  "headers": {
    "Content-Type": "application/json",
    "token": ***********,
    "signature": "fa6332c10586b382f4ac3e1daaa8ccaa",
    "timestamp": "1708702363609",
    "lang": "en",
    "User-Agent": "curl/7.64.1"
  },
  "body": {
    "sn": "60GS2520297B039",
    "begin:": “1708308000000”,
    "end": “1708380000000”,
    "variables": ["pvPower"]
  }
}```

[tiagomlalves]

@FozzieUK Thanks for looking into this. I've tried adding the quotes as you suggested but I get the same result. The documentation states that begin and end are number and their example shows numbers and not strings.

Sharing the request using strings for 2024-02-21 and the response. What I find interesting is that I'm getting data since 2024-02-20, from the 16h50(same time I've done request now)

{
  "method": "POST",
  "headers": {
    "Content-Type": "application/json",
    "token": **********,
    "signature": "62e70121a8299c4b6fc9ad12fd160f5b",
    "timestamp": "1708707007315",
    "lang": "en",
    "User-Agent": "curl/7.64.1"
  },
  "body": {
    "sn": "60GS2520297B039",
    "begin:": "1708480800000",
    "end": "1708552800000",
    "variables": [
      "pvPower"
    ]
  }
}

Response:

{"errno":0,"msg":"success","result":[{"datas":[{"unit":"kW","data":[{"time":"2024-02-20 16:53:15 WET+0000","value":0.213}, ... ,{"time":"2024-02-23 16:45:42 WET+0000","value":0.293}],"name":"PVPower","variable":"pvPower"}],"deviceSN":"60GS2520297B039"}]}

[FozzieUK]

@tiagomlalves hmmm strange, your timestamps all look good - i’ll try again later with a similar timespan to you and see what I get in return.

[tiagomlalves]

@FozzieUK thank you. Having someone double check these results gave me a lot of sanity already. I appreciate it lot. Thanks again.

I suspect the issue being from FoxESS side in combination with my inverter being one of the newer/cheaper S2500-G2 models which are missing several features when compared to the H/F series. Let's see what the FoxESS support folks reply to the case I opened.

[FozzieUK]

@tiagomlalves
Ok this is for the same time range you have used, i’ve included my headers, body and the response (which again responds correctly for the range of those timestamps)

The only differences I see are timezone (I am GMT whereas you are WET - I wonder if it gets that from our plant details or via the http request), and the user-agent is as specified in their document which is obviously very different to your CURL - I can’t see that causing this but it is worth eliminating if possible.

So far i’ve only seen one minor problem with data through the openAPI (for the new KH series) but it was only a scaling problem, this is very different.

OA headers {'token': '2c557f7f-1ae8-46af-bb78-a124adbbd22b', 'lang': 'en', 'timestamp': '1708710527248', 'Content-Type': 'application/json', 'signature': 'cc3cf7fc7a128663c0dd8d40743fd55d', 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 'Connection': 'close'}

OA body request:{"sn":"60BH123456AB12","begin":"1708480800000", "end":"1708552800000", "variables":["pvPower"]}

OA Response: {'errno': 0, 'msg': 'success', 'result': [{'datas': [{'unit': 'kW', 'data': [{'time': '2024-02-21 02:02:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:07:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:12:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:17:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:22:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:27:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:32:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:37:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:42:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:47:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:52:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 02:57:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:02:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:07:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:12:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:17:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:22:54 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:27:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:32:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:37:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:42:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:47:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:52:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 03:57:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:02:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:07:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:12:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:17:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:22:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:27:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:32:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:37:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:42:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:47:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:52:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 04:57:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:02:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:07:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:12:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:17:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:22:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:27:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:32:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:37:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:42:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:47:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:52:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 05:57:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:02:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:07:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:12:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:17:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:22:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:27:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:32:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:37:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:42:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:47:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:52:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 06:57:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:02:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:07:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:12:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:17:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:22:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:27:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:32:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:37:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:42:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:47:55 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:52:56 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 07:57:56 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 08:02:56 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 08:07:56 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 08:12:56 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 08:17:56 GMT+0000', 'value': 0.019}, {'time': '2024-02-21 08:22:56 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 08:27:56 GMT+0000', 'value': 0.035}, {'time': '2024-02-21 08:32:56 GMT+0000', 'value': 0.028999999999999998}, {'time': '2024-02-21 08:37:56 GMT+0000', 'value': 0.032}, {'time': '2024-02-21 08:42:56 GMT+0000', 'value': 0.036000000000000004}, {'time': '2024-02-21 08:47:56 GMT+0000', 'value': 0.037000000000000005}, {'time': '2024-02-21 08:52:56 GMT+0000', 'value': 0.057999999999999996}, {'time': '2024-02-21 08:57:56 GMT+0000', 'value': 0.075}, {'time': '2024-02-21 09:02:56 GMT+0000', 'value': 0.076}, {'time': '2024-02-21 09:07:56 GMT+0000', 'value': 0.036}, {'time': '2024-02-21 09:12:56 GMT+0000', 'value': 0.078}, {'time': '2024-02-21 09:17:56 GMT+0000', 'value': 0.094}, {'time': '2024-02-21 09:22:56 GMT+0000', 'value': 0.146}, {'time': '2024-02-21 09:27:56 GMT+0000', 'value': 0.146}, {'time': '2024-02-21 09:32:56 GMT+0000', 'value': 0.15}, {'time': '2024-02-21 09:37:56 GMT+0000', 'value': 0.145}, {'time': '2024-02-21 09:42:56 GMT+0000', 'value': 0.16699999999999998}, {'time': '2024-02-21 09:47:56 GMT+0000', 'value': 0.173}, {'time': '2024-02-21 09:52:56 GMT+0000', 'value': 0.21300000000000002}, {'time': '2024-02-21 09:57:56 GMT+0000', 'value': 0.25}, {'time': '2024-02-21 10:02:56 GMT+0000', 'value': 0.305}, {'time': '2024-02-21 10:07:56 GMT+0000', 'value': 0.242}, {'time': '2024-02-21 10:12:56 GMT+0000', 'value': 0.261}, {'time': '2024-02-21 10:17:56 GMT+0000', 'value': 0.183}, {'time': '2024-02-21 10:22:56 GMT+0000', 'value': 0.257}, {'time': '2024-02-21 10:27:56 GMT+0000', 'value': 0.233}, {'time': '2024-02-21 10:32:56 GMT+0000', 'value': 0.245}, {'time': '2024-02-21 10:37:56 GMT+0000', 'value': 0.226}, {'time': '2024-02-21 10:42:56 GMT+0000', 'value': 0.179}, {'time': '2024-02-21 10:47:56 GMT+0000', 'value': 0.147}, {'time': '2024-02-21 10:52:56 GMT+0000', 'value': 0.144}, {'time': '2024-02-21 10:57:56 GMT+0000', 'value': 0.18}, {'time': '2024-02-21 11:02:56 GMT+0000', 'value': 0.141}, {'time': '2024-02-21 11:07:56 GMT+0000', 'value': 0.144}, {'time': '2024-02-21 11:12:56 GMT+0000', 'value': 0.173}, {'time': '2024-02-21 11:17:56 GMT+0000', 'value': 0.144}, {'time': '2024-02-21 11:22:56 GMT+0000', 'value': 0.169}, {'time': '2024-02-21 11:27:56 GMT+0000', 'value': 0.187}, {'time': '2024-02-21 11:32:56 GMT+0000', 'value': 0.184}, {'time': '2024-02-21 11:37:56 GMT+0000', 'value': 0.251}, {'time': '2024-02-21 11:42:56 GMT+0000', 'value': 0.315}, {'time': '2024-02-21 11:47:56 GMT+0000', 'value': 0.252}, {'time': '2024-02-21 11:52:56 GMT+0000', 'value': 0.185}, {'time': '2024-02-21 11:57:56 GMT+0000', 'value': 0.45699999999999996}, {'time': '2024-02-21 12:02:56 GMT+0000', 'value': 0.398}, {'time': '2024-02-21 12:07:56 GMT+0000', 'value': 0.35}, {'time': '2024-02-21 12:12:56 GMT+0000', 'value': 0.377}, {'time': '2024-02-21 12:17:57 GMT+0000', 'value': 0.43400000000000005}, {'time': '2024-02-21 12:22:57 GMT+0000', 'value': 0.374}, {'time': '2024-02-21 12:27:57 GMT+0000', 'value': 0.481}, {'time': '2024-02-21 12:32:57 GMT+0000', 'value': 0.357}, {'time': '2024-02-21 12:37:57 GMT+0000', 'value': 0.222}, {'time': '2024-02-21 12:42:57 GMT+0000', 'value': 0.25}, {'time': '2024-02-21 12:47:57 GMT+0000', 'value': 0.375}, {'time': '2024-02-21 12:52:57 GMT+0000', 'value': 0.311}, {'time': '2024-02-21 12:57:57 GMT+0000', 'value': 0.599}, {'time': '2024-02-21 13:02:57 GMT+0000', 'value': 0.324}, {'time': '2024-02-21 13:07:57 GMT+0000', 'value': 0.315}, {'time': '2024-02-21 13:12:57 GMT+0000', 'value': 0.475}, {'time': '2024-02-21 13:17:57 GMT+0000', 'value': 0.45100000000000007}, {'time': '2024-02-21 13:22:57 GMT+0000', 'value': 0.567}, {'time': '2024-02-21 13:27:57 GMT+0000', 'value': 0.656}, {'time': '2024-02-21 13:32:57 GMT+0000', 'value': 0.702}, {'time': '2024-02-21 13:37:57 GMT+0000', 'value': 0.46}, {'time': '2024-02-21 13:42:57 GMT+0000', 'value': 0.321}, {'time': '2024-02-21 13:47:57 GMT+0000', 'value': 0.53}, {'time': '2024-02-21 13:52:57 GMT+0000', 'value': 0.521}, {'time': '2024-02-21 13:57:57 GMT+0000', 'value': 0.556}, {'time': '2024-02-21 14:02:57 GMT+0000', 'value': 0.535}, {'time': '2024-02-21 14:07:57 GMT+0000', 'value': 0.473}, {'time': '2024-02-21 14:12:57 GMT+0000', 'value': 0.421}, {'time': '2024-02-21 14:17:57 GMT+0000', 'value': 0.397}, {'time': '2024-02-21 14:22:57 GMT+0000', 'value': 0.412}, {'time': '2024-02-21 14:27:57 GMT+0000', 'value': 0.644}, {'time': '2024-02-21 14:32:57 GMT+0000', 'value': 0.8759999999999999}, {'time': '2024-02-21 14:37:57 GMT+0000', 'value': 0.454}, {'time': '2024-02-21 14:42:57 GMT+0000', 'value': 0.458}, {'time': '2024-02-21 14:47:57 GMT+0000', 'value': 0.34099999999999997}, {'time': '2024-02-21 14:52:57 GMT+0000', 'value': 0.66}, {'time': '2024-02-21 14:57:57 GMT+0000', 'value': 0.675}, {'time': '2024-02-21 15:02:57 GMT+0000', 'value': 0.878}, {'time': '2024-02-21 15:07:57 GMT+0000', 'value': 0.5509999999999999}, {'time': '2024-02-21 15:12:57 GMT+0000', 'value': 0.604}, {'time': '2024-02-21 15:17:57 GMT+0000', 'value': 1.818}, {'time': '2024-02-21 15:22:57 GMT+0000', 'value': 1.91}, {'time': '2024-02-21 15:27:57 GMT+0000', 'value': 1.7229999999999999}, {'time': '2024-02-21 15:32:57 GMT+0000', 'value': 1.851}, {'time': '2024-02-21 15:37:57 GMT+0000', 'value': 1.4060000000000001}, {'time': '2024-02-21 15:42:57 GMT+0000', 'value': 1.3459999999999999}, {'time': '2024-02-21 15:47:57 GMT+0000', 'value': 1.288}, {'time': '2024-02-21 15:52:57 GMT+0000', 'value': 1.4200000000000002}, {'time': '2024-02-21 15:57:57 GMT+0000', 'value': 1.141}, {'time': '2024-02-21 16:02:57 GMT+0000', 'value': 0.782}, {'time': '2024-02-21 16:07:57 GMT+0000', 'value': 1.151}, {'time': '2024-02-21 16:12:57 GMT+0000', 'value': 0.269}, {'time': '2024-02-21 16:17:57 GMT+0000', 'value': 0.223}, {'time': '2024-02-21 16:22:57 GMT+0000', 'value': 0.2}, {'time': '2024-02-21 16:27:57 GMT+0000', 'value': 0.21100000000000002}, {'time': '2024-02-21 16:32:57 GMT+0000', 'value': 0.125}, {'time': '2024-02-21 16:37:58 GMT+0000', 'value': 0.101}, {'time': '2024-02-21 16:42:58 GMT+0000', 'value': 0.088}, {'time': '2024-02-21 16:47:58 GMT+0000', 'value': 0.087}, {'time': '2024-02-21 16:52:58 GMT+0000', 'value': 0.11399999999999999}, {'time': '2024-02-21 16:57:58 GMT+0000', 'value': 0.079}, {'time': '2024-02-21 17:02:58 GMT+0000', 'value': 0.074}, {'time': '2024-02-21 17:07:58 GMT+0000', 'value': 0.04}, {'time': '2024-02-21 17:12:58 GMT+0000', 'value': 0.051000000000000004}, {'time': '2024-02-21 17:17:58 GMT+0000', 'value': 0.021}, {'time': '2024-02-21 17:22:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 17:27:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 17:32:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 17:37:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 17:42:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 17:47:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 17:52:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 17:57:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:02:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:07:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:12:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:17:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:22:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:27:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:32:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:37:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:42:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:47:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:52:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 18:57:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:02:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:07:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:12:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:17:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:22:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:27:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:32:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:37:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:42:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:47:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:52:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 19:57:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:02:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:07:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:12:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:17:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:22:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:27:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:32:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:37:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:42:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:47:58 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:52:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 20:57:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:02:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:07:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:12:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:17:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:22:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:27:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:32:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:37:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:42:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:47:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:52:59 GMT+0000', 'value': 0.0}, {'time': '2024-02-21 21:57:59 GMT+0000', 'value': 0.0}], 'name': 'PVPower', 'variable': 'pvPower'}], 'deviceSN': '60BH123456AB12'}]}

[tiagomlalves]

@FozzieUK I appreciate a lot you sharing more details. I've tried your token+SN in my code and I got:

{ "errno": 0, "msg": "success", "result": null }

You might want to change your token if you haven't done it already - or maybe you have changed and that's why I'm getting the results above 😄

I've tried again using my token and my SN, and that's when I discovered the mistake I made: I was sending "begin:": "1708480800000", note that I have an extra colon after the begin 😵‍💫
After fixing that, I'm now able to fetch the historical data correctly.

I've also validated that using "User-Agent": "curl/7.64.1" is fine, and using numbers (instead of stings) in begin and end also works correctly.

Thank you so much for your help!

[FozzieUK]

@tiagomlalves great, glad you got that working - frustrating that both of us looked at that and missed the extra colon 🙄

No problem with the token, it is for my test system and I left in anticipating you would want to try it - it's changed again now 👍