API Returns too much data - Need to extract

[Avraham_Yerachmielbenzvi]

I have a GPS API that returns this

{“Response”:{“MetaInfo”:{“Timestamp”:“2021-08-16T11:42:04.830+0000”},“View”:[{"_type":“SearchResultsViewType”,“ViewId”:0,“Result”:[{“Relevance”:0.91,“MatchLevel”:“houseNumber”,“MatchQuality”:{“Country”:1.0,“City”:1.0,“Street”:[0.85],“HouseNumber”:1.0},“MatchType”:“pointAddress”,“Location”:{“LocationId”:“NT_qxGXgb3G3cd.7rBUiG7R6C_3A”,“LocationType”:“point”,“DisplayPosition”:{“Latitude”:-34.03144,“Longitude”:24.91555},“NavigationPosition”:[{“Latitude”:-34.03162,“Longitude”:24.91537}],“MapView”:{“TopLeft”:{“Latitude”:-34.0303158,“Longitude”:24.9141935},“BottomRight”:{“Latitude”:-34.0325642,“Longitude”:24.9169065}},“Address”:{“Label”:“7 Blombos St, Jeffreys Bay, 6330, South Africa”,“Country”:“ZAF”,“State”:“Eastern Cape”,“County”:“Kouga”,“City”:“Jeffreys Bay”,“District”:“Noorskloofpunt”,“Street”:“Blombos St”,“HouseNumber”:“7”,“PostalCode”:“6330”,“AdditionalData”:[{“value”:“South Africa”,“key”:“CountryName”},{“value”:“Eastern Cape”,“key”:“StateName”},{“value”:“Kouga”,“key”:“CountyName”}]}}}]}]}}

but I need to only extract this…

"NavigationPosition":[{“Latitude”:-34.03162,“Longitude”:24.91537}]

Can anyone tell me how to isolate this data from the returned json

Thanks

Tony

[iamwsumit (Sumit Kumar)]

You should search​ on community before posting.

Here is a whole guide on JSON data.

Guide: How to get JSON data from an Api using dictionaries (and show it on a dynamic cardview)

