Complete Database access via web API

chriseana
Hi folks,
Is it possible to have access to all tables and fields of Zotero Database via Web API?

I already did it with the SQLite local database, but now I need to do via Web.
Warm Regards
  • bwiernik
    The Zotero web API uses a different structure than the local SQLite database, so you can’t just use the same scripts. But the functionality is the same.
    https://www.zotero.org/support/dev/web_api/v3/start
  • chriseana
    Hi,
    Thanks for the answer!
    Just to see if I understood correctly.

    I'm using SQL queries like this:

    Select itemNotes.Title, itemTags.tagID, tags.name,
    itemNotes.itemID,
    items.libraryID, itemNotes.parentItemID,
    collectionItems.collectionID,
    collections.collectionName,
    deletedItems.itemID AS Deleted
    From itemTags
    INNER JOIN itemNotes On itemTags.itemID = itemNotes.itemID
    INNER JOIN tags On itemTags.tagID = tags.tagID
    INNER JOIN items On itemNotes.parentItemID = items.itemID
    INNER JOIN collectionItems On collectionItems.itemID = items.itemID
    INNER JOIN collections On collectionItems.collectionID = collections.collectionID
    Left OUTER JOIN deletedItems ON itemTags.itemID = deletedItems.itemID
    WHERE deletedItems.itemID IS NULL
    ORDER BY collectionItems.collectionID, itemTags.tagID,itemNotes.itemID, itemNotes.parentItemID


    Please, observe that I need to have access to special fields like:
    itemID, collectionID, tagID


    It's VERY important.
    Is that possible?
    Warm regards.
  • noksagt
    You're not going to use sql to access. But yes: itemKey and collectionKey are both exposed. Tag IDs can be the literal tag, so it is unclear to me how you're using that.
  • chriseana
    Ok. I know that I'll not use SQL queries. But I need to receive all the data.

    I transfer all this data to another database so I can manipulate it freely. I'm building a software to support qualitative research analysis. I use Zotero to collect the bibliographic data and to extract important info as Notes and tags. After this, I organize the data by tags and explore the relationships between the information. With this, I'm building graphics ( http://socioatlas.xyz/atlas/Graphic_Matrix.svg ) and even an Atlas ( http://socioatlas.xyz/atlas/smcube_atlas.html ).
  • adamsmith
    Zotero uses the API to sync between machines, so yes, you can access all data in the Zotero sqlite via web API, including item, collection, and, tag IDs.
  • chriseana
    Thank you so much @adamsmith !
Sign In or Register to comment.