Introduction for Foodb API (Beta)

Food Table

GET request (Content-type: application/json):

response:

Search Options:

Operator	Usage	Description
food_name	`{"food_name": "Apple"}`	Search the food that match the `food_name`.
page	`{"page" : 1 }`	Required. For selecting the page.

Compound Table

GET request (Content-type: application/json):

response:

{
    "status": 200,
    "value": [
        {
            "id": 4,
            "legacy_id": 4,
            "type": "SmallMoleculeCompound",
            "public_id": "FDB000004",
            "name": "Cyanidin 3-(6''-acetyl-galactoside)",
            "export": true,
            "state": null,
            "annotation_quality": "low",
            "description": "Constituent of the leaves of Nymphaea alba [CCD]. Cyanidin 3-(6''-acetyl-galactoside) is found in lowbush blueberry and highbush blueberry.",
            "cas_number": "350602-26-5",
            "melting_point": null,
            "protein_formula": null,
            "protein_weight": null,
            "experimental_solubility": null,
            "experimental_logp": null,
            "hydrophobicity": null,
            "isoelectric_point": null,
            "metabolism": null,
            "kegg_compound_id": null,
            "pubchem_compound_id": null,
            "pubchem_substance_id": null,
            "chebi_id": null,
            "het_id": null,
            "uniprot_id": null,
            "uniprot_name": null,
            "genbank_id": null,
            "wikipedia_id": null,
            "synthesis_citations": null,
            "general_citations": null,
            "comments": null,
            "protein_structure_file_name": null,
            "protein_structure_content_type": null,
            "protein_structure_file_size": null,
            "protein_structure_updated_at": null,
            "msds_file_name": null,
            "msds_content_type": null,
            "msds_file_size": null,
            "msds_updated_at": null,
            "creator_id": null,
            "updater_id": 2,
            "created_at": "2010-04-08T22:04:24.000Z",
            "updated_at": "2020-02-24T19:10:06.000Z",
            "phenolexplorer_id": 6,
            "dfc_id": "ODW39-O:OYT26-K",
            "hmdb_id": "HMDB29236",
            "duke_id": null,
            "drugbank_id": null,
            "bigg_id": null,
            "eafus_id": null,
            "knapsack_id": null,
            "boiling_point": null,
            "boiling_point_reference": null,
            "charge": null,
            "charge_reference": null,
            "density": null,
            "density_reference": null,
            "optical_rotation": null,
            "optical_rotation_reference": null,
            "percent_composition": "C 56.21%; H 4.72%; O 39.07%",
            "percent_composition_reference": "CCD",
            "physical_description": null,
            "physical_description_reference": null,
            "refractive_index": null,
            "refractive_index_reference": null,
            "uv_index": null,
            "uv_index_reference": null,
            "experimental_pka": null,
            "experimental_pka_reference": null,
            "experimental_solubility_reference": null,
            "experimental_logp_reference": null,
            "hydrophobicity_reference": null,
            "isoelectric_point_reference": null,
            "melting_point_reference": null,
            "moldb_alogps_logp": "1.77",
            "moldb_logp": "0.8161",
            "moldb_alogps_logs": "-3.13",
            "moldb_smiles": "[H][C@]1(COC(C)=O)O[C@@]([H])(OC2=CC3=C(O)C=C(O)C=C3[O+]=C2C2=CC=C(O)C(O)=C2)[C@]([H])(O)[C@@]([H])(O)[C@@]1([H])O",
            "moldb_pka": "7.4580",
            "moldb_formula": "C23H23O12",
            "moldb_average_mass": "491.4215",
            "moldb_inchi": "InChI=1S/C23H22O12/c1-9(24)32-8-18-19(29)20(30)21(31)23(35-18)34-17-7-12-14(27)5-11(25)6-16(12)33-22(17)10-2-3-13(26)15(28)4-10/h2-7,18-21,23,29-31H,8H2,1H3,(H3-,25,26,27,28)/p+1/t18-,19+,20+,21-,23-/m1/s1",
            "moldb_mono_mass": "491.1189512",
            "moldb_inchikey": "HBXXDBKJLPLXPR-DLBZZEGUSA-O",
            "moldb_alogps_solubility": "3.94e-01 g/l",
            "moldb_id": 80753,
            "moldb_iupac": "3-{[(2S,3R,4S,5R,6R)-6-[(acetyloxy)methyl]-3,4,5-trihydroxyoxan-2-yl]oxy}-2-(3,4-dihydroxyphenyl)-5,7-dihydroxy-1$l^{4}-chromen-1-ylium",
            "structure_source": "MANUAL",
            "duplicate_id": null,
            "old_dfc_id": null,
            "dfc_name": "3,3',4',5,7-Pentahydroxyflavylium(1+); 3-O-(6-O-Acetyl-b-D-galactopyranoside)",
            "compound_source": "PHENOLEXPLORER",
            "flavornet_id": null,
            "goodscent_id": null,
            "superscent_id": null,
            "phenolexplorer_metabolite_id": null,
            "kingdom": "Organic compounds",
            "superklass": "Phenylpropanoids and polyketides",
            "klass": "Flavonoids",
            "subklass": "Flavonoid glycosides",
            "direct_parent": "Anthocyanidin-3-O-glycosides",
            "molecular_framework": "Aromatic heteropolycyclic compounds",
            "chembl_id": null,
            "chemspider_id": null,
            "meta_cyc_id": null,
            "foodcomex": null,
            "phytohub_id": null,
            "vmh_id": null,
            "fbonto_id": null,
            "status": 2
        }
    ],
    "total_count": null,
    "date": "03/03/2020 15:25",
    "api_version": "v1",
    "licence": "DEMO",
    "count": 1
}

