How to import bulk data using custom function from JSON Array

How to import bulk data using custom function from JSON Array

Hi,

Hope you are doing good.

I am having an array of JSON data fetched from an external API through GetUrl method. I just want to import this JSON Array data into ZOHO Report new table by writing code on Custom Functions. I tried many ways and also gone through many articles but still no luck.

I checked below URL and pasted the html form with JSON data FORM uploading but it didn't work showing xml error :


<response action="IMPORT">
<script id="_rf_8ahd_nua75_vl0asd_"/>
<error>
<code> 8525 </code>
<message> There is no web page matching your request. </message>
</error>
</response>

Please check and let me know for the possible solutions.

Thanks
Akbar