External eletric pricing on API

[Tue]

Hello there

I'm newbee to scripting to a API, I need you help to get me startet. I can from bellow link get the eletric pricing for the next 24 hours (is updated everyday at 14:00 for the next day)

https://api.energidataservice.dk/datasto...rDK%22:%222022-02-09T10:00:00%22,%22PriceArea%22:%22DK1%22%7D

I do have some docomentation for it:

https://www.energidataservice.dk/guides/api-guides

And I do know that I need to make some ssl.https.request(url) there I change from current time (date = os.date('*t')) and make a new string with date.time and so on. But anybody that can help me in the right directions?

I want to make a routine that charges my eletrich car in the correct time, I ca get acces to my car date here: https://www.platform.tronity.io/ (still working progess on how for me :-)) https://app.platform.tronity.io/docs

In advance thx

[Tue]

Hello there

I'm newbee to scripting to a API, I need you help to get me startet. I can from bellow link get the eletric pricing for the next 24 hours (is updated everyday at 14:00 for the next day)

https://api.energidataservice.dk/datasto...rDK%22:%222022-02-09T10:00:00%22,%22PriceArea%22:%22DK1%22%7D

I do have some docomentation for it:

https://www.energidataservice.dk/guides/api-guides

And I do know that I need to make some ssl.https.request(url) there I change from current time (date = os.date('*t')) and make a new string with date.time and so on. But anybody that can help me in the right directions?

I want to make a routine that charges my eletrich car in the correct time, I ca get acces to my car date here: https://www.platform.tronity.io/ (still working progess on how for me :-)) https://app.platform.tronity.io/docs

In advance thx

This is what I got so far, how do I decode json in Lua?

Code:

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980

--[[************************************************************************************************ Created: 2022-02-09 Get eletric pricing from Norpol and set car charge when good :-) ************************************************************************************************]]-- require('json') https = require 'ssl.https' local date = os.date('*t') local data = ' ' local url = ' ' for i=1, 24 do   date.hour = date.hour + 1   if date.hour > 23 then     date.day = date.day + 1     date.hour = 0   end  -- Missing if month changes or year (to come later)       data = date.year .. '-' .. date.month .. '-' .. date.day .. 'T' .. date.hour .. ':00:00' -- Make the date/clock string to request     url = 'https://api.energidataservice.dk/datastore_search?resource_id=elspotprices&filters=%7B%22HourDK%22:%22' .. data .. '%22,%22PriceArea%22:%22DK1%22%7D' -- Here is the requst string :-)     status = ssl.https.request(url) -- Here comes reply from server   log(status) -- How do I decode it and get it into a time table end --[[ This is returned format..: {   "help": "https://api.energidataservice.dk/help_show?name=datastore_search",   "success": true,   "result": {     "include_total": true,     "resource_id": "c86859d2-942e-4029-aec1-32d56f1a2e5d",     "fields": [       {         "type": "int",         "id": "_id"       },       {         "type": "timestamptz",         "id": "HourUTC"       },       {         "type": "timestamp",         "id": "HourDK"       },       {         "type": "text",         "id": "PriceArea"       },       {         "type": "float8",         "id": "SpotPriceDKK"       },       {         "type": "float8",         "id": "SpotPriceEUR"       }     ],     "records_format": "objects",     "records": [       {         "_id": 2023070,         "HourUTC": "2022-02-09T09:00:00+00:00",         "HourDK": "2022-02-09T10:00:00",         "PriceArea": "DK1",         "SpotPriceDKK": 885.32, <-***************************** This is the value what I need ***********************         "SpotPriceEUR": 118.94       }     ],     "_links": {       "start": "/datastore_search?filters=%7B%22HourDK%22%3A%222022-02-09T10%3A00%3A00%22%2C%22PriceArea%22%3A%22DK1%22%7D&resource_id=elspotprices",       "next": "/datastore_search?offset=100&filters=%7B%22HourDK%22%3A%222022-02-09T10%3A00%3A00%22%2C%22PriceArea%22%3A%22DK1%22%7D&resource_id=elspotprices"     },     "filters": {       "HourDK": "2022-02-09T10:00:00",       "PriceArea": "DK1"     },     "total": 1   } } ]]--

