Function for REST API to import Data to Zoho Report

Function for REST API to import Data to Zoho Report

I have tried with below Zoho Creator Function which fetch JSON data from external websites in JSON formtat and then import that JSON data to ZOho Report table but it not working .could  you please help me how to fix it.

Thanks
Arfater


see below code :

  1. void API.ZohoReportAPI(string zip)
    {
    url = (" http://api.tvmedia.ca/tv/v4/lineups/browse/US/TX/" + zip +"?api_key=*******&detail=full").toString();
    response = getUrl(url);
    lines = response.toJSONList();
    //info lines;

    myMap = map(); 
    myMap.put("ZOHO_FILE",lines);
    myMap.put("ZOHO_IMPORT_FILETYPE", "JSON"); 
    myMap.put("ZOHO_IMPORT_TYPE", "APPEND"); 
    myMap.put("ZOHO_AUTO_IDENTIFY", "true"); 
    myMap.put("ZOHO_ON_IMPORT_ERROR", "ABORT"); 



    }