Recently Kodular has removed the Json component but has added the Dictionaries. The Dictionaries can be used to obtain data from a Json in a simple way. Using the dictionaries you don’t need to use any Json extension. First of all, dictionaries are not a component. That’s why you won’t find it in the Designer. You will find it in the block section: [imagen] In this example we are going to obtain the data from the Api newsapi.org The idea is to get something like this: [Tutorial Json Ap…

[Avraham_Yerachmielbenzvi]

Yes, but that’s not the problem

The problem is that that data I NEED seems to be be NESTED inside other data

The question is how to extract just the Long and Lat

As you can see in the block, the first Notify shows me ALL THE JSON

Its the second that is not returning just the data I need

Thanks

[sugarlesscreator]

Your data is in

Response
    View
        Result
            Location

[Rogerio_Rios (Professional Support)]

How to get list from Sql in Spinner

1- take a list and assign it the return of the Json Decode Text block. Couple the Response Content to the Json Decode Text block You need to read this:

[Avraham_Yerachmielbenzvi]

[Avraham_Yerachmielbenzvi]

Thanks

I get the

@sugarlesscreator

Response
    View
        Result
            Location

does that mean I need to drill down to the data I want and if so, then I dont understand your method.

I, so close. Please help

thanks

[Avraham_Yerachmielbenzvi]

@How to get list from Sql in Spinner

Couple the Response Content to the Json Decode Text block You need to read this:

When you say COUPLE, havent I already done that?

[Superjay (Jay Lee)]

[Free] Json To Dictionary Extension

Json To Dictionary Extension Release date : 2020-10-24T23:00:00Z (UTC) Last Update Date : 2020-10-24T23:00:00Z (UTC) Current Version: 1 Min. Api version : 1 ( Works on every android version ) Ending Date : ( When kodular add it as a built in block ) Description Hello, every one ! Today i release my very first extension ! Json To Dictionary , i actually made it after seeing this topic : Request for JSON decode to dictionary, to parse json text to dictionaries till kodular …

Use this extension to turn JSON into a dictionary. After converting, you can just play with the dictionary.

[Rogerio_Rios (Professional Support)]

Do not need Any Extension.
Use Dictionary or Lookup pairs Key Block

[Avraham_Yerachmielbenzvi]

This is the ERROR I get

Argument #1 (not found) to ‘com.google.appinventor.components.runtime.util.YailDictionary.walkKeyPath(com.google.appinventor.components.runtime.util.YailObject,java.util.List)’ has wrong type (java.lang.String) (java.lang.String cannot be cast to com.google.appinventor.components.runtime.util.YailObject)

[dora_paz (Dora)]

See the structure of your json in order to understand how to get values

[Avraham_Yerachmielbenzvi]

yes, I see that but when I go to “Location” I get the error below

Argument #1 (not found) to ‘com.google.appinventor.components.runtime.util.YailDictionary.walkKeyPath(com.google.appinventor.components.runtime.util.YailObject,java.util.List)’ has wrong type (java.lang.String) (java.lang.String cannot be cast to com.google.appinventor.components.runtime.util.YailObject)

BTW, I finally got Companion to work.

[Avraham_Yerachmielbenzvi]

Im getting this

Expected a number for an index, but got “Location” instead. WTH

I really enjoy being “helped” half way…

Please can someone tell me what I m doing wrong.

Thanks

[Still-learning (1-2-3-4...)]

can you show us, what have you tried so for this to get value?

[Avraham_Yerachmielbenzvi]

Tghis is as far as I get

Im getting the data in but I still cannot isolate what I need

Anyone, Please

[Still-learning (1-2-3-4...)]

convert web rsponse to json text, count the no of list. try to catch in which list item the location list is present. then use the select list item block to get the data…

[Avraham_Yerachmielbenzvi]

Thanks, which block do I use to do that?

[Still-learning (1-2-3-4...)]

i tried like this and got succeed…

[Avraham_Yerachmielbenzvi]

Yes, your method might work for a very simply JSON but mine is NESTED TO HELL

{“Response”:{“MetaInfo”:{“Timestamp”:“2021-08-16T11:42:04.830+0000”},“View”:[{"_type":“SearchResultsViewType”,“ViewId”:0,“Result”:[{“Relevance”:0.91,“MatchLevel”:“houseNumber”,“MatchQuality”:{“Country”:1.0,“City”:1.0,“Street”:[0.85],“HouseNumber”:1.0},“MatchType”:“pointAddress”,“Location”:{“LocationId”:“NT_qxGXgb3G3cd.7rBUiG7R6C_3A”,“LocationType”:“point”,“DisplayPosition”:{“Latitude”:-34.03144,“Longitude”:24.91555}, “NavigationPosition”:[{“Latitude”:-34.03162,“Longitude”:24.91537}] ,“MapView”:{“TopLeft”:{“Latitude”:-34.0303158,“Longitude”:24.9141935},“BottomRight”:{“Latitude”:-34.0325642,“Longitude”:24.9169065}},“Address”:{“Label”:“7 Blombos St, Jeffreys Bay, 6330, South Africa”,“Country”:“ZAF”,“State”:“Eastern Cape”,“County”:“Kouga”,“City”:“Jeffreys Bay”,“District”:“Noorskloofpunt”,“Street”:“Blombos St”,“HouseNumber”:“7”,“PostalCode”:“6330”,“AdditionalData”:[{“value”:“South Africa”,“key”:“CountryName”},{“value”:“Eastern Cape”,“key”:“StateName”},{“value”:“Kouga”,“key”:“CountyName”}]}}}]}]}}

BUT I must say I cannot belive that no one wants to help especially when for a real “programmer” Im sure my error is a clear as daylight