(path)` reads XML or JSON files, globs and URLs through DuckDB's file system (named parameters `members`, `max_records` and `json_root`), and has `orcid_

_xml(xml)` and `orcid_

_json(json)` twins for documents held in a column (lateral joins); likewise `orcid_changes_xml` and `orcid_changes_json`. Every record-table row carries the record iD and a SHA-256 of its source document. Files and archive members are scanned in parallel, in document order, with progress reporting. `orcid_valid` and `orcid_normalize` check and canonicalise iDs (ISO 7064 MOD 11-2; URL prefixes, missing hyphens and a lowercase check digit are accepted). On DuckDB v2.0 the file readers are multi-file readers (lists of paths, `filename` and `file_index` columns, `union_by_name`, `hive_partitioning`, parallel across files). Column reference: https://github.com/mgbilby/yorc-duckdb/blob/main/docs/REFERENCE.md extension_star_count: 1 extension_star_count_pretty: 1 extension_download_count: 521 extension_download_count_pretty: 521 image: '/images/community_extensions/social_preview/preview_community_extension_yorc.png' layout: community_extension_doc --- ### Compatibility Matrix This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 | | :--- | :---: | :---: | :---: | :---: | :---: | | Linux AMD64 | ❌ | ❌ | ❌ | ❌ | ✅ | | Linux ARM64 | ❌ | ❌ | ❌ | ❌ | ✅ | | macOS AMD64 | ❌ | ❌ | ❌ | ❌ | ✅ | | macOS ARM64 | ❌ | ❌ | ❌ | ❌ | ✅ | | Windows AMD64 | ❌ | ❌ | ❌ | ❌ | ✅ | | Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ | | WebAssembly | ❌ | ❌ | ❌ | ❌ | ✅ | ### Installing and Loading ```sql INSTALL {{ page.extension.name }} FROM community; LOAD {{ page.extension.name }}; ``` {% if page.docs.hello_world %} ### Example ```sql {{ page.docs.hello_world }}``` {% endif %} {% if page.docs.extended_description %} ### About {{ page.extension.name }} {{ page.docs.extended_description }} {% endif %} ### Added Functions

| function_name | function_type | description | comment | examples | |------------------------------------|---------------|-------------|---------|----------| | orcid_affiliation_to_json | scalar | NULL | NULL | | | orcid_affiliation_to_xml | scalar | NULL | NULL | | | orcid_affiliations | table | NULL | NULL | | | orcid_affiliations_json | table | NULL | NULL | | | orcid_affiliations_xml | table | NULL | NULL | | | orcid_bulk_works_to_json | scalar | NULL | NULL | | | orcid_bulk_works_to_xml | scalar | NULL | NULL | | | orcid_changes | table | NULL | NULL | | | orcid_changes_json | table | NULL | NULL | | | orcid_changes_xml | table | NULL | NULL | | | orcid_contributors | table | NULL | NULL | | | orcid_contributors_json | table | NULL | NULL | | | orcid_contributors_xml | table | NULL | NULL | | | orcid_documents | table | NULL | NULL | | | orcid_dump_sample | table | NULL | NULL | | | orcid_errors | table | NULL | NULL | | | orcid_errors_json | table | NULL | NULL | | | orcid_errors_xml | table | NULL | NULL | | | orcid_external_ids | table | NULL | NULL | | | orcid_external_ids_json | table | NULL | NULL | | | orcid_external_ids_xml | table | NULL | NULL | | | orcid_funding_to_json | scalar | NULL | NULL | | | orcid_funding_to_xml | scalar | NULL | NULL | | | orcid_fundings | table | NULL | NULL | | | orcid_fundings_json | table | NULL | NULL | | | orcid_fundings_xml | table | NULL | NULL | | | orcid_group_id_to_json | scalar | NULL | NULL | | | orcid_group_id_to_xml | scalar | NULL | NULL | | | orcid_group_ids | table | NULL | NULL | | | orcid_group_ids_json | table | NULL | NULL | | | orcid_group_ids_xml | table | NULL | NULL | | | orcid_history | table | NULL | NULL | | | orcid_history_json | table | NULL | NULL | | | orcid_history_xml | table | NULL | NULL | | | orcid_normalize | scalar | NULL | NULL | | | orcid_notifications | table | NULL | NULL | | | orcid_notifications_json | table | NULL | NULL | | | orcid_notifications_xml | table | NULL | NULL | | | orcid_peer_review_to_json | scalar | NULL | NULL | | | orcid_peer_review_to_xml | scalar | NULL | NULL | | | orcid_peer_reviews | table | NULL | NULL | | | orcid_peer_reviews_json | table | NULL | NULL | | | orcid_peer_reviews_xml | table | NULL | NULL | | | orcid_person | table | NULL | NULL | | | orcid_person_item_to_json | scalar | NULL | NULL | | | orcid_person_item_to_xml | scalar | NULL | NULL | | | orcid_person_items | table | NULL | NULL | | | orcid_person_items_json | table | NULL | NULL | | | orcid_person_items_xml | table | NULL | NULL | | | orcid_person_json | table | NULL | NULL | | | orcid_person_xml | table | NULL | NULL | | | orcid_research_resource_hosts | table | NULL | NULL | | | orcid_research_resource_hosts_json | table | NULL | NULL | | | orcid_research_resource_hosts_xml | table | NULL | NULL | | | orcid_research_resource_items | table | NULL | NULL | | | orcid_research_resource_items_json | table | NULL | NULL | | | orcid_research_resource_items_xml | table | NULL | NULL | | | orcid_research_resource_to_json | scalar | NULL | NULL | | | orcid_research_resource_to_xml | scalar | NULL | NULL | | | orcid_research_resources | table | NULL | NULL | | | orcid_research_resources_json | table | NULL | NULL | | | orcid_research_resources_xml | table | NULL | NULL | | | orcid_search_results | table | NULL | NULL | | | orcid_search_results_json | table | NULL | NULL | | | orcid_search_results_xml | table | NULL | NULL | | | orcid_summary | table | NULL | NULL | | | orcid_summary_items | table | NULL | NULL | | | orcid_summary_items_json | table | NULL | NULL | | | orcid_summary_items_xml | table | NULL | NULL | | | orcid_summary_json | table | NULL | NULL | | | orcid_summary_xml | table | NULL | NULL | | | orcid_timeline | table | NULL | NULL | | | orcid_timeline_json | table | NULL | NULL | | | orcid_timeline_xml | table | NULL | NULL | | | orcid_valid | scalar | NULL | NULL | | | orcid_work_to_json | scalar | NULL | NULL | | | orcid_work_to_xml | scalar | NULL | NULL | | | orcid_works | table | NULL | NULL | | | orcid_works_json | table | NULL | NULL | | | orcid_works_xml | table | NULL | NULL | | ### Overloaded Functions

This extension does not add any function overloads. ### Added Types

This extension does not add any types. ### Added Settings

| name | description | input_type | scope | aliases | typed_value | |-----------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------|--------|---------|-------------| | orcid_crosswalk | orcid writers: emit exactly the XML / JSON bytes of yorc-rs's document writers (the crosswalk format shared with yorc-zig) instead of yorc-duckdb's own layout; a writer's trailing BOOLEAN argument wins over it | BOOLEAN | GLOBAL | [] | false | | temp_directory | Set the directory to which temporary files are written. | VARCHAR | GLOBAL | [] | post.db.tmp |