Skip to main content

READ_CSV

Deprecated version

This document refers to a deprecated version of the RQL programming language.

Please go here for documentation related to the latest supported version.

Reads CSV data from a location.

Syntax
READ_CSV[<type>](location,
encoding := "utf-8",
skip := 0,
delimiter := ",",
nulls := [""],
nans := [],
time_format := "HH:mm[:ss[.SSS]]",
date_format := "yyyy-MM-dd",
timestamp_format := "yyyy-M-d'T'HH:mm[:ss[.SSS]]",
escape := "\\",
quote := "\"",
cache := <default interval>,
retries := <default int>,
retry_interval := <default interval>,
http_method := "get",
http_body := null,
http_body_string := null,
http_headers := [],
http_args := [],
http_auth_cred_name := null,
http_token := null,
http_token_url := null,
http_client_id := null,
http_client_secret := null,
http_renew_token_use_basic_auth := false,
http_username := null,
http_password := null)

  • The <type> is the type of each row of data.
  • The optional argument skip specifies the number of lines to skip in the data.
  • The optional argument delimiter specifies the default delimiter to use.
  • The optional argument time_format specifies the format to use while parsing time fields.
  • The optional argument date_format specifies the format to use while parsing date fields.
  • The optional argument timestamp_format specifies the format to use while parsing timestamp fields.
  • The optional argument escape specifies a escape character while parsing the CSV file.
  • The optional argument quote specifies the quote character in the data.
  • The optional arguments starting with http, like http_method, define specific http request options; refer to :ref:HTTP Optional Arguments <http_optional_args>.