Table and LUA

[tnesheim 8]

Hi

I´m trying to connect to Entur, the central Norwegian travel information hub, to get subway data to my HC2 for in turn på present this on a small display at my entrance door.

I think I have contact with the server but I need to send a json tabel/structure to get some information in return. This structure is as follows:

 

{
  quay(id: "NSR:Quay:10825") {
    estimatedCalls(timeRange: 72100, numberOfDepartures: 1) {
      aimedArrivalTime
      destinationDisplay {
        frontText
      }
    }
  }
}

 

How must I format this table/structure for in turn to use the json.encode command? I´ve tried in several ways but get error messages...

 

(This in the "generator" of the datastructure I need to send to 

Please login or register to see this link.

 along with some headers )

[jgab 2,642]

2 hours ago, tnesheim said:

Hi

I´m trying to connect to Entur, the central Norwegian travel information hub, to get subway data to my HC2 for in turn på present this on a small display at my entrance door.

I think I have contact with the server but I need to send a json tabel/structure to get some information in return. This structure is as follows:

 

{
  quay(id: "NSR:Quay:10825") {
    estimatedCalls(timeRange: 72100, numberOfDepartures: 1) {
      aimedArrivalTime
      destinationDisplay {
        frontText
      }
    }
  }
}

 

How must I format this table/structure for in turn to use the json.encode command? I´ve tried in several ways but get error messages...

 

(This in the "generator" of the datastructure I need to send to 

Please login or register to see this link.

 along with some headers )

 

I think you are out of luck as the api requires https that is not supported by the HC2.

You could try to proxy it over another computer like a raspberry,,,

[tnesheim 8]

Hi. Thanks, that explains a whole lot!

[tnesheim 8]

@jgab HTTPS is indeed possible. My problem was to send the payload as a string...which I now managed. I got a proper response body from the API.

[AutoFrank 372]

5 hours ago, tnesheim said:

@jgab HTTPS is indeed possible. My problem was to send the payload as a string...which I now managed. I got a proper response body from the API.

@tnesheim

could you publish you solution..

 

thanks

 

[tnesheim 8]

Hi

I managed to get the https-request to work...the missing piece was the header "checkCertificate = false". My next problem btw is to read out data from the json structure... it returns a nil-error whatever I do...

 

 

--[[
%% properties
%% events
%% globals
--]]

--local payload = tostring('{quay(id:"NSR:Quay:10825"){estimatedCalls(timeRange: 72100, numberOfDepartures: 1){aimedArrivalTime}}}')
local payload=tostring('{quay(id:"NSR:Quay:10825"){estimatedCalls(timeRange: 72100, numberOfDepartures: 4){destinationDisplay{frontText}aimedArrivalTime}}}')
--local inndata

local Url = 'https://api.entur.io/journey-planner/v2/graphql'
local httpClient = net.HTTPClient();
httpClient:request(Url, { 
       options = {
       checkCertificate = false,
       method="POST",
       headers={
               ['content-type'] = 'application/graphql', 
               ['ET-Client-Name'] = 'TNsmart-tavle', 
               ['User-Agent'] = 'TNscript for Entur'
               },
       data= payload
       },
           success = function (response) 
--         fibaro:debug(response.data) 
           jvar=json.encode(response.data)
           fibaro:setGlobal("Entur", jvar)    
    
           end,
           error  =  function (err) fibaro:debug ("Error: "  .. err) end
   })

local var=fibaro:getGlobalValue("Entur")
local jW=json.decode(var)

test= jW.data.quay.estimatedCalls[2].aimedArrivalTime
fibaro:debug(test)

[jgab 2,642]

Good news, then the service is not that strict on SSL...

So with asynchronous calls like http:request you have to structure your code a bit different.

 

Please login or register to see this code.

 

Edited September 9, 2019 by jgab

[tnesheim 8]

Aha, this makes sense, asynchronous! Thanks for the code, will try it tonight. 

It probably answers why I observered some things in reverse order?

[jgab 2,642]

35 minutes ago, tnesheim said:

Aha, this makes sense, asynchronous! Thanks for the code, will try it tonight. 

It probably answers why I observered some things in reverse order?

So, if you need to request data with intervals I would recommend a scene structure type below; you 'main' function is driven by your own "events" that tells what to do next; first request, then response, then next request etc... Also use setTimeout to send ourselves "events" in the future (5sec here). setTimeout is also "asynchronous"...

Please login or register to see this code.

 

[tnesheim 8]

Thanks a lot! It works, and even better, since I´m not a programmer by profession I rely on looking at examples made by experts, like piece of code. When I need to connect to another API in the future I know where to look!