[admin]

Get the date/time for the next hour in proper format:

Code:

1

os.date('%Y-%m-%dT%H:00:00', os.time() + 3600)

Then decode the status data:

Code:

123

data = json.decode(status) price = data.result.records[1].SpotPriceDKK log(price)

[Tue]

Hello there

Thax alot, now that works :-)

Code:

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051

--[[************************************************************************************************ Created: 2022-02-09 Get eletric pricing from Norpol the next 24 hours and set car charge when good :-) It works now, needs to sort out lowest rates and so on ************************************************************************************************]]-- require('json') https = require 'ssl.https' local data = ' ' local url = ' ' local priser = {klokken, pris} local end_i = 11 -- if hour is <= 13 it must stop at 23 hours (no new prices yet) -- if hour is > 13 there are prices until followering midnight (more than 24 hours if tonumber(os.date('%H', os.time())) <= 12 then   end_i = 23 - tonumber(os.date('%H', os.time())) else   end_i = (23 - tonumber(os.date('%H', os.time()))) + 24 end -- Get prices for the next hours, defined in "end_i" -- Prices are from Norpol energy trader -- They are from west region Denmark for i=0, end_i do   data = os.date('%Y-%m-%dT%H:00:00', (os.time() + (3600*i)))     url = 'https://api.energidataservice.dk/datastore_search?resource_id=elspotprices&filters=%7B%22HourDK%22:%22' .. data .. '%22,%22PriceArea%22:%22DK1%22%7D' -- Here is the requst string :-)     status = ssl.https.request(url) -- Here comes reply from server   data = json.decode(status) -- Decode the Json file     price = data.result.records[1].SpotPriceDKK / 1000 -- Find price in DKK ører for bellow time   time = data.result.records[1].HourDK -- Time of above price expected     -- Extra cost from 17 to 20 hour at Konstant net (as we uses)   if (os.date('%H' , (os.time() + (3600*i)))) == '17' or (os.date('%H' , (os.time() + (3600*i)))) == '18' or (os.date('%H' , (os.time() + (3600*i)))) == '19' then     price = price + konstant_ekstra_tariff_17_20   end     priser[i] = {klokken = tonumber(os.date('%H' , os.time() + (3600*i))),pris = price}-- store price and time for price end log(priser) -- Here are recorded data -- find when prices are lowest in the forcast local pos = 0 local tester = 20 for i=0, end_i do   if tester > priser[i].pris then     pos = i     tester = priser[i].pris   end  end log (priser[pos]) -- This is the most cheap hour

now there comes a new challanges, I want to find state of EV car, It is now posible for me to get the POST that makes me get the Bearer Authorization, but cannot get it out of the string?, and from there how do I make ep GET command with it?

Code:

123456789101112131415161718192021222324252627282930

