Method readData

lib/Datasource/ExternalCsv.php:72–161

* Read the Data * @param $option * @return array available options of the data source */

($option)

     * @return array available options of the data source
     */
    public function readData($option): array
    {
        $cache = $this->getCacheMetadata($option);
        if ($cache['notModified'] === true) {
            return [
                'header' => [],
                'dimensions' => [],
                'data' => [],
                'rawdata' => null,
                'error' => 0,
                'cache' => $cache,
            ];
        }

        $url = htmlspecialchars_decode($option['link'], ENT_NOQUOTES);
        $urlError = ExternalUrlValidator::validate($url);
        if ($urlError !== null) {
            return [
                'header' => [],
                'dimensions' => [],
                'data' => [],
                'error' => $urlError,
                'cache' => $cache,
            ];
        }
        $ch = curl_init();
        if ($ch !== false) {
            curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, true);
            curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
            curl_setopt($ch, CURLOPT_HEADER, false);
            curl_setopt($ch, CURLOPT_FOLLOWLOCATION, false);
            curl_setopt($ch, CURLOPT_URL, $url);
            curl_setopt($ch, CURLOPT_REFERER, $url);
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
            curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13');
            $curlResult = curl_exec($ch);
            $http_code = curl_getinfo($ch, CURLINFO_HTTP_CODE);
            curl_close($ch);
        } else {
            $curlResult = '';
            $http_code = 0;
        }

        $rows = str_getcsv($curlResult, "\n");

        // remove x number of rows from the beginning
        if (isset($option['offset']) and is_numeric($option['offset'])) {
            $rows = array_slice($rows, $option['offset']);
        }

        $selectedColumns = array();
        if (isset($option['columns']) && strlen($option['columns']) > 0) {
            $selectedColumns = str_getcsv($option['columns'], ',');
        }

        // get the delimiter by reading the first row
        $delimiter = $this->detectDelimiter($rows[0]);