bibi/test/api test.py

# -*- coding: utf-8 -*-
"""
Created on Wed Mar 11 16:18:40 2020

@author: hsuwei
"""
import os
import pandas as pd
import re
import numpy as np
from pathlib import Path
import sys
from pyzotero import zotero

ibrary_id = '6442814'
ibrary_type = 'user'
api_key = 'RmNVIoIEegFWxPiiVW6fKr17'

zot = zotero.Zotero(ibrary_id, ibrary_type, api_key)
# we now have a Zotero object, zot, and access to all its methods
first_ten = zot.items(limit=10)
# a list containing dicts of the ten most recently modified library items

# Read my csv
os.chdir('C:\\Users\\user\\Desktop\\2020\\up')
df0 = pd.read_csv('airi.csv')

keep = ['Item Type',
        'Publication Year',
        'Author',
        'Title',
        'Publication Title',
        'DOI',
        'Url',
        'Pages',
        'Num Pages',
        'Issue',
        'Volume',
        'Publisher',
        'Place',
        'Language',
        'Rights',
        'Type',
        'Extra',
        'Conference Name'
            ]

df = df0.loc[:, keep]
ex = df.iloc[0, :]

template = zot.item_template(ex[0])
template['creators'][0]['lastName'] = (ex['Author'])
# template['creators'][0]['lastName'] = 'Cantsin'
template['title'] = ex['Title']

template['publicationTitle'] = ex['Publication Title']
template['volume'] = ex['Volume']
template['issue'] = ex['Issue']
# template['pages'] = ex['Pages']
# template['date'] = ex['']
# template['language'] = ex['Language']
# template['DOI'] = ex['DOI']
# template['ISSN'] = ex['']

# template['url'] = ex['Url']
# template['accessDate'] = ex['']
# template['rights'] = ex['Rights']
# template['extra'] = ex['Extra']
# template['tags'] = ex['']
# template['collections'] = ex['']


# TODO: 不能用nan

resp = zot.create_items([template])