--[[************************************************************************************************ Created: 2022-02-10 Get state of charge from car ************************************************************************************************]]-- require('socket.http') function encodepost(t)   local res = {}   local esc = require('socket.url').escape   for k, v in pairs(t) do     res[ #res + 1 ] = esc(k) .. '=' .. esc(v)   end   return table.concat(res, '&') end url = 'https://api-eu.TRONITY.io/oauth/authentication' payload = encodepost({   client_id = "WRITE IT HERE",   client_secret = "WRITE IT HERE",   grant_type = "app" }) res, err, headers, status = socket.http.request(url, payload) --log(res, err, headers, status) if err == 201 then -- Get Bearer Authorization     log(res) -- Here is the Bearer Authorization in how do I get the access_token out? And how do I do a json GET with that token? end

THIS IS MY res string, where I need to get access_token value/string out from:

string: {"id":"cfed0e4d6351407dae165944745d48f","access_token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJjZmVkMGU0ZC02MzUxLTQwN2QtYWUxNi0yNTk0NDc0NWQ0OGYiLCJhcHBJZCI6Ijg3NzhjMTM4LTQ0ODgtNGU2Ni1iMmZhLTY3NGUyYmQ2NGYyMiIsInZlaGljbGVJZCI6bnVsbCwic2NvcGVzIjpbInJlYWRfYmF0dGVyeSIsInJlYWRfY2FyZHMiLCJyZWFkX2NoYXJnZXBvaW50cyIsInJlYWRfaWRsZXMiLCJyZWFkX2xvY2F0aW9uIiwicmVhZF9vZG9tZXRlciIsInJlYWeHAiOjE2NDQ1OTU0ODQsImF1ZCI6Imh0dHBzOi8vcGxhdGZvcm0udHJvbml0eS5pbyIsImlzcyI6InBsYXRmb3JtLnRyb25pdHkuaW8ifQ.AWboomF9whW6udiSzWsWyWvlhu9ZpmdEN9IKrbFOHIM","expires_in":3600,"token_type":"bearer"}

And this is my URL I need to GET with above bearer Authorization

url = 'https://api-eu.TRONITY.io/v1/vehicles/{CAR ID HERE}/bulk'

[Erwin van der Zwart]

Code:

123456789101112131415

require('json') if err == 201 then -- Get Bearer Authorization    --log(res) -- Here is the Bearer Authorization in how do I get the access_token out? And how do I do a json GET with that token?     data = json.pdecode(res)   tokentype = data.token_type   accesstoken = data.access_token   expiresin = data.expires_in   id = data.id   log(tokentype)   log(accesstoken)   log(expiresin)   log(id) end

Here is an sample of integration i wrote with authentication token renewal that uses the expire stamp of the token, with this sample you should be able to create what you want to do

Code:

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110

-- Load required packages require('ltn12') require('socket.http') require("json") -- START OF SETTINGS ************************************************************ -- Set credentials username = "xxxxx" password = "xxxxx" -- END OF SETTINGS ************************************************************** -- START OF FUNCTIONS *********************************************************** function GetAuthData()   local request_url = 'https://xxxx.com/api/v3/xxx/auth'   local response_body = {}   local request_body = json.encode(     {       email = username,       password = password     }   )   local body, code, hdrs, stat = socket.http.request{     url = request_url;     method = "POST";     headers =     {       ["Content-Type"] = "application/json";       ["Content-Length"] = #request_body;     };     source = ltn12.source.string(request_body);     sink = ltn12.sink.table(response_body);   }   if code == 200 then     ret = table.concat(response_body)     ret = json.pdecode(ret)     ret.expires_at = os.time() + ret.expires_in     return ret   end end function APIRequest(method, api_key, request, requestdata)   local request_url = 'https://xxxx.xxxx.com/api/v3' .. request   local response_body = {}   local request_body = requestdata   local body, code, hdrs, stat = socket.http.request{     url = request_url;     method = method;     headers =     {       ["Content-Type"] = "application/json";       ['Content-Length'] = #request_body,       ["Api_key"] = api_key;     };     source = ltn12.source.string(request_body);     sink = ltn12.sink.table(response_body);   }   if code == 200 then     ret = table.concat(response_body)     ret = json.pdecode(ret)     return ret   end end -- END OF FUNCTIONS *********************************************************** -- START OF AUTHENTICATION **************************************************** if not authdata then   authdata = GetAuthData() else   if authdata.expires_at - 60 < os.time() then     -- renew authdata     authdata = GetAuthData()   end end -- END OF AUTENTHICATION ****************************************************** -- START OF DATA REQUESTS ***************************************************** request_data = json.encode({}) resp = APIRequest("GET", authdata.api_key, "/location", request_data) log(resp) -- END OF DATA REQUESTS ******************************************************* -- START OF UPDATE REQUESTS *************************************************** request_data = json.encode({   id = 12,   customproperties = {     {       label = "mylabel",       value = "myvalue"     }   } } ) resp = APIRequest("PUT", authdata.api_key, "/probe", request_data) log(resp) request_data = json.encode({   id = 12,   name = "new name" } ) resp = APIRequest("PUT", authdata.api_key, "/location", request_data) log(resp) -- END OF UPDATE REQUESTS *****************************************************

[Tue]

Got up running THX :-) when done I will post the source code here if anybody else need it :-)

Now I want to edit a Schedule, lets call them, Charge_ev_in_min

How do I edit a schedule from script? I need to do the following:
Set time and date for start
Set value (0-600)
Disable scheduler
Enable scheduler