Extract Endpoint - Beta Version

Many organizations have their data extracted into DataSelf cloud servers for optimized reporting and data analysis. The Extract Endpoint allows them to easily and securely download their data for further reporting or manipulation using other tools such as Excel.

Core Endpoint

• https://api.beta.dataself.com/<metadata server>/entities/<entity id>/extract?token=<user token>&source=<function>

...

• <metadata server>: dw6 (dw6=beta metadata server).

• <entity id>: ETL+ Entity ID, e.g.: abccorp

• token=<user token>: ETL+ user token - you receive it in your DataSelf Product Registration email. To retrieve it, search your inbox for “DataSelf Product Registration“ or log into your ETL+ → Settings → Client Info → Send → check your email for the product registration.

• source=<function>:

  • dw: See SQL Extractor

  • tableau-view: See Tableau View Extractor

SQL Extractor

Allows the extraction of data from the client’s cloud data warehouse. It can extract the list of available tables and views, tables/views data, define table/views columns to download, and apply extract filters.

...

• With the beta API, some extracted characters (such as commas and line breaks) can mess up the CSV file. Here’s a SQL transformation to clean up some of them: REPLACE(REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(Column1)), CHAR(13), ''), CHAR(10), ''), ',', ''), '"', '""')

• Endpoint syntax is case-sensitive, except for the parameters.

• The order of the parameters after ? is not relevant.

Tableau View Extractor

Allows the extraction of data from the client’s Tableau site. It can extract the list of available workbooks and views from an API-dedicated Tableau Project, and then extract data from views from that project.

...