Skip to content

List author

GET https://sciglass.uni-jena.de/api/author

API for retrieving the Author Index list.

Query parameters

ref_id  integer or array  Optional

The ID of the reference to retrieve.

Example request

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
import asyncio  # (1)!

import httpx
import pandas as pd  # (2)!


# API endpoint
endpoint_url = "https://sciglass.uni-jena.de/api/author"

headers = {
    "Accept": "application/json",
    "Content-type": "application/json",
    "Authorization": "Bearer $SCIGLASS_NEXT_API_KEY"
}


async def example():
    async with httpx.AsyncClient(timeout=None) as client:
        r = await client.get(endpoint_url, headers=headers)
        if r.status_code == 200:
            data = r.json()
            print(data)

            # Define the desired column order
            columns = ["author", "ref_ids"]  # in the web UI, ref_ids column is invisible

            # Convert JSON to DataFrame with specified column order
            df = pd.DataFrame(data, columns=columns)

            # Display the DataFrame
            print(df)

            # Export the result to CSV
            df.to_csv('out.csv', index=False)

            # Below is optional with query parameter

            # Find ref_ids for author "Williams A.E." for example
            row = df[df['author'] == 'Williams A.E.']

            if not row.empty:
                ref_ids = [int(ref_id.strip()) for ref_id in row.iloc[0]['ref_ids'].split('') if ref_id.strip()]
                print(f"Reference IDs: {ref_ids}")

                params = {"ref_id": ref_ids}
                r = await client.get(endpoint_url, headers=headers, params=params)
                if r.status_code == 200:
                    data = r.json()
                    print(data)
                else:
                    print(f"Request failed with status code: {r.status_code}")
                    print("Response text:", r.text)
                    return

        else:
            print(f"Request failed with status code: {r.status_code}")
            print("Response text:", r.text)


asyncio.run(example())
  1. AsyncIO is Python's built-in library for writing concurrent code with the async/await syntax.
  2. This is optional and is imported in this example to show how to export the result to a CSV file using pandas.
1
2
3
4
curl 'https://sciglass.uni-jena.de/api/author' \
  -H "Accept: application/json" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer $SCIGLASS_NEXT_API_KEY"

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
[
  {
    "author": "Parmelee C.W.",  # (1)!
    "ref_ids": "17518014902565269052690641156"  # (2)!
  },
  {
    "author": "Williams A.E.",
    "ref_ids": "17532959"
  },
  # more 
]
  1. Clicking on the Authors name in Author Index window in the Web UI opens a list of all reference stored in the key ref_ids.
  2. ref_ids is invisible in the Web UI, and the Reference ID is separated by a delimiter  (this is not space).
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
[
    {'table_id': 461,
     'ref_id': 175,
     'reference': 'Surface tension of various molten glasses. Badger A.E., Parmelee C.W. and Williams A.E., J.Am.Ceram.Soc., 1937, vol. 20, No. 10, p. 325.'},
    {'table_id': 462,
     'ref_id': 175,
     'reference': 'Surface tension of various molten glasses. Badger A.E., Parmelee C.W. and Williams A.E., J.Am.Ceram.Soc., 1937, vol. 20, No. 10, p. 325.'},
    {'table_id': 35260,
     'ref_id': 32959,
     'reference': 'Notes on barium glasses. Williams A.E. and Cox S.F., Trans.Amer.Cer.Soc., 1916, vol. 18, p. 315.'},
    {'table_id': 460,
     'ref_id': 175,
     'reference': 'Surface tension of various molten glasses. Badger A.E., Parmelee C.W. and Williams A.E., J.Am.Ceram.Soc., 1937, vol. 20, No. 10, p. 325.'},
    {'table_id': 457,
     'ref_id': 175,
     'reference': 'Surface tension of various molten glasses. Badger A.E., Parmelee C.W. and Williams A.E., J.Am.Ceram.Soc., 1937, vol. 20, No. 10, p. 325.'},
    {'table_id': 459,
     'ref_id': 175,
     'reference': 'Surface tension of various molten glasses. Badger A.E., Parmelee C.W. and Williams A.E., J.Am.Ceram.Soc., 1937, vol. 20, No. 10, p. 325.'},
    {'table_id': 458,
     'ref_id': 175,
     'reference': 'Surface tension of various molten glasses. Badger A.E., Parmelee C.W. and Williams A.E., J.Am.Ceram.Soc., 1937, vol. 20, No. 10, p. 325.'}
]