Add virtual location level endpoint to CDA

[Theresa5683]

Could we add virtual location levels to CDA?

We'd like to use:
Procedure   Store_Virtual_Location_Level

an endpoint for it would be helpful

[krowvin]

Add to this,

Was talking to @MikeNeilson and he mentioned the /levels endpoint (not sure which one) is having issues with the rating. I do not know the details, and was looking to see if an issue had be made. Mike?

Would ideally need that fixed to test via CDA that a virtual level is working after the POST method is made for this.

[MikeNeilson]

It is currently possible to create virtual location levels with the existing API. However, the SwaggerUI was not showing an example of this.

See this PR for example structure of the virtual location level JSON: https://github.com/USACE/cwms-data-api/pull/1815/changes#diff-15fb160ea38d2e825fcd05c4acb86ecc6694705e1bae42bc44a49ad7417dfce9

(That is also the PR that will make sure an example is available in swagger/openapi.)

[MikeNeilson]

Oh, that particular example is for a rating based one (which might be having some issues), if you want to use a non-rating based virtual location level please provide the information here so we can test and have yet-another-example to show others.

[krowvin]

I have not ran the below on test, and i'm not sure what the issue/error is with rating based virtual levels that you mention. (Not currently looking into formula based transforms)

But given the structure you provided above might something like this work? I presume if we run this on test and break something it won't go the other direction and that level would just be borked on test until a fix? Wanting to confirm.

@'
{
  "office-id": "SWT",
  "location-level-id": "DENI.Stor.Inst.0.Top of Conservation",
  "specified-level-id": "Top of Conservation",
  "parameter-id": "Stor",
  "parameter-type-id": "Inst",
  "duration-id": "0",
  "level-units-id": "ac-ft",
  "level-date": "2026-07-02T00:00:00-05:00",
  "level-comment": "Virtual storage level rated from DENI elevation level",
  "constituents": [
    {
      "type": "LOCATION_LEVEL",
      "abbr": "L1",
      "name": "DENI.Elev.Inst.0.Top of Conservation"
    },
    {
      "type": "RATING",
      "abbr": "R1",
      "name": "DENI.Elev;Stor.Linear.Production"
    }
  ],
  "constituent-connections": "L1=R1I1"
}
'@ | curl.exe -X POST "https://cwms-data-test.cwbi.us/cwms-data/levels" `
  -H "accept: application/json;version=2" `
  -H "Content-Type: application/json" `
  -H "Authorization: apikey %CDA_API_KEY_TEST%" `
  --data-binary @-

[MikeNeilson]

Yeah, that should work. At least to store, retrieving data is what appears to be broken at the moment.