Search by list of ORCIDs to get affiliations

141 views
Skip to first unread message

Tran Ha

unread,
Jul 20, 2020, 7:09:49 PM7/20/20
to ORCID API Users
Hello! I have a list of ORCIDs that I would like to query and get their affiliation org names in either json or csv.  I am new to both ORCID and cURL, so I'm not sure how to best proceed. So far, I've been using the following cURL call to search for an individual ORCID:

curl -X GET --header “Accept:application/json” “https://pub.orcid.org/v3.0/[ORCID]/educations”
 
Is it possible for me to call on a list from a text file or .csv? If yes, what do I need to change in my cURL statement?


Thank you in advance!
Tran Ha


Pedro Costa

unread,
Jul 22, 2020, 11:28:31 AM7/22/20
to ORCID API Users
Hi Tran,

Thanks for posting your question!

If you want to read education-type affiliations exclusively, you'd have to do it one ORCID iD at a time using the cURL call you already know. Calling the "/educations" endpoint will return a full list of (public) education affiliations for the given record.

But if you're OK with getting all affiliation types together, you could do a search call like the one below:


This will return the ORCID iDs together with the institution name of all publicly-visible, current affiliations for the set of ORCID iDs you define in "?q=orcid:()".

It's also possible to get "past-institution-affiliation-name" which can be used in conjunction with "current-institution-affiliation-name" or in its place.

Also, if you want to receive results in JSON instead, the following can be done:


This call will return all publicly-visible affiliations for the list of ORCID iDs.

For more details and example calls please check out our search tutorial: https://github.com/ORCID/ORCID-Source/blob/master/orcid-api-web/tutorial/search.md

Kind regards,

Tran Ha

unread,
Jul 23, 2020, 2:19:55 PM7/23/20
to ORCID API Users
Thank you, Pedro!  That cURL statements for both csv and json work great.  Just making sure, how many OCRIDs can a single call handle?  Is it max 1000?

Pedro Costa

unread,
Jul 24, 2020, 7:39:14 AM7/24/20
to ORCID API Users
Hi Tran,

The calls will return 1000 results by default. You can use pagination to see further results. For example:


The query above will return the first 10 results for ORCID iDs with the family-name Costa.

The one below would return the results 1000 to 2000 for ORCID iDs with the given-name Pedro (it starts at row 1000 and asks for 1000 rows more):


Kind regards,

Pedro Costa
QA & Support Specialist
Reply all
Reply to author
Forward
0 new messages