Search Shortcut cmd + k | ctrl + k
erpl_web
Downloads 806this week
GitHub stars 27
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
bc_describe table NULL NULL  
bc_read table NULL NULL  
bc_show_companies table NULL NULL  
bc_show_entities table NULL NULL  
crm_describe table NULL NULL  
crm_read table NULL NULL  
crm_show_entities table NULL NULL  
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  
delta_share_scan table NULL NULL  
delta_share_show_schemas table NULL NULL  
delta_share_show_shares table NULL NULL  
delta_share_show_tables 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  
graph_calendar_events table NULL NULL  
graph_channel_messages table NULL NULL  
graph_contacts table NULL NULL  
graph_describe_list table NULL NULL  
graph_devices table NULL NULL  
graph_excel_range table NULL NULL  
graph_excel_table_data table NULL NULL  
graph_excel_tables table NULL NULL  
graph_excel_worksheets table NULL NULL  
graph_groups table NULL NULL  
graph_list_files table NULL NULL  
graph_list_items table NULL NULL  
graph_messages table NULL NULL  
graph_my_teams table NULL NULL  
graph_planner_buckets table NULL NULL  
graph_planner_plans table NULL NULL  
graph_planner_tasks table NULL NULL  
graph_show_lists table NULL NULL  
graph_show_sites table NULL NULL  
graph_signin_logs table NULL NULL  
graph_team_channels table NULL NULL  
graph_team_members table NULL NULL  
graph_users table 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_read_analytical table NULL NULL  
sac_read_planning_data table NULL NULL  
sac_read_story_data table NULL NULL  
sac_show_models table NULL NULL  
sac_show_stories table NULL NULL  

Overloaded Functions

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 []