Changes to OpenAlex

[seancsmith]

The "grants" info from openalex has been deprecated which seems to be breaking our get_openalex_metadata function.
https://docs.openalex.org/api-entities/works/work-object#grants-deprecated
It says it has been replaced by funders and awards but when I use the oa_fetch function I cant see these fields at all. Will look into this further. Let me know if you've looked into this already @meconomou

[meconomou]

https://blog.openalex.org/openalex-api-new-features-and-usage-based-pricing/

we need to add an API key as well when updating the function, see OpenAlex blog

[tamimart]

Tried to run it also and got:

Warning messages:
1: ! oa_fetch() and oa2df() now return new names for some
columns in openalexR v2.0.0.
ℹ See NEWS.md for the list of changes.
ℹ Call get_coverage() to view all updated columns and their
original names in OpenAlex.

`> openalexR::get_coverage()
$works

A tibble: 83 × 3

original oa2df comment

1 abstract_inverted_index abstract reconstructed from inverted index
2 apc_list.currency apc.currency NA
3 apc_list.provenance apc.provenance NA
4 apc_list.value apc.value NA
5 apc_list.value_usd apc.value_usd NA
6 apc_paid.currency apc.currency NA
7 apc_paid.provenance apc.provenance NA
8 apc_paid.value apc.value NA
9 apc_paid.value_usd apc.value_usd NA
10 authorships authorships NA

ℹ 73 more rows

ℹ Use "print(n = ...)" to see more rows

$authors

A tibble: 24 × 3

original oa2df comment

1 affiliations NA NA
2 block_key NA NA
3 cited_by_count cited_by_count NA
4 counts_by_year counts_by_year NA
5 created_date NA NA
6 display_name display_name NA
7 display_name_alternatives display_name_alternatives NA
8 id id NA
9 ids.openalex ids.openalex NA
10 ids.orcid ids.orcid NA

ℹ 14 more rows

ℹ Use "print(n = ...)" to see more rows

$institutions

A tibble: 41 × 3

original oa2df comment

1 associated_institutions associated_institutions NA
2 cited_by_count cited_by_count NA
3 country_code country_code NA
4 counts_by_year counts_by_year NA
5 created_date created_date NA
6 display_name display_name NA
7 display_name_acronyms display_name_acronyms NA
8 display_name_alternatives display_name_alternatives NA
9 geo.city geo.city NA
10 geo.country geo.country NA

ℹ 31 more rows

ℹ Use "print(n = ...)" to see more rows

$keywords

A tibble: 8 × 3

original oa2df comment

1 cited_by_count cited_by_count NA
2 created_date created_date NA
3 display_name display_name NA
4 id id NA
5 relevance_score relevance_score NA
6 updated_date updated_date NA
7 works_api_url works_api_url NA
8 works_count works_count NA

$funders

A tibble: 23 × 3

original oa2df comment

1 alternate_titles alternate_titles NA
2 awards_count awards_count NA
3 cited_by_count cited_by_count NA
4 country_code country_code NA
5 counts_by_year counts_by_year NA
6 created_date created_date NA
7 description description NA
8 display_name display_name NA
9 homepage_url homepage_url NA
10 id id NA

ℹ 13 more rows

ℹ Use "print(n = ...)" to see more rows

$sources

A tibble: 42 × 3

original oa2df comment

1 alternate_titles alternate_titles NA
2 apc_prices apc_prices.currency, apc_prices.price NA
3 apc_usd apc_usd NA
4 cited_by_count cited_by_count NA
5 counts_by_year counts_by_year NA
6 country_code country_code NA
7 created_date created_date NA
8 display_name display_name NA
9 homepage_url homepage_url NA
10 host_organization host_organization NA

ℹ 32 more rows

ℹ Use "print(n = ...)" to see more rows

$publishers

A tibble: 20 × 3

original oa2df comment

1 alternate_titles alternate_titles NA
2 cited_by_count cited_by_count NA
3 country_codes country_codes NA
4 counts_by_year counts_by_year NA
5 created_date created_date NA
6 display_name display_name NA
7 hierarchy_level hierarchy_level NA
8 homepage_url homepage_url NA
9 id id NA
10 ids.openalex ids.openalex NA
11 ids.ror ids.ror NA
12 ids.wikidata ids.wikidata NA
13 image_thumbnail_url image_thumbnail_url NA
14 image_url image_url NA
15 parent_publisher parent_publisher NA
16 sources_api_url sources_api_url NA
17 summary_stats.2yr_mean_citedness summary_stats.2yr_mean_citedness NA
18 summary_stats.h_index summary_stats.h_index NA
19 summary_stats.i10_index summary_stats.i10_index NA
20 works_count works_count NA

$topics

A tibble: 18 × 3

original oa2df comment

1 cited_by_count cited_by_count NA
2 created_date created_date NA
3 description description NA
4 display_name display_name NA
5 domain.display_name domain_display_name NA
6 domain.id domain_id NA
7 field.display_name field_display_name NA
8 field.id field_id NA
9 id id NA
10 ids.openalex ids.openalex NA
11 ids.wikipedia ids.wikipedia NA
12 keywords keywords NA
13 siblings siblings NA
14 subfield.display_name subfield_display_name NA
15 subfield.id subfield_id NA
16 updated_date updated_date NA
17 works_api_url works_api_url NA
18 works_count works_count NA

`

and

Error in select():
! Can't select columns that don't exist.
✖ Column grants doesn't exist.