JSON Desearlize From Json to Excel

Help Studio
, ,
1

Hey guys,

I have json data like below ; how do I get number and address parameters to excel with for each ?

My json data ;

{
“html_attributions” : ,
“result” : {

  "adr_address" : "\u003cspan class=\"street-address\"\u003eZekeriyaköy, Balaban Çk. No 3\u003c/span\u003e, \u003cspan class=\"postal-code\"\u003e34450\u003c/span\u003e \u003cspan class=\"locality\"\u003eSarıyer\u003c/span\u003e/\u003cspan class=\"region\"\u003eİstanbul\u003c/span\u003e, \u003cspan class=\"country-name\"\u003eTurkey\u003c/span\u003e",
  "business_status" : "OPERATIONAL",
  "formatted_address" : "Zekeriyaköy, Balaban Çk. No 3, 34450 Sarıyer/İstanbul, Turkey",
  "formatted_phone_number" : "(0212) 202 51 11",
  "geometry" : {
     "location" : {
        "lat" : 41.19679920000001,
        "lng" : 29.0285373
     },
     "viewport" : {
        "northeast" : {
           "lat" : 41.1981396802915,
           "lng" : 29.0298702302915
        },
        "southwest" : {
           "lat" : 41.1954417197085,
           "lng" : 29.0271722697085
        }
     }
  },
  "icon" : "https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/shopping-71.png",
  "icon_background_color" : "#4B96F3",
  "icon_mask_base_uri" : "https://maps.gstatic.com/mapfiles/place_api/icons/v2/shopping_pinlet",
  "international_phone_number" : "+90 212 202 51 11",
  "name" : "Zekeriyaköy Pet Shop",
  "opening_hours" : {
     "open_now" : true,

I need to extract to excel address, number and name parameters.

Best regards,

2

may we ask you to share the json as text file and sample excel with the expected output result with us? Thanks

3

Yea sure ,

response (4).json (12.7 KB)
And Excel file ;

Place_ID’s.xlsx (15.6 KB)

I create http request with for each Place_ID’s and ı can get results from API. But ı need to extract to number address and name to same excel match with place id’s.

4

Hello Burak,
This video can help you:

Thanks,
Cristian

5

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