USACE / USACE/cwms-data-api

Need to fetch specific rating table by effective date

Open
#1,691 2 comments 0 reactions 1 assignee View on GitHub

@rma-psmorris is already working on this.

Since Apr 13, 2026.

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

Description

It doesn't seem possible to fetch a specific rating table that isn't the latest. It's either the latest, or all tables.
Fetching all tables takes a long time and frequently returns an Oracle XML error, so I'd rather not do that.

Describe the solution you'd like
Something that operates as the equivalent of this SQL query:

SELECT IND_VALUE_1, DEP_VALUE FROM CWMS_20.AV_RATING_VALUES_NATIVE  where rating_code=? order by ind_value_1 asc

Something like /ratings/{rating-id}/{effective-date}.
I use the rating code internally, which is unique. However that's not exposed in any of the CDA methods, so I guess rating-id and effective-date have to work.

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.