ImportJSON

Import JSON to spreadsheet google

The function is: =ImportJSON(url, query, parseOptions, user, pw)

Example:

=ImportJSON("https://api.example.com/example?param1=param&param2=param","/data","","user","apiKeyxxxxxxxxx")

Params

url: It's the api url

query: It's the Data you need, you need separate it by / symbol

parseOptions: you can do it empty, It's optional

User: always it's “user”

Pw: It's the apiKey