request to add type for 'image' about importjsonapi HOT 1 OPEN

I looked into this and I don't think this is possible. The function can only return plain data types such as strings, numbers and dates. There is no functionality to return an image type or to set formulas (as far as I'm aware). See https://developers.google.com/apps-script/guides/sheets/functions#return_values

The best option is use another custom function such as described in the link below and run it from a custom menu so that it is able to directly manipulate cell data.
https://webapps.stackexchange.com/questions/74508/how-to-display-image-from-url-in-google-sheets-and-apply-it-to-multiple-rows

from importjsonapi.