zotero-api-notes.md

Zotero API Notes

Links and sample code to access data in Zotero

Links

• Zotero JavaScript API
  • Search Fields
• Zotero Web API v3
• Direct Access to the Zotero SQLite Database
• Plugins for Zotero

Javascript & SQL in the editor

In Zotero Beta, Tools > Developer > Run Javascript

Javascript > Display fields from selected references 🚫 async

var items = Zotero.getActiveZoteroPane().getSelectedItems();
var arr = [];
for(var i=0; i<items.length; i++){
    arr.push({
        title: items[i].getField('title'),
        url: items[i].getField('url')
    });
}
JSON.stringify(arr,null,2);

SQL > Display all creators ✅ async

var sql = `
  SELECT DISTINCT TRIM(firstName || ' ' || lastName) AS creator 
  FROM creators 
  WHERE creatorID IN (
      SELECT creatorID FROM itemCreators JOIN items USING (itemID) WHERE libraryID=1
  ) ORDER BY creator`;
var names = await Zotero.DB.columnQueryAsync(sql);
return names.join('\n');

Next up... https://github.com/tnajdek/zotero-api-client