Help with json get

[HarkenBanks]

Hi all. Sorry if this is redundant and has been covered before. I did not find a match.

I have previously run the following to gather real-time data for Table Rock Lake Dam: https://water.usace.army.mil/a2w/CWMS_CRREL.cwms_data_api.get_dam_elev_json?p_location_id=1884150

This has recently changed, of course. All I can find now is a "time series" option, which I do not need.

Is there are easy json URL such as the above that will pull the real-time surface lake level for Table Rock Lake? Any assistance would be greatly appreciated.

[MikeNeilson]

Apologies, the hosting of the the data api and Access-to-Water (the water.usace.army.mil site) was change recently and we weren't aware that some relied on those particular extras.

The good news is that there is a way to get the elevation data fairly easily using the /timeseries endpoint. Unfortunately, it appears there is both a head and tail water elevations for that project and I'm not sure which one you need so I can't just give you a direct link.

While this does need to be updated a bit this link should get you started: https://github.com/USACE/cwms-data-api/wiki/Finding-Data

The actual Location name is Table_Rock_Dam-Tailwater and Table_Rock_Dam-Headwater, with an office id of SWL. That should help you started.

The data is available in JSON. The Swagger UI has more information https://cwms-data.usace.army.mil/cwms-data/swagger-ui.html

Please reach out again if you have trouble. We are working on improved documentation and questions like this help guide our priorities.

[HarkenBanks]

Thanks Mike. This string brings back the result(s) I'm looking for: https://water.sec.usace.army.mil/cda/reporting/providers/swl/timeseries?name=Table_Rock_Dam-Headwater.Elev.Inst.1Hour.0.Decodes-rev&begin=2025-04-18T02:37:52.918Z&end=2025-04-25T02:37:52.918Z

But I only want the LATEST datapoint. I can't figure out a wildcard that will report only that. I have to provide a specific begin and end time for the query. I haven't found a string to get around that. Any thoughts?

[MikeNeilson]

There is /timeseries/recent endpoint that should work.

Alternatively only end is required, begin will default to 1 day back. Still more data that you desire, but relatively easy to just use the last non-null value. If for some reason the begin parameter is required you can enter something like PT-1D to tell it one day back. Or Some other interval.

[HarkenBanks]

Thank you so much. J.Mobile and on the go!On Apr 24, 2025, at 09:43, Mike Neilson ***@***.***> wrote: Apologies, the hosting of the the data api and Access-to-Water (the water.usace.army.mil site) was change recently and we weren't aware that some relied on those particular extras. The good news is that there is a way to get the elevation data fairly easily using the /timeseries endpoint. Unfortunately, it appears there is both a head and tail water elevations for that project and I'm not sure which one you need so I can't just give you a direct link. While this does need to be updated a bit this link should get you started: https://github.com/USACE/cwms-data-api/wiki/Finding-Data The actual Location name is Table_Rock_Dam-Tailwater and Table_Rock_Dam-Headwater, with an office id of SWL. That should help you started. The data is available in JSON. The Swagger UI has more information https://cwms-data.usace.army.mil/cwms-data/swagger-ui.html Please reach out again if you have trouble. We are working on improved documentation and questions like this help guide our priorities. —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: ***@***.***>

[HarkenBanks]

I had some success after creating some PHP to pull data and present in HTML. Here's the code if anyone is interested in using for a similar purpose.

table-rock-lake-level.txt