[GAS] Get Json File Data into Google Sheet :

SOURCE LEARNING :
https://www.youtube.com/watch?v=EXKhVQU37WM

Learn how to import JSON data from API to Google Sheets using user defined IMPORTJSON function. Get the function script here https://www.chicagocomputerclasses.co...

DEMO JSON FILE :

{"menu": {
  "id": "file",
  "value": "File",
  "popup": {
    "menuitem": [
      {"value": "New", "onclick": "CreateNewDoc()"},
      {"value": "Open", "onclick": "OpenDoc()"},
      {"value": "Close", "onclick": "CloseDoc()"}
    ]
  }
}}

(1) =importjson("URL","menu/popup/menuitem/0")

OUTPUT :

value
New
onclick
CreateNewDoc()

(2) =importjson("URL","menu/popup/menuitem/2")
OUTPUT :

value
Close
onclick
CloseDoc()

(3) =importjson("URL","menu")
OUTPUT :

id
file
value
File
popup

it's work .

The (1) & (2) are array