CDLUC3 / dmsp_aws_prototype

Sceptre CloudFormation templates for DMPHub v2
MIT License
1 stars 0 forks source link

Add DUNS and UEID ids from NIH API to ROR #42

Closed briri closed 6 months ago

briri commented 1 year ago

Update our copy of the ROR table and add a DUNS and UEID column to store the federal id for the org.

Write a script that calls the NIH API searching in batches of n-records where the search criteria is:

{ 
  "criteria": {
    "org_names": [
      "UNIVERSITY OF CALIFORNIA, DAVIS",
      "STANFORD"
    ]
  },
  "include_fields": [
    "Organization"
  ]
}

This should return something like:

"organization": {
  "org_name": "UNIVERSITY OF CALIFORNIA AT DAVIS",
  "org_city": "DAVIS",
  "org_country": "UNITED STATES",
  "org_state": "CA",
  "dept_type": "NEUROLOGY",
  "org_duns": [
     "047120084"
   ],
   "org_ueis": [
     "TX2DAGQPENZ5"
   ],
   "primary_duns": "047120084",
   "primary_uei": "TX2DAGQPENZ5",
   "org_fips": "US",
   "org_ipf_code": "577503",
   "org_zipcode": "956186153",
   "external_org_id": 577503
 }

We can then compare the results to the ROR data we have:

{
  "name": "University of Wollongong",
  "acronyms": ["UOW"],
  "aliases": ["Wollongong University"],
  "country": {
    "country_code": "AU", 
    "country_name": "Australia"
  }
}
briri commented 1 year ago

Just update DMP creation to do a lookup on Project/Award ids and connect the UEID and DUNS to the ROR record. Will require those fields be added to the ROR table