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
| function_name | function_type | description | comment | examples | |—————|—————|————-|———|———-|
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 | [] |