ImportJSON | Import JSON into Google Sheets | JSON Processing library

I am trying to import the extended 14-day forecast into Google Sheets. Some of the research I have been looking for are outdated and I would love some help for my knowledge gaps.

I tried =importXML and =importHTML and get an Error that says Cannot Fetch URL.
In cell A2 is the URL: "https://www.timeanddate.com/weather/mexico/mexico-city/ext"
In cell B2 is this formula with xpath: =IMPORTXML(A2,"//*[@class='zebra tb-wt fw va-m tb-hover']")
I also tried in B2: =IMPORTHTML(A2, "table", 2)

I also read weather sites may use scripting so I'd have to try importJSON.
I added to Google Sheets App Script from: https://gist.github.com/allenyllee/c764c86ed722417948fc256b7a5077c4#file-import_json_appsscript-js
I then tried: =IMPORTJSON("https://www.timeanddate.com/weather/usa/atlanta/ext?$format=json",table,2)

All gave me errors like Error Fetching URL.

Any instructions/clarifications would be appreciated. Thank you!

Can also try with Google Weather or Weather.com or Accuweather if easier.

I want to import json data from within the class which is the target of the deserialization. Is this possible with System.Text.Json without additional mapping? Ideally I would use "this" instead of the generic type parameter. I know that is impossible, but is there a similar option? Here is my test code which works, because it creates the data object only to map it to the property. Ideally, I would not need to instantiate "Test" twice.

I am trying to import the following JSON into Google sheets and have the results split into two columns. The data is coin price data from Coingecko.

https://api.coingecko.com/api/v3/coins/invictus/market_chart?vs_currency=usd&days=30&interval=daily

The JSON returns UNIX timestamp data and price in the following format:

"prices":[timestamp , price],[timestamp , price]....

I can import the JSON using the code from https://blog.fastfedora.com/projects/import-json like this: =ImportJSON("https://api.coingecko.com/api/v3/coins/invictus/market_chart?vs_currency=usd&days=30&interval=daily", "/prices", "noInherit,noTruncate", doNotDelete!$A$1)

However it returns the data as one long string in cell A:2. For example:

1638144000000,746.6771503601128,1638230400000,790.8738166468181,1638316800000,813.0212755328346,1638403200000,747.1829923418416,1638489600000,603.2418788487082,1638576000000,527.9869145332356,1638662400000,457.35694186735213,1638748800000,459.1020634102568,1638835200000,379.45955893531516,1638921600000,367.4285592864082,1639008000000,332.6569958807504,1639094400000,360.31721655542077,1639180800000,353.72371970970227,1639267200000,311.1900754529333,1639353600000,304.50307298537416,1639440000000,245.09538112807542,1639526400000,236.7967986455728,1639612800000,256.7026205778511,1639699200000,258.6393225791494,1639785600000,267.78476662611047,1639872000000,286.931173745379,1639958400000,307.5668050495342,1640044800000,326.8786486489706,1640131200000,378.46907838034076,1640217600000,398.40479671686626,1640304000000,366.45154529552616,1640390400000,316.05924359618723,1640476800000,329.5910997574541,1640563200000,305.52573964071496,1640649600000,280.05521099343133,1640688200000,265.71741103257415

I would like some help parsing this data into 2 columns, column A being UNIX timestamp, and column B being Prices

I'm totally new to this stuff. Never even heard of json/api/etc three days ago. Basically, I'm using the google sheets formula "=ImportJSON("https://universalis.app/api/Primal/7024")" to import data. However, there's almost 4000 cells worth of data in there and I only want about 10-20 cells worth of that. How can I narrow down what data it sends? These are the only cells I want info from D2-D12. I assume I can adjust the formula after if I want, say, D2-D22 instead. Thank you.

I'm trying to use IMPORTJSON to import some data from:

https://templeosrs.com/api/player_stats.php?player=Mikael&date=1639587712

to my google spreadsheet. For some columns, like "Ehp", I can get the value just fine with

=VALUE(QUERY(TRANSPOSE(IMPORTJSON(C5)), "select Col2 where Col1 = 'Ehp'"))

where C5 is just a cell with the link above in it. But this doesn't seem to work for any column that has an underscore in it, like "Ehp_rank".

I should say I understand nothing about how any of this works, I'm doing everything by looking at examples I found, then just trial and error. Can someone help me import columns with an underscore?

Also, I'd like to import the "Username", but it's inside that info block and I can't seem to get it right. I've tried "info.Username", changing Col2/1 to Col3/2, but no sucess.

I have been trying to import a JSON file from SEC EDGAR but have been unsuccessful. It shows the following error:

Exception: request failed for https://data.sec.gov returned code 403. Truncated server response: https://github.com/bradjasper/ImportJSON

It is working normally for other sites, the only one so far that I had problem is the SEC EDGAR site: https://data.sec.gov/api/xbrl/companyconcept/CIK0000320193/us-gaap/AccountsPayableCurrent.json

I have been trying for the past week to build a master leaderboard for my middle school chess clubs in Google Sheets. We play on the website Lichess.org which has a great API. I managed to get the tournament id using ImportXML, but the results I am trying to access don't seem accessible with any of the ImportJson scripts out there added to sheets.

This is the page with the student results https://lichess.org/tournament/2bHOVix0 I want to get the "name" and "score" for each of the top 3 results First, I assume I cannot just use ImportXML to get that data from the above link even though it shows up in "view page source"

Assuming that would not work I used the Lichess API to download the json file with the correct data via this link http://lichess.org/api/tournament/NguuB8pO/results

Is there a reason this "Importjson" will not work? Does it matter that the API describes the json as a ndjson? =ImportJSON("http://lichess.org/api/tournament/NguuB8pO/results","/name") I have tried is at least 20 different ways with different importjson scripts added to my sheets.

Thanks in advance for any help you can offer. -Mike

I'm not sure if I phrased the question right. What I need is for a certain custom function in this case "ImportJSON()" to be able to import the present month into it's arguments in order for it to display the value correspondent to the present month without me having to manually update/write the month name every beginning of the month. Did that make sense?

Here is a dummy file as example: https://docs.google.com/spreadsheets/d/1ExXtmQ8nyuV1o_UtabVJ-TifIbORItFMWjtN6ZlruWc/edit?usp=sharing

So as you can see when I reference a cell where I wrote down "August" the custom function accepts it. But if I reference a cell which uses "now()" it displays an error:

I have got import JSON script: https://gist.github.com/paulgambill/cacd19da95a1421d3164

and paste it in google apps script inside google sheets and I want to import this Json: https://fapi.binance.com/fapi/v1/ticker/24hr

But I do not know how to paste in importJSON formula in google sheets, when I put this link into the formula, it does not fetch any data? what is wrong? what do I have to do?