Tables

[tnesheim 8]

Hi

I've been able to connect to the central Norwegian public transport information hub to get subway departure times. The response I get looks like this:

 

{"data":{"quay":{"estimatedCalls":[{"destinationDisplay":{"frontText":"Bergkrystallen via Storo"},"aimedArrivalTime":"2019-09-09T09:50:00+0200"},{"destinationDisplay":{"frontText":"Ringen via Tøyen"},"aimedArrivalTime":"2019-09-09T09:59:00+0200"},{"destinationDisplay":{"frontText":"Bergkrystallen via Storo"},"aimedArrivalTime":"2019-09-09T10:05:00+0200"},{"destinationDisplay":{"frontText":"Ringen via Tøyen"},"aimedArrivalTime":"2019-09-09T10:14:00+0200"}]}}}

 

It looks like a table(?), but how can I "read out" spesific information?

[Sankotronic 2,091]

1 hour ago, tnesheim said:

Hi

I've been able to connect to the central Norwegian public transport information hub to get subway departure times. The response I get looks like this:

 

 

Hi @tnesheim ,

 

the above is JSON table and here is how structure can be better shown for easier reading:

 

Please login or register to see this code.

 

I also provided short code that will print all destinations with aimed arrival time just as example how to read table structure. Above code assumes that received data is stored in local variable response. For complicated table data I use editors that highlight closing brackets like ZeroBrane Studio. Also Firefox can be used to show nicely JSON responses.

 

[tnesheim 8]

Thanks a lot. This will give me a good start to work further on. But to get there I need to overcome a few issues. The first is that the json.decode gives an error code saying that it get a table but expects a string. Also, it seems difficult to get the values of an variable outside the http:response function....reports NIL...

 

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

local payload=tostring('{quay(id:"NSR:Quay:10825"){estimatedCalls(timeRange: 72100, numberOfDepartures: 4){destinationDisplay{frontText}aimedArrivalTime}}}')
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) end,
           error  =  function (err) fibaro:debug ("Error: "  .. err) end
   })

          local jW=json.encode(response)
      local jW=response.data
      for i=1, #jW.data.quay.estimatedCalls do
      fibaro:debug(string.format("Destination No. %s, name: %s arrival time: %s",i,jW.data.quay.estimatedCalls.destinationDisplay.frontText,jW.data.quay.estimatedCalls.aimedArrivalTime))
      end

[tnesheim 8]

I'we used a global variale to get the data out of the "http:request loop", and I have also simplified your code:

 

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

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

 

Whatever I do I get a NIL-error returned in the third code line...

[Sankotronic 2,091]

Hi @tnesheim ,

 

What is received under the data part fo the response table is not actually JSON but some kind of their format. Anyway, to get table it is needed to get rid of the character "\" from the string and then it can be finally decoded properly to the table. Here is code that I tested and is working:

 

Please login or register to see this spoiler.

 

Now you can finally get results of query and display them on for example virtual device.

 

Enjoy coding  

Edited September 9, 2019 by Sankotronic