Corona not converting json to table

Getting Started Newbie Questions
#1

I am trying to convert the following json object to a table but Corona fails to do so and giving 0 for the print. I tried replacing “__type”:“Object”, with “” to prevent confusion but no luck. 

   tempTable1 = '{"result":[{"\_\_type":"Object","address":"95-97 Whitehorse Rd Blackburn VIC 3130","className":"allJobs","content":"Dr test","coord":{"\_\_type":"GeoPoint","latitude":-37.817272,"longitude":145.149913},"createdAt":"2015-05-21T05:15:45.012Z","done":false,"email":"na","job":"psychologist","objectId":"PfKJkmIQKw","order":1,"phone":"0422031410","postcode":"3130","suburb":"Blackburn VIC","updatedAt":"2015-05-27T08:15:46.607Z","web":"na"},{"\_\_type":"Object","address":"Suite 9 10-12 Prospect St Box Hill ","className":"allJobs","content":"Dr 2)","coord":{"\_\_type":"GeoPoint","latitude":-37.817957,"longitude":145.118997},"createdAt":"2015-05-21T05:17:56.382Z","done":false,"email":"soboodi@yahoo.com","job":"lawyer","objectId":"xnLABEm5S4","order":1,"phone":"03 9890 0797","postcode":"3128","suburb":"Box Hill VIC","updatedAt":"2015-05-27T08:15:21.112Z","web":"na"}]}'  local tables  = json.decode(tempTable1)  print(#tables) 
#2

I was calling the results wrong way. Since it was creating a few tables inside other tables. The following gets them right.

print (tables.result[1].address)

#3

Hi! I have a similar question to this topic. Maybe you can help me out.

In this example how would you access: -37.817272 value for latitude??

I am trying to get a similar value in my cases, but I dont know how to. Your help would be greatly appreciated. thanks!

#4

You may use the following. coord is the column name on your parse data. I am using parse module but it should be similar if you access directly.

         latSearch[i]=event.response.result[i].coord.latitude

         longSearch[i]=event.response.result[i].coord.longitude

#5

awesome! thank you very much!

#6

I was calling the results wrong way. Since it was creating a few tables inside other tables. The following gets them right.

print (tables.result[1].address)

#7

Hi! I have a similar question to this topic. Maybe you can help me out.

In this example how would you access: -37.817272 value for latitude??

I am trying to get a similar value in my cases, but I dont know how to. Your help would be greatly appreciated. thanks!

#8

You may use the following. coord is the column name on your parse data. I am using parse module but it should be similar if you access directly.

         latSearch[i]=event.response.result[i].coord.latitude

         longSearch[i]=event.response.result[i].coord.longitude

#9

awesome! thank you very much!