Difference between revisions of "UKWA GSuite Add-On"

From COPTR
Jump to navigation Jump to search
m (Added source location and licence.)
 
Line 5: Line 5:
 
*Internet Archive
 
*Internet Archive
 
|homepage=https://github.com/ukwa/ukwa-gsheets-utils
 
|homepage=https://github.com/ukwa/ukwa-gsheets-utils
 +
|sourcecode=https://github.com/ukwa/ukwa-gsheets-utils/blob/master/Code.js
 +
|license=Copyright The British Library
 
|function=Appraisal, Validation
 
|function=Appraisal, Validation
 
|content=Spreadsheet
 
|content=Spreadsheet

Latest revision as of 17:42, 10 December 2021




GSuite functions for people working with web archives. The functions use the Memento API (specifically the TimeGate) to look up whether a given archive holds a given URL. It currently supports checks against:
  • UK Web Archive
  • UK Government Web Archive
  • Internet Archive
Homepage:https://github.com/ukwa/ukwa-gsheets-utils
Source Code:https://github.com/ukwa/ukwa-gsheets-utils/blob/master/Code.js
License:Copyright The British Library
Function:Appraisal,Validation
Content type:Spreadsheet




Description[edit]

To use this tool add a list of URLs to a Google sheet, then select Extensions > Add-ons > and search for UKWA GSuite Add-On. Each user is restricted to 20,000 calls per day by default, which should be kept in mind when planning to check a long list.

Once the Add-On is installed, it can be used to find whether an earlier snapshot of a URL is held in each archive. These formulae are used to query web archive server responses for copies of the URL http://www.bl.uk, in the first row:

  • Cell B2 =WEBARCHIVE_STATUS_UKWA(A2)
  • Cell C2 =WEBARCHIVE_STATUS_UKGWA(A2)
  • Cell D2 =WEBARCHIVE_STATUS_IA(A2)

Results are provided as server codes.

Example Sheet





  • 200 is a successful response for at least one copy.
  • 404 is an unsuccessful response for copies.
  • 451 is a qualified response; that the copy, or copies, are unavailable for legal reasons - in this case, that the copyright owner has not given permission to display legal deposit material on the open web.


User Experiences[edit]