Ability to retrieve all location data in CDA

[TC-SAJ]

Hi,

I need assistance in being able to query all location data that is in CWMS for SAJ. I am trying to retrieve all location data in CWMS through the Locations tab /locations/{location-id} endpoint retrieval on the CDA API UI. Are there specific keys for the location-id to be able to retrieve all CWMS location data through one query on the UI? I am only able to get one location data at a time through each query run than getting every location that is in CWMS. This is so my application is able to retrieve every location data from CDA that is in CWMS for generation. Please assist. Thank you.

[krowvin]

Troy,

You might see if the catalog/locations endpoint provides you with what you need in a more timely manner.

To get all locations this endpoint would work:
https://cwms-data.usace.army.mil/cwms-data/catalog/LOCATIONS?office=SAJ

Which returns 500/1753

To get all you can page to the next or simply increase the page-size
i.e.
https://cwms-data.usace.army.mil/cwms-data/catalog/LOCATIONS?page-size=2000&office=SAJ

Speed

You might notice the above could be a bit faster. I had success with them loading all projects within ~5-10 seconds.

You can narrow down what you are looking for with this catalog. For example do the queries in parallel.

Query for Projects:

https://cwms-data.usace.army.mil/cwms-data/catalog/LOCATIONS?office=SAJ&location-kind-like=PROJECT

I set the office to SAJ and the location-kind to PROJECT.
But you could also use the other various filter/parameters to narrow it down.

All turbines for Keystone lake at SWT:

https://cwms-data.usace.army.mil/cwms-data/catalog/LOCATIONS?office=SWT&like=KEYS%2A&location-kind-like=TURBINE
This resolves that there are 2 turbines for keystone!