How can i extract a json object to googlesheets?

Question

I would like to extract an object result of a json url to google sheets. Pls find the code that i use to import json data to google sheet: https://github.com/bradjasper/ImportJSON

However, it extracts the data as a table. Is there a way to extract just one object result to a cell?

Here is the json url result. I need to get codeId value to a cell with importjson formula.

{"status":0,"statusAciklama":"success","codeId":"47348","groupId":"48962"}

Answer 1

try:

=REGEXEXTRACT(IMPORTJSON(...); "codeId.:.(\d+)")

where ... is your formula