Hi everybody I have doubts about how to consume data from a Json web service. I'm going to explain.
I'm trying to consume a Json web service with tracking of buses, so as my input I set as External Website for Json, that a set as the attached file.
When I open the URL on the browser I can see the data, and is like this:
{"COLUMNS":["DATAHORA","ORDEM","LINHA","LATITUDE","LONGITUDE","VELOCIDADE"],"DATA":[["07-03-2017 17:57:31","444014","933.3",-15.84587,-48.122343,23],["07-03-2017 17:57:40","444219","363.1",-15.84801,-48.115563,46],["07-03-2017 17:57:43","444251","933.2",-15.809476,-48.088196,49],["07-03-2017 17:57:31","443956","0.043",-15.803197,-48.025253,26],["07-03-2017 17:57:32","444057","933.1",-15.822888,-48.11473,40],["07-03-2017 17:57:16","444294","933.3",-15.804666,-48.072663,27],["07-03-2017 17:57:12","443913","363.2",-15.820277,-48.107763,14],["07-03-2017 17:57:11","442585","0.378",-15.832833,-48.05481,19],["07-03-2017 17:57:32","443034","0.902",-15.787903,-47.895599,35],["07-03-2017 17:57:47","444171","933.1",-15.804333,-48.07237,18],["07-03-2017 17:31:40","444006","933.1",-15.843577,-48.124094,25],["07-03-2017 17:46:01","444162","0.043",-15.84009,-48.12461,16],["07-03-2017 17:37:35","444260","933.2",-15.840137,-48.12673,39],["07-03-2017 14:35:57","444197","933.1",-15.839257,-48.12737,20]
Just to see what's coming to geoevent I set TCP Socket as my output, with TCPServerApp and I could see only the columnseach five seconds with no data, like this:
08/03/17 10:46 : MARECHAL_JSON,"[DATAHORA, ORDEM, LINHA, LATITUDE, LONGITUDE, VELOCIDADE]", 08/03/17 10:46 : MARECHAL_JSON,"[DATAHORA, ORDEM, LINHA, LATITUDE, LONGITUDE, VELOCIDADE]", 08/03/17 10:46 : MARECHAL_JSON,"[DATAHORA, ORDEM, LINHA, LATITUDE, LONGITUDE, VELOCIDADE]", 08/03/17 10:46 : MARECHAL_JSON,"[DATAHORA, ORDEM, LINHA, LATITUDE, LONGITUDE, VELOCIDADE]", 08/03/17 10:46 : MARECHAL_JSON,"[DATAHORA, ORDEM, LINHA, LATITUDE, LONGITUDE, VELOCIDADE]",
Am I doing some thing wrong?
How should I use Header Parameter Name and Json Object Name?
Does someone have some tips?
Thank you
Wellington Alves