How to extract particular elements from the JSON format output

How To Seprate Single Item From JSON Text

I want to know how to separate single values from JSON Text,
I already searched community and use Both LookUpPairs and Get item for key Blocks But both Can’t Help Me.

Here is my blocks and error result

WhatsApp Image 2021-01-30 at 8.22.20 PM 2 WhatsApp Image 2021-01-30 at 8.16.53 PM

JSON result obtained from web

{“data”:[{“latitude”:11.766172,“longitude”:79.758493,“type”:“venue”,“distance”:0.009,“name”:“Higher Secondary Blocks”,“number”:null,“postal_code”:“607001”,“street”:null,“confidence”:0.9,“region”:“Tamil Nadu”,“region_code”:“TN”,“county”:“Cuddalore”,“locality”:“Cuddalore”,“administrative_area”:null,“neighbourhood”:null,“country”:“India”,“country_code”:“IND”,“continent”:“Asia”,“label”:“Higher Secondary Blocks, Cuddalore, India”},{“latitude”:11.76571,“longitude”:79.758649,“type”:“venue”,“distance”:0.064,“name”:“Amphitheater”,“number”:null,“postal_code”:“607001”,“street”:null,“confidence”:0.8,“region”:“Tamil Nadu”,“region_code”:“TN”,“county”:“Cuddalore”,“locality”:“Cuddalore”,“administrative_area”:null,“neighbourhood”:null,“country”:“India”,“country_code”:“IND”,“continent”:“Asia”,“label”:“Amphitheater, Cuddalore, India”},{“latitude”:11.76561,“longitude”:79.758749,“type”:“venue”,“distance”:0.078,“name”:“A.R.L.M. Matriculation School”,“number”:null,“postal_code”:“607001”,“street”:null,“confidence”:0.8,“region”:“Tamil Nadu”,“region_code”:“TN”,“county”:“Cuddalore”,“locality”:“Cuddalore”,“administrative_area”:null,“neighbourhood”:null,“country”:“India”,“country_code”:“IND”,“continent”:“Asia”,“label”:“A.R.L.M. Matriculation School, Cuddalore, India”},{“latitude”:11.765341,“longitude”:79.75872,“type”:“venue”,“distance”:0.105,“name”:“Water tank and dispensers”,“number”:null,“postal_code”:null,“street”:null,“confidence”:0.7,“region”:“Tamil Nadu”,“region_code”:“TN”,“county”:“Cuddalore”,“locality”:“Cuddalore”,“administrative_area”:null,“neighbourhood”:null,“country”:“India”,“country_code”:“IND”,“continent”:“Asia”,“label”:“Water tank and dispensers, Cuddalore, India”},{“latitude”:11.765314,“longitude”:79.758804,“type”:“venue”,“distance”:0.111,“name”:“Water Well”,“number”:null,“postal_code”:null,“street”:null,“confidence”:0.7,“region”:“Tamil Nadu”,“region_code”:“TN”,“county”:“Cuddalore”,“locality”:“Cuddalore”,“administrative_area”:null,“neighbourhood”:null,“country”:“India”,“country_code”:“IND”,“continent”:“Asia”,“label”:“Water Well, Cuddalore, India”},{“latitude”:11.765117,“longitude”:79.758326,“type”:“venue”,“distance”:0.127,“name”:“Main Block”,“number”:null,“postal_code”:“607001”,“street”:null,“confidence”:0.7,“region”:“Tamil Nadu”,“region_code”:“TN”,“county”:“Cuddalore”,“locality”:“Cuddalore”,“administrative_area”:null,“neighbourhood”:null,“country”:“India”,“country_code”:“IND”,“continent”:“Asia”,“label”:“Main Block, Cuddalore, India”},{“latitude”:11.764989,“longitude”:79.758703,“type”:“venue”,“distance”:0.143,“name”:“Indoor Auditorium”,“number”:null,“postal_code”:“607001”,“street”:null,“confidence”:0.7,“region”:“Tamil Nadu”,“region_code”:“TN”,“county”:“Cuddalore”,“locality”:“Cuddalore”,“administrative_area”:null,“neighbourhood”:null,“country”:“India”,“country_code”:“IND”,“continent”:“Asia”,“label”:“Indoor Auditorium, Cuddalore, India”},{“latitude”:11.763341,“longitude”:79.757653,“type”:“venue”,“distance”:0.336,“name”:“Vishnu Temple”,“number”:null,“postal_code”:null,“street”:null,“confidence”:0.6,“region”:“Tamil Nadu”,“region_code”:“TN”,“county”:“Cuddalore”,“locality”:“Cuddalore”,“administrative_area”:null,“neighbourhood”:null,“country”:“India”,“country_code”:“IND”,“continent”:“Asia”,“label”:“Vishnu Temple, Cuddalore, India”},{“latitude”:11.763215,“longitude”:79.755196,“type”:“address”,“distance”:0.491,“name”:“61 South Street”,“number”:“61”,“postal_code”:“607001”,“street”:“South Street”,“confidence”:0.6,“region”:“Tamil Nadu”,“region_code”:“TN”,“county”:“Cuddalore”,“locality”:“Cuddalore”,“administrative_area”:null,“neighbourhood”:null,“country”:“India”,“country_code”:“IND”,“continent”:“Asia”,“label”:“61 South Street, Cuddalore, India”},{“latitude”:11.768607,“longitude”:79.762726,“type”:“venue”,“distance”:0.534,“name”:“Check Post-revenue Dept”,“number”:“NH 45A”,“postal_code”:“607001”,“street”:null,“confidence”:0.6,“region”:“Tamil Nadu”,“region_code”:“TN”,“county”:“Cuddalore”,“locality”:“Cuddalore”,“administrative_area”:null,“neighbourhood”:null,“country”:“India”,“country_code”:“IND”,“continent”:“Asia”,“label”:“Check Post-revenue Dept, Cuddalore, India”}]}

In your above json there is no key with the name address , you have key “type” and value “address”. Also the error that you posted do not come from the above blocks

See below how I get values for key “type”

2 Likes

Complementing the answer above, you need to read and understand about Json

1 Like

Pls tell me hot to extract address alone in a label

Try this

2 Likes

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.