API Returns too much data - Need to extract

[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

[dora_paz (Dora)]

Maybe it is not the correct way but …

[Rogerio_Rios (Professional Support)]

Ready , solved , blocks ready ( one more example Json Decode API Dictionary )+1🤷

Looks like you’re making a great app and you’re hoping it’s all sorted out by other people. 🤷I think here in the community there are hundreds of solutions for Json and API.