Search Options:

Operator	Usage	Description
compound_name	`{"compound_name": "Cyanidin"}`	Search the compound that match the `compound_name`. You can apply `filter` to select the molecule in certain weight range. If use `compound_id` or `cas_number` search compound, this field wouldn't apply.
page	`{"page" : 1 }`	Required. For selecting the page.
compound_id	`{"compound_id": "FDB000004"}` `{"compound_id": "4"}`	Search the compound using either id or public_id.
cas_number	`{"cas_number": "350602-26-5"}`	Search the compound using cas number. This field will be ignored if `compound_id` presents.
inchikey	`{"inchikey": "HBXXDBKJLPLXPR-DLBZZEGUSA-O"}`	Search the compound using inchikey. This field will be ignored if `compound_id` or `cas_number` presents.
filter	`"filters": { "max_weight": 100, "min_weight": 0 }`	Filter only apply if you choose to use `compound_name` to search the compound.

Content Table

GET request (Content-type: application/json):

response:

{
    "status": 200,
    "value": [
        {
            "id": 992388,
            "source_id": 30720,
            "source_type": "Compound",
            "food_id": 1,
            "orig_food_id": null,
            "orig_food_common_name": null,
            "orig_food_scientific_name": null,
            "orig_food_part": null,
            "orig_source_id": null,
            "orig_source_name": null,
            "orig_content": null,
            "orig_min": null,
            "orig_max": null,
            "orig_unit": null,
            "orig_citation": null,
            "citation": "MANUAL",
            "citation_type": "UNKNOWN",
            "creator_id": null,
            "updater_id": null,
            "created_at": "2015-05-07T19:29:57.000Z",
            "updated_at": "2015-05-07T19:29:57.000Z",
            "orig_method": null,
            "orig_unit_expression": null,
            "standard_content": null,
            "preparation_type": null,
            "export": 1
        },
        ...
    ]
}

Search Options:

Operator	Usage	Description
compound_id	`{"compound_id": 1}` or `{"compound_id": "FOOD00001"}`	Search the associated food by giving `compound_id`. Search by name is not allowed. We advise you search by compound name in compound table.
food_id	`{"food_id": 1}` or `{"food_id": "FOOD000001"}`	Search the associated compound and nutrient by giving `food_id`. Search by name is not allowed. We advise you search by food name in food table.
page	`{"page" : 1 }`	Required (only if you select only one of compound_id and food_id)
page_size	`{"page_size" : 100 }`	Optional, allows changing the number of results per page. Default is 10.

Any unauthorized access and abuse will be blocked permanent.