erpl_web

ERPL ist eine DuckDB-Erweiterung zur Anbindung an API-basierte Ökosysteme über Standard-Schnittstellen wie OData, GraphQL und REST. Das funktioniert z. B. für SAP ERP, SAP Ariba, SAP C4C, Microsoft Dynamics und viele weitere.

Maintainer: jrosskopf

Installation und Laden

INSTALL erpl_web FROM community;
LOAD erpl_web;

Hinzugefügte Funktionen

bucket_id := 'bucket-id', due_date := '2024-06-30',
assigned_to := 'user-guid', description := 'Details here',
priority := 5, secret := 'ms_graph'), -- Bulk-create from a table using a lateral join

SELECT t.title, pt.task_url FROM todos t, graph_planner_create_task(‘plan-id’, t.title, due_date := t.due_date::VARCHAR, description := t.notes, secret := ‘ms_graph’) pt] | | graph_planner_plans | table | List all Microsoft Planner plans in a Microsoft 365 group. | NULL | [SELECT * FROM graph_planner_plans(‘group-id-here’, secret := ‘ms_graph’)] | | graph_planner_tasks | table | List all tasks in a Microsoft Planner plan. | NULL | [SELECT * FROM graph_planner_tasks(‘plan-id-here’, secret := ‘ms_graph’)] | | graph_sharepoint_create_item | table | Create a new item in a SharePoint list. Returns item_id (the newly created item’s integer ID). fields_json is a JSON object of SharePoint internal field name/value pairs (use graph_describe_list() to find field names). Both site and list accept a GUID, display name, or URL. | NULL | [SELECT * FROM graph_sharepoint_create_item(‘Finance’, ‘Budget’, ‘{“Title”:“Q1”,“Status”:“Active”}’, secret := ‘ms_graph’), SELECT * FROM graph_sharepoint_create_item(‘https://tenant.sharepoint.com/sites/Finance’, ‘Budget’, ‘{“Title”:“Q2”}’, secret := ‘ms_graph’)] | | graph_sharepoint_delete_item | scalar | Delete an item from a SharePoint list by its item ID. Returns true on success. item_id is the SharePoint integer ID (from the item_id column of graph_sharepoint_list_read()). secret is positional (last argument), not a named parameter. | NULL | [SELECT graph_sharepoint_delete_item(‘Finance’, ‘Budget’, ‘42’, ‘ms_graph’), SELECT graph_sharepoint_delete_item(‘Finance’, ‘Budget’, item_id::VARCHAR, ‘ms_graph’) FROM graph_sharepoint_list_read(‘Finance’, ‘Budget’, secret := ‘ms_graph’) WHERE Title = ‘OldEntry’] | | graph_sharepoint_list_read | table | Read all items from a SharePoint list. Returns dynamic columns matching the list schema (use graph_describe_list() to inspect them). Also returns item_id (SharePoint internal integer ID) on every row. Both arguments accept a GUID, display name, or site URL. | NULL | [SELECT * FROM graph_sharepoint_list_read(‘Finance’, ‘Budget’, secret := ‘ms_graph’), SELECT * FROM graph_sharepoint_list_read(‘https://tenant.sharepoint.com/sites/Finance’, ‘Budget’, secret := ‘ms_graph’)] | | graph_sharepoint_update_item | scalar | Update fields of an existing SharePoint list item. Returns true on success. item_id is the SharePoint integer ID (from the item_id column of graph_sharepoint_list_read()). fields_json is a JSON object of SharePoint internal field name/value pairs. secret is positional (last argument), not a named parameter. | NULL | [SELECT graph_sharepoint_update_item(‘Finance’, ‘Budget’, ‘42’, ‘{“Status”:“Approved”}’, ‘ms_graph’), UPDATE items SET ok = graph_sharepoint_update_item(‘Finance’, ‘Budget’, item_id::VARCHAR, json_object(‘Status’, new_status), ‘ms_graph’) FROM items] | | graph_show_drives | table | List document library drives in a SharePoint site. Returns id, name, drive_type, web_url. Pass a composite site_id (guid,guid,guid), a site display name, or a site URL as the first positional argument, or use the site named parameter instead. | NULL | [SELECT * FROM graph_show_drives(site := ‘Finance’, secret := ‘ms_graph’), SELECT * FROM graph_show_drives(‘https://tenant.sharepoint.com/sites/Finance’, secret := ‘ms_graph’)] | | graph_show_files | table | List files and folders in OneDrive or a SharePoint document library. Returns id, name, web_url, size, created_at, modified_at, mime_type, is_folder. Locate the drive with graph_show_drives() first. Pass drive as a drive ID (b!…), a web URL, or a display name combined with site. | NULL | [SELECT * FROM graph_show_files(drive := ‘b!abc…’, secret := ‘ms_graph’), SELECT * FROM graph_show_files(drive := ‘https://tenant.sharepoint.com/Shared%20Documents’, secret := ‘ms_graph’), SELECT * FROM graph_show_files(site := ‘Finance’, drive := ‘Documents’, secret := ‘ms_graph’)] | | graph_show_lists | table | List all lists in a SharePoint site. Returns id, name, display_name, list_template, web_url. Pass a composite site_id (guid,guid,guid), a site display name, or a site URL as the first positional argument, or use the site named parameter instead. Use the returned id or display_name as the list argument of graph_sharepoint_list_read(), graph_describe_list(), etc. | NULL | [SELECT * FROM graph_show_lists(site := ‘Finance’, secret := ‘ms_graph’), SELECT * FROM graph_show_lists(‘https://tenant.sharepoint.com/sites/Finance’, secret := ‘ms_graph’)] | | graph_show_sites | table | Search and list SharePoint sites accessible via Microsoft Graph. Returns id, name, display_name, web_url, created_at, last_modified_at. Pass an optional search term as the first positional argument to filter by name; omit it to list all accessible sites. | NULL | [SELECT * FROM graph_show_sites(secret := ‘ms_graph’), SELECT * FROM graph_show_sites(‘Finance’, secret := ‘ms_graph’)] | | graph_signin_logs | table | List sign-in logs from Microsoft Entra ID (requires Azure AD Premium P1 or P2). | NULL | [SELECT * FROM graph_signin_logs(secret := ‘ms_entra’)] | | graph_teams_channels | table | List all channels in a Microsoft Teams team. The first argument accepts a team GUID or a displayName (resolved via /me/joinedTeams). | NULL | [SELECT * FROM graph_teams_channels(‘Engineering’, secret := ‘ms_graph’), SELECT * FROM graph_teams_channels(‘xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’, secret := ‘ms_graph’)] | | graph_teams_members | table | List all members of a Microsoft Teams team. The first argument accepts a team GUID or a displayName (resolved via /me/joinedTeams). | NULL | [SELECT * FROM graph_teams_members(‘Engineering’, secret := ‘ms_graph’), SELECT * FROM graph_teams_members(‘xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’, secret := ‘ms_graph’)] | | graph_users | table | List users from Microsoft Entra ID (Azure Active Directory). | NULL | [SELECT * FROM graph_users(secret := ‘ms_entra’)] | | http_delete | table | Send an HTTP DELETE request with a JSON body and return the response as a table. | NULL | [SELECT * FROM http_delete(‘https://httpbin.org/delete’, ‘{}’::JSON)] | | http_delete | table | Send an HTTP DELETE request with raw content and return the response as a table. | NULL | [SELECT * FROM http_delete(‘https://example.com/resource’, ‘’, ‘text/plain’)] | | http_get | table | Send an HTTP GET request and return the response as a table. | NULL | [SELECT * FROM http_get(‘https://httpbin.org/ip’)] | | http_head | table | Send an HTTP HEAD request and return the response headers as a table. | NULL | [SELECT * FROM http_head(‘https://httpbin.org/ip’)] | | http_patch | table | Send an HTTP PATCH request with a JSON body and return the response as a table. | NULL | [SELECT * FROM http_patch(‘https://httpbin.org/patch’, ‘{“key”: “value”}’::JSON)] | | http_patch | table | Send an HTTP PATCH request with raw content and return the response as a table. | NULL | [SELECT * FROM http_patch(‘https://example.com/resource’, ‘patch’, ‘text/plain’)] | | http_post | table | Send an HTTP POST request with a JSON body and return the response as a table. | NULL | [SELECT * FROM http_post(‘https://httpbin.org/post’, ‘{“key”: “value”}’::JSON)] | | http_post | table | Send an HTTP POST request with raw content and return the response as a table. | NULL | [SELECT * FROM http_post(‘https://httpbin.org/post’, ‘hello’, ‘text/plain’)] | | http_put | table | Send an HTTP PUT request with a JSON body and return the response as a table. | NULL | [SELECT * FROM http_put(‘https://httpbin.org/put’, ‘{“key”: “value”}’::JSON)] | | http_put | table | Send an HTTP PUT request with raw content and return the response as a table. | NULL | [SELECT * FROM http_put(‘https://example.com/resource’, ‘data’, ‘text/plain’)] | | odata_attach | table | Attach all entity sets of an OData service as views in the current DuckDB catalog. | NULL | [SELECT * FROM odata_attach(‘https://services.odata.org/V4/Northwind/Northwind.svc/’)] | | odata_describe | table | Describe the schema of an OData entity set by reading its metadata document. | NULL | [SELECT * FROM odata_describe(‘https://services.odata.org/V4/Northwind/Northwind.svc/Customers’)] | | odata_read | table | Read data from an OData v2/v4 entity set with automatic version detection and predicate pushdown. | NULL | [SELECT * FROM odata_read(‘https://services.odata.org/V4/Northwind/Northwind.svc/Customers’)] | | odata_sap_show | table | List available SAP OData entity sets and services at a given service root URL. | NULL | [SELECT * FROM odata_sap_show(‘https:///sap/opu/odata/sap/’)] | | odp_odata_list_subscriptions | table | List all active ODP subscriptions with their status and current delta tokens. | NULL | [SELECT * FROM odp_odata_list_subscriptions()] | | odp_odata_read | table | Read data from a SAP ODP extractor via OData with delta token support for incremental/CDC loads. | NULL | [SELECT * FROM odp_odata_read(‘https:///sap/opu/odata/sap/ZEXTRACTOR_SRV/DataSet’)] | | odp_odata_remove_subscription | pragma | NULL | NULL | | | odp_odata_show | table | List available SAP ODP (Operational Data Provisioning) contexts and extractors at a given OData service root URL. | NULL | [SELECT * FROM odp_odata_show(‘https:///sap/opu/odata/iwbep/GWSAMPLE_BASIC/’)] | | sac_describe_model | table | Get detailed metadata and dimension/measure schema for a SAP Analytics Cloud model. | NULL | [SELECT * FROM sac_describe_model(‘t.2:MY_MODEL’)] | | sac_describe_story | table | Get detailed metadata for a SAP Analytics Cloud story. | NULL | [SELECT * FROM sac_describe_story(‘ABC12345’)] | | sac_read_analytical | table | Read analytical data from a SAP Analytics Cloud model with optional dimension and measure filtering. | NULL | [SELECT * FROM sac_read_analytical(‘t.2:MY_ANALYTICAL_MODEL’)] | | sac_read_planning_data | table | Read planning data from a SAP Analytics Cloud planning model. | NULL | [SELECT * FROM sac_read_planning_data(‘t.2:MY_PLANNING_MODEL’)] | | sac_read_story_data | table | Extract underlying data from a SAP Analytics Cloud story’s visualizations. | NULL | [SELECT * FROM sac_read_story_data(‘ABC12345’)] | | sac_show_models | table | List all planning and analytics models available in SAP Analytics Cloud. | NULL | [SELECT * FROM sac_show_models()] | | sac_show_stories | table | List all stories (dashboards/reports) available in SAP Analytics Cloud. | NULL | [SELECT * FROM sac_show_stories()] |

Überladene Funktionen

Diese Erweiterung fügt keine Funktionsüberladungen hinzu.

Hinzugefügte Typen

Hinzugefügte Einstellungen