Search Shortcut cmd + k | ctrl + k
erpl_web
Downloads n/athis week
GitHub stars 17
Extension repository on GitHub
Extension descriptor (YAML)

ERPL is a DuckDB extension to connect to API based ecosystems via standard interfaces like OData, GraphQL and REST. This works e.g. for SAP ERP, SAP Ariba, SAP C4C, Microsoft Dynamics and many more.

Maintainer(s): jrosskopf

Installing and Loading 

INSTALL erpl_web FROM community;
LOAD erpl_web;

Added Functions

function_name function_type description comment examples
datasphere_describe_asset table NULL NULL  
datasphere_describe_space table NULL NULL  
datasphere_read_analytical table NULL NULL  
datasphere_read_relational table NULL NULL  
datasphere_show_assets table NULL NULL  
datasphere_show_spaces table NULL NULL  
erpl_trace_directory pragma NULL NULL  
erpl_trace_enable pragma NULL NULL  
erpl_trace_level pragma NULL NULL  
erpl_trace_status pragma NULL NULL  
http_delete table NULL NULL  
http_get table NULL NULL  
http_head table NULL NULL  
http_patch table NULL NULL  
http_post table NULL NULL  
http_put table NULL NULL  
odata_attach table NULL NULL  
odata_describe table NULL NULL  
odata_read table NULL NULL  
odata_sap_show table NULL NULL  
odp_odata_list_subscriptions table NULL NULL  
odp_odata_read table NULL NULL  
odp_odata_remove_subscription pragma NULL NULL  
odp_odata_show table NULL NULL  
sac_get_model_info table NULL NULL  
sac_get_story_info table NULL NULL  
sac_list_models table NULL NULL  
sac_list_stories table NULL NULL  
sac_read_analytical table NULL NULL  
sac_read_planning_data table NULL NULL  
sac_read_story_data table NULL NULL  

Added Types

type_name type_size logical_type type_category internal
HTTP_HEADER 16 MAP COMPOSITE true

Added Settings

name description input_type scope aliases
erpl_telemetry_enabled Enable ERPL telemetry, see https://erpl.io/telemetry for details. BOOLEAN GLOBAL []
erpl_telemetry_key Telemetry key, see https://erpl.io/telemetry for details. VARCHAR GLOBAL []
erpl_trace_enabled Enable ERPL Web extension tracing functionality BOOLEAN GLOBAL []
erpl_trace_file_path Set ERPL Web extension trace file path VARCHAR GLOBAL []
erpl_trace_level Set ERPL Web extension trace level (TRACE, DEBUG, INFO, WARN, ERROR) VARCHAR GLOBAL []
erpl_trace_max_file_size Set ERPL Web extension trace file max size in bytes BIGINT GLOBAL []
erpl_trace_output Set ERPL Web extension trace output (console, file, both) VARCHAR GLOBAL []
erpl_trace_rotation Enable ERPL Web extension trace file rotation BOOLEAN GLOBAL []