AnsweredAssumed Answered

How to userJSON Array format?

Question asked by sauloimg-com-br-esridist Employee on Aug 8, 2016

Hi,

 

I need to receive Bus GPS real time data, but the format is JSON Array. I would to like to know if is it possible? Have I to create a new connector? Or can I use the existing Inputs?

Link to JSON: http://dadosabertos.rio.rj.gov.br/apiTransporte/apresentacao/rest/index.cfm/obterTodasPosicoes

 

Format Sample:

{"COLUMNS": ["DATAHORA","ORDEM","LINHA","LATITUDE","LONGITUDE","VELOCIDADE"],"DATA":[["03- 17-2014 01:59:54","A41100",463.0,-22.875017,-43.240868,0.37],["03-17-2014 02:02:33","A63531","",-22.79224,-43.2943,0.0],["03-17-2014 02:47:01","B60036","",-22.815201,-43.385731,0.0],["03-17-2014 03:18:09","D86384","",-22.895077,-43.532177,0.0],["03-17-2014 03:22:09","A29052",474.0,-22.868019,-43.29221,0.0],["03-17-2014 03:26:53","A41080","",-22.875423,-43.240398,0.0],["03-17-2014 10:20:22","B32567",342.0,-22.90797,-43.184849,0.0]]}

 

Thank you,

Outcomes