List table

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

API for:

1. selecting tables containing original information. Read more under Search for Tables.
2. display tables containing the spectral data. Read more under Spectral Index.
3. display tables containing the glass formation data. Read more under Glass Formation.

This API only lists basic information of tables. To retrieve table data, see Retrieve table.

Query parameters

comp  string or array  Optional

The chemical formula or atomic symbol of the component.

---

atom  boolean  Optional  Defaults to false

Specify the search options, if true, the query is run using the atomic names (atomic symbols), if false, the query is run using the original component names.

Note

In SciGlass, the System type card is disabled and is not considered in the search when Search Options = Atom names. Hence, when atom=true, system_type is ignored and not used in the search.

If this is not the case for the latest SciGlass version, please contact us.

---

system  string or array  Optional

The name of the system. Allowed system names are:

"SiO2"	"R2O"	"RO"
"R2O3"	"RO2"	"R2O5"
"RO3"	"Halides"	"Others"

If used, must be any combination of the allowed system names.

---

exact_system  boolean  Optional  Defaults to false

Whether the systems selected should match exactly or not.

---

system_type  integer  Optional  Defaults to 0

Number of glass systems (system type).

System Type	system_type
All	"0"
One-component (One-comp)	"1"
Binary	"2"
Ternary	"3"
Quaternary	"4"
multi-component (>4 components)	"5"

---

impurity  boolean  Optional  Defaults to true

Whether to consider impurities.

Only effective if system_type is not equal to 0. If true, impurities are considered as components, if false, impurities are ignored and not included in the result.

---

year_from  integer  Optional

Specify for the data since which year. If used, must be greater than or equal to 1878.

---

year_to  integer  Optional

Specify for the data until which year. If used, must be less than or equal to 2019.

---

analysis  boolean  Optional  Defaults to false

Whether only the glass composition given by chemical analysis should be searched.

---

prop  string or array  Optional

The name of the property group.

Note that some prop names are different from the Property Group names. Marked in blue (lightblue when in dark theme).

Property Group	prop
Acoustical properties	"Acoustical properties"
Chemical durability	"Chemical durability"
Crystallization	"Crystallization"
Density	"Density"
Dielectric properties	"Dielectric properties"
Diffusion, permeation & solubility of gases	"Diff., permeat., & solub. of gases"
Elastic properties	"Elastic properties"
Electrical resistivity	"Electrical resistivity"
Glass formation	"Glass formation"
Heat capacity, Cp	"Heat capacity"
Internal friction	"Internal friction"
Ion diffusion	"Ion diffusion"
Dilatometric softening temperature, Mg	"Mg"
Magnetic properties	"Magnetic properties"
Microhardness	"Microhardness"
Optical properties	"Optical properties"
Optical spectra	"Optical spectra"
Stress-optic coefficient	"Srtess-optic coef."
Strength	"Strength"
Surface tension	"Surface tension"
Liquidus temperature, Tliq	"Tliq"
Glass transition temperature, Tg	"Tg"
Thermal expansion coefficient, TEC	"TEC"
Thermal conductivity	"Thermal conductivity"
Thermal diffusivity	"Thermal diffusivity"
Thermal endurance (Thermal shock resistance)	"Thermal endurance"
Viscosity	"Viscosity"
Viscosity standard points	"Visc. standard points"
Volatilization	"Volatilization"

---

spectral_index  boolean  Optional  Defaults to false

If true, this is equivalent to using Optical spectra for prop.

The sidebar function Spectral Index uses https://sciglass.uni-jena.de/api/table?spectral_index=true to get the tables list.

---

glass_formation  boolean  Optional  Defaults to false

If true, this is similar to using Glass formation for prop and set the system_type to binary (system_type=2) or ternary systems (system_type=3). But the tables list returned are more than the tables list you get when using glass_formation=true, as not all tables contain the data for the ternary diagram.

The sidebar function Glass Formation uses https://sciglass.uni-jena.de/api/table?glass_formation=true to get the tables list.

---

table_id  integer or array  Optional

List basic table information by table ID. If multiple table_id are sent, multiple basic table information is also returned.

This is used by Patent Index, Trademark Index, and Subject Index in the web UI to display certain basic information of tables in the Result Card section.

Note

This query parameter only seems to be useful when used internally with the sidebar functions in the web UI.

The response body is the same as in example, but with only table_id specified in query parameter table_id will show.)

---

Example request

PythonCurl

import asyncio  # (1)!

import httpx
import pandas as pd  # (2)!

# List of components
components = ["SiO2", "B2O3", "CaO"]

# List of properties
properties = ["Density", "TEC"]

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

# Create the query parameters
params = {
    "comp": components,
    # "atom": False,  # default=False
    # "system": ["SiO2", "R2O"],  # optional, if used, must be any combination of the allowed system names
    # "exact_system": False,  # default=False
    # "system_type": 0,  # default=0
    # "impurity": True,  # default=True
    # "year_from": 1878,  # optional, if used, must be greater than or equal to 1878
    # "year_to": 2019,  # optional, if used, must be less than or equal to 2019
    # "analysis": False,  # default=False
    "prop": properties,
    # "spectral_index": False,  # default=False
    # "glass_formation": False,  # default=False
}

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, params=params, headers=headers)
        if r.status_code == 200:
            data = r.json()
            print(data)

            # Define the desired column order
            columns = ["table_id", "authors", "year", "components", "properties", "num_glass"]

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

            # Rename the columns
            df = df.rename(columns={
                "table_id": "Table ID",
                "num_glass": "##"
            })

            # Display the DataFrame
            print(df)

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

        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.

curl 'https://sciglass.uni-jena.de/api/table?comp=SiO2&comp=B2O3&comp=CaO&prop=Density&prop=TEC' \
  -H "Accept: application/json" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer $SCIGLASS_NEXT_API_KEY"

---

Response body

[
  {
    "components": "SiO2, Al2O3, B2O3, CaO, BaO, ZnO, Li2O, Na2O, K2O",
    "properties": "Density, TEC, Tg, Optical properties",
    "year": 1988,
    "table_id": 254,  # (1)!
    "authors": "Grigorjev V.S., Yakhkind A.K.",
    "num_glass": 13  # (2)!
  },
  {
    "components": "SiO2, B2O3, BeO, MgO, CaO, SrO, BaO, ZnO, CdO, PbO, Na2O",
    "properties": "Dielectric properties, Density, Optical properties, TEC, Surface tension, Microhardness",
    "year": 1952,
    "table_id": 401,
    "authors": "Appen A.A., Bresker R.I.",
    "num_glass": 12
  }
  # more tables
]

1. table_id means Table ID in the Result Card
2. num_glass means ## in the Result Card