question

nir-fsight avatar image
nir-fsight asked

Missing data in API and VRM portal export

HI,

I am using the API in order to collect status information about my systems (7 in total).

Currently, "bs" (Battery State of Charge) is empty for all systems.

was something changed?


In addition, when I try to export data from the vrm portal in KWH units(15 minutes) - I get an empty file, while if I try to get the kw data (1 minute) - I get all the data

Is there a fault on the server-side?


Thanks

VRM
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

6 Answers
Teun Lassche avatar image
Teun Lassche answered ·

Hi @nir_fsight,

I can query the `bs` for some installations just fine. Can you link me your VRM installation?


Regarding the kWh export: which export are you referring to and do you download it from VRM or the API?

2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

nir-fsight avatar image
nir-fsight answered ·

Hi,

Thank you for the prompt reply.

For example, you can test installation ID is 35484

Attached please find an image with the marking of what is working and what is not.


1596458458646.png (408.8 KiB)
2 comments
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

Teun Lassche avatar image Teun Lassche ♦ commented ·

Thanks.

First the bs issue, I just checked your instance and it reports bs just fine:

curl 'https://vrmapi.victronenergy.com/v2/installations/35484/stats?end=1596462000&interval=hours&start=1596402000&type=custom&attributeCodes[]=bs' \
  -H 'Connection: keep-alive' \
  -H 'Pragma: no-cache' \
  -H 'Cache-Control: no-cache' \
  -H 'Accept: application/json, text/plain, */*' \
  -H 'X-Authorization: Bearer <token>' \
  -H 'Origin: https://vrm.victronenergy.com' 
  --compressed
{"success":true,"records":{"bs":[[1596402000000,100,100,100],[1596405600000,100,100,100],[1596409200000,100,100,100],[1596412800000,100,100,100],[1596416400000,100,100,100],[1596420000000,100,100,100],[1596423600000,100,100,100],[1596427200000,100,100,100],[1596430800000,100,100,100],[1596434400000,100,100,100],[1596438000000,100,100,100],[1596441600000,100,100,100],[1596445200000,100,100,100],[1596448800000,100,100,100],[1596452400000,100,100,100],[1596456000000,100,100,100],[1596459600000,100,100,100]]},"totals":{"bs":1700}}

Then the kWh download issue. Just downloaded a kWh export of today, which is not empty:


Please note that for those kWh type of data there are certain requirements:

https://www.victronenergy.com/live/vrm_portal:faq#what_are_the_requirements_for_the_solar_yield_and_consumption_tab


0 Likes 0 ·
nir-fsight avatar image nir-fsight Teun Lassche ♦ commented ·

Hi,

I tried to mimic your API request, and I receive an empty response. How is that possible?

0 Likes 0 ·
nir-fsight avatar image
nir-fsight answered ·

HI,

Those two files downloaded this morning at 8:28 local IL time.

https://drive.google.com/drive/folders/1oZkoeN4XlgPL6OBeqtkTTbfawucaW7Qt?usp=sharing


You are correct: the summary file is not empty - it contains one line of data, while the kw info includes more than 500 lines of data. how can it be?


Thanks

nir


2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

nir-fsight avatar image
nir-fsight answered ·

Hi,
I am still encountering the issue.
This is my API request (after perform login and receiving a token):

Request:

https://vrmapi.victronenergy.com/v2/installations/35484/stats?type=custom&attributeCodes[]=bs&attributeCodes[]=Gb&attributeCodes[]=Gc&attributeCodes[]=Bc&attributeCodes[]=Bg&attributeCodes[]=Pg&attributeCodes[]=Pc&attributeCodes[]=Pb&start=1483221600&end=1483308000&interval=15mins

Response:

{"success":true,"records":{"bs":false,"Gb":false,"Gc":false,"Bc":false,"Bg":false,"Pg":false,"Pc":false,"Pb":false},"totals":{"bs":false,"Gb":false,"Gc":false,"Bc":false,"Bg":false,"Pg":false,"Pc":false,"Pb":false}}


When I login to VRM portal I am able to see data for installation 35484

What might be the issue?
Thank you

2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

nir-fsight avatar image
nir-fsight answered ·

HI Guys,

We need your help.


This is my API request (after perform login and receiving a token):


Request:

https://vrmapi.victronenergy.com/v2/installations/35484/stats?type=custom&attributeCodes[]=bs&attributeCodes[]=Gb&attributeCodes[]=Gc&attributeCodes[]=Bc&attributeCodes[]=Bg&attributeCodes[]=Pg&attributeCodes[]=Pc&attributeCodes[]=Pb&start=1483221600&end=1483308000&interval=15mins

Response:

{"success":true,"records":{"bs":false,"Gb":false,"Gc":false,"Bc":false,"Bg":false,"Pg":false,"Pc":false,"Pb":false},"totals":{"bs":false,"Gb":false,"Gc":false,"Bc":false,"Bg":false,"Pg":false,"Pc":false,"Pb":false}}


When I login to VRM portal I am able to see data for installation 35484

What might be the issue?
Thank you

2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

prompt2k2 avatar image
prompt2k2 answered ·

How was this issue resolved. I just compared the energy reading we download via VRM frontend, and the one we downloaded via the API. The API reports lower reading compared to the VRM frontend. How do I correct this?

1 comment
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

João Fernandes avatar image João Fernandes commented ·
I have the exact same situation. The VRM portal shows way more kWh consumed/produced than the data available in the exported files.
0 Likes 0 ·