USACE / USACE/cwms-data-api

XML Parsing fails for Ratings Endpoint

Open
#639 3 comments 0 reactions 2 assignees View on GitHub

@adamkorynta is already working on this.

Since Apr 21, 2026.

automation-tests
Dominant language
Java
Stars
28
Forks
25
Avg merge
4d 22h
Merged PRs (30d)
20

Description

Automation Testing for CWMSjs - /ratings

curl -X 'GET' \
  'https://water.usace.army.mil/cwms-data/ratings?name=KEYS.Elev%3BArea.Linear.Production&office=SWT' \
  -H 'accept: application/json'

Results in

{
"ratings": {
  "query-info": {
    "time-of-query": "2024-05-07T20:13:23Z",
    "process-query": "PT11.278S",
    "format-output": "PT0S",
    "requested-format": "JSON",
    "requested-office": "SWT",
    "requested-start-time": "2024-05-06T20:13:23Z",
    "requested-end-time": "2024-05-07T20:13:23Z",
    "requested-items": [
      {
        "name": "KEYS.Elev;Area.Linear.Production",
        "unit": "NATIVE",
        "datum": "NATIVE"
      }
    ],
    "templates-retrieved": 1,
    "total-specifications-retrieved": 1,
    "unique-specifications-retrieved": 1,
    "total-ratings-retrieved": 1,
    "unique-ratings-retrieved": 1
  },
  "error": "[KEYS.Elev;Area.Linear.Production] ORA-31011: XML parsing failed"
}
}

This rating ID is not special by any means, I just randomly picked it from the results of when I was testing the other ratings endpoints.

If others work then I question why this rating has issues.

Version 2 returns the same, if there is one.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.