Hello Mynda,
I would like to extract the data of a list of DOIs from the unpaywall API - https://unpaywall.org/products/api. I can fetch one record each time using the sample query: https://api.unpaywall.org/v2/10.1038/nature12373?email=YOUR_EMAIL , is it possible to batch process a list of DOIs using PQ? (in this example, doi is 10.1038/nature12373)
Thanks,
Jingjing
Hi Jingjing,
If you have a table with DOI strings, add a new column calling a custom function (built based on the sample query and pass to the function the DOI parameter).
Function call will look like this in the new column: GetData([DOI])
In the custom function, you can use parameters to build the string used: "https://api.unpaywall.org/v2/" & DOI & "[email protected]"
Thanks, Catalin.
I added a custom column, used the function Json.Document(Web.Contents()), and retrieved the records for all the DOIs.
-Jingjing
