Import JSON from sheet

[oli]

Thanks for this function! I’m being emailed JSON output, and would like a way to quickly ingest it into Google Sheets. Is there any chance you could consider an ImportJSONFromSheet-style option similar to bradjasper/ImportJSON (which I can’t seem to get to work)?

Thanks, and no worries if you think that’s outside the wheelhouse of IMPORTJSONAPI 😅

[qeet]

Hi,

This is not something I plan to implement I'm afraid. However you can use something like this:

https://extendsclass.com/json-storage.html

This allows you to paste your json data and then gives you a http address you can use to import the data via IMPORTJSONAPI

[qeet]

Actually I could easily implement this so the first parameter could be a json string: e.g

=IMPORTJSONAPI(A2, "$", "@")

Where cell A2 (or any other cell) contains the JSON data as a string. Would this work for you?

[oli]

@qeet That would be perfect! 😍 Thank you for considering this idea 🙇

[qeet]

OK. Will try and do this sometime this weekend.

[qeet]

@oli It is done.

[oli]

@qeet This works perfectly, even when the cell is on another sheet. Thank you so much! 🎉