Source page

David Megginson edited this page Jan 26, 2017 · 4 revisions

HXL Proxy data source page The Source page is the normal starting page when working with the HXL Proxy's interactive interface. The HXL Proxy can read from any publicly-accessible online data source. It understands data in two formats:

  1. Comma-separated values (expects "," as the separator, and UTF-8 as the character encoding).
  2. Excel .xls or .xlsx format (allows specifying a tab by number).

The HXL Proxy home page allows you to enter a URL directly (e.g. for CSV data from an API), or to choose from HDX, Google Drive, or Dropbox using an interactive browser.

If you select a dataset that does not yet contain HXL hashtags, the HXL Proxy will redirect you to the Tagger page; otherwise, it will take you directly to the Recipe page.

See Special URL handling for information about special support for URLs from HDX, Google Drive, and Dropbox.

Live demo

Options

  • Tab # — the tab number (1 or higher). Applies only if the source is an Excel workbook.
  • Verify SSL certs — if unchecked, skip verification of SSL certificates. This is useful for working with data on servers with self-signed certificates. Checked by default.

For coders

Advanced software developers may choose to use the API instead of defining transformations via forms.