import requests
import json
import pandas as pd

# Make API request to desired endpoint
url = "https://www.oceandnaexplorer.org//api/project"
response = requests.get(url)

# Check if request was successful
if response.status_code == 200:
    # Parse JSON response and print it
    data = response.json()
    results = data['result']
    print("JSON Response:")
    print(json.dumps(results, indent=2))

    # Convert to DataFrame and print it
    df = pd.DataFrame(results)
    print("--------------------")
    print("DataFrame:")
    print(df)
else:
    print(f"Error: {response.status_code}")
    if response.content:
        print(f"Error message: {response.json()['error']}")

library(httr)
library(jsonlite)

# Make API request
url <- "https://www.oceandnaexplorer.org//api/project"
response <- GET(url)

# Check if request was successful
if (http_status(response)$category == "Success") {
  # Parse JSON response
  data <- content(response, "text") %>% fromJSON()
  results <- data$result
  print(results)
} else {
  print(paste("Error:", http_status(response)$reason))
  if (length(content(response)) > 0) {
    print(paste("Error message:", content(response)$error))
  }
}

{
  "message": "Success",
  "result": [
    "project",
    "sample",
    "assay",
    "library",
    "analysis",
    "occurrence",
    "feature",
    "assignment",
    "taxonomy"
  ]
}

{
  "message": "Success",
  "result": [{
    "id": 1,
    "project_id": "noaa-aoml-gomecc4",
    "userId": "user_2de7fXfAmCCpbB6yr6PbK0Esc9f",
    "dateSubmitted": "2025-03-03T16:26:52.455Z",
    "recordedBy": "Luke Thompson",
    "recordedByID": "https://orcid.org/0000-0002-3911-1280",
    "project_contact": "Luke Thompson",
    "institution": "NOAA/AOML",
    "institutionID": "https://www.aoml.noaa.gov/omics",
    "project_name": "eDNA from Gulf of Mexico Ecosystems and Carbon Cruise 2021 (GOMECC-4)",
    "study_factor": "water column spatial series",
    "detection_type": "multi taxon detection",
    "license": "http://creativecommons.org/publicdomain/zero/1.0/legalcode",
    "rightsHolder": "US Government",
    "accessRights": "no rights reserved",
    "informationWithheld": "no information withheld",
    "dataGeneralizations": "no data generalizations",
    "bibliographicCitation": "https://doi.org/10.1101/2024.07.30.605667",
    "associated_resource": "http://www.earthmicrobiome.org/",
    "mod_date": "2024-10-31T04:00:00.000Z",
    "checkls_ver": "1.1",
    "seq_archive": "PRJNA887898",
    "code_repo": "https://github.com/aomlomics/gomecc",
    "expedition_id": "GOMECC-4 (2021)"
  }]
}

{
  "message": "Success",
  "result": [
    { "id": 1, "project_name": "eDNA from Gulf of Mexico Ecosystems and Carbon Cruise 2021 (GOMECC-4)" }
  ]
}

{
  "message": "Success",
  "result": {
    "id": 22,
    "taxonomy": "Eukaryota;Obazoa;Opisthokonta;Metazoa;Arthropoda;Crustacea;Maxillopoda;Centropages;Centropages_furcatus;",
    "verbatimIdentification": "Eukaryota;Obazoa;Opisthokonta;Metazoa;Arthropoda;Crustacea;Maxillopoda;Centropages;Centropages_furcatus;",
    "domain": null,
    "kingdom": "Eukaryota",
    "supergroup": "Obazoa",
    "division": "Opisthokonta",
    "subdivision": "Metazoa",
    "phylum": null,
    "class": "Arthropoda",
    "order": "Crustacea",
    "family": "Maxillopoda",
    "genus": "Centropages",
    "species": "Centropages furcatus"
  }
}

{
  "message": "Success",
  "result": [
    { "id": 1, "project_name": "Gulf of Mexico Metabarcoding" },
    { "id": 2, "project_name": "Atlantic Coastal eDNA Survey" }
  ]
}

{
  "message": "Success",
  "result": [
    {
      "id": 1,
      "project_name": "Gulf of Mexico Metabarcoding",
      "description": "Metabarcoding study of the Gulf of Mexico",
      "samples": [
        {
          "id": 1,
          "sample_id": "GOM-001",
          "collection_date": "2022-05-15",
          "location": "Gulf of Mexico"
        },
        {
          "id": 2,
          "sample_id": "GOM-002",
          "collection_date": "2022-05-16",
          "location": "Gulf of Mexico"
        }
      ]
    }
  ]
}

{
  "message": "Success",
  "result": [
    {
      "id": 10,
      "project_name": "Test Project",
      "description": "A test project",
      "institution": "University of Marine Science"
    }
  ]
}

{
  "message": "Success",
  "result": [
    {
      "id": 1,
      "project_name": "Gulf of Mexico Metabarcoding",
      "samples": [
        { "id": 1 },
        { "id": 2 }
      ]
    },
    {
      "id": 2,
      "project_name": "Atlantic Coastal eDNA Survey",
      "samples": [
        { "id": 3 },
        { "id": 4 }
      ]
    }
  ]
}

{
  "message": "Success",
  "result": {
    "id": 5,
    "project_name": "Caribbean Coral Microbiome Study",
    "samples": [
      { "id": 15 },
      { "id": 16 },
      { "id": 17 }
    ]
  }
}