Skip to content

/ in Pump Accounting Path Causes a 404/400 Error for Contract Name #1216

@krowvin

Description

@krowvin

When querying/storing to SWT's database for a contract name in water supply we receive a 404 error.

The issue appears to be with the / in the contract-name. Which ends up being needed in the path, parameter, and payload.

@MikeNeilson mentioned this also might be what causes issues with blob-id if you try to make a path out of the id?

Help Working Past this Now

While a fix could eventually come (for CDA itself), in order for SWT to migrate to the cloud sooner we are open to renaming this.

SWT can rename this contract-name as this does not correspond to an actual contract. However, we are not sure how to go about that process without JDBC. REGI has this field grayed out in the pertinent data tab.

Attempted POST to PUMP_ACCOUNTING:

Attempt 1 : Local Live T7 CDA Version: 2025.05.08
curl -X 'POST' \
  'https://T7-SWT:8243/swt-data/projects/SWT/HUDS/water-user/GRDA/contracts/Salina%20Pumpback%20Generators%2FPumps/accounting' \
  -H 'accept: */*' \
  -H 'Content-Type: application/json;version=1' \
  -d '{
    "contract-name": "Salina Pumpback Generators/Pumps",
    "water-user": {
        "entity-name": "GRDA",
        "project-id": {
            "office-id": "SWT",
            "name": "HUDS"
        },
        "water-right": "State of Oklahoma"
    },
    "pump-locations": {
        "pump-out": {
            "office-id": "SWT",
            "name": "HUDS-SalinaPumps"
        }
    },
    "pump-accounting": {
        "2025-07-25T17:00:00Z": [
            {
                "pump-type": "OUT",
                "transfer-type-display": "Conduit",
                "flow": 2.2,
                "comment": "Pump from HUDS"
            }
        ]
    }
}'

Error Response (nothing in logs I could see)

<!doctype html><html lang="en"><head><title>HTTP Status 400 – Bad Request</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP Status 400 – Bad Request</h1><h3>Apache Tomcat/9.0.102</h3></body></html>
Attempt 2 : CWBI Dev Environment - CDA Version: 2025.08.06-develop
{
    "contract-name": "Salina Pumpback Generators/Pumps",
    "water-user": {
        "entity-name": "GRDA",
        "project-id": {
            "office-id": "SWT",
            "name": "HUDS"
        },
        "water-right": "State of Oklahoma"
    },
    "pump-locations": {
        "pump-out": {
            "office-id": "SWT",
            "name": "HUDS-SalinaPumps"
        }
    },
    "pump-accounting": {
        "2025-07-25T17:00:00Z": [
            {
                "pump-type": "OUT",
                "transfer-type-display": "Conduit",
                "flow": 2.2,
                "comment": "Pump from HUDS"
            }
        ]
    }
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingpriority:lowLocation within the general TODO list.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions