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.
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:
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.