How to list all Case Stores in an environment

Through the API console or DQ+ API node, the following query will return the location, name and ID of all Case Stores within a particular environment. The Environment name within the API request body would need to be updated with the appropriate environment name for your setup.

{
  pipelines(envNameOrId: "YOUR_ENV_NAME") {
    edges {
      node {
        name
        paths {
          name
          stages(types: CASE_STORE) {
            edges {
              node {
                stageId
                name
              }
            }
          }
        }
      }
    }
  }
}

Sample output:

{
  "data": {
    "pipelines": {
      "edges": [
        {
          "node": {
            "name": "New Pipeline",
            "paths": [
              {
                "name": "01 - Source",
                "stages": {
                  "edges": []
                }
              },
              {
                "name": "02 - Load into DB",
                "stages": {
                  "edges": []
                }
              },
              {
                "name": "03 - Case Store",
                "stages": {
                  "edges": [
                    {
                      "node": {
                        "stageId": 6551,
                        "name": "Case Store"
                      }
                    }
                  ]
                }
              }
            ]
          }
        },
        {
          "node": {
            "name": "Case Store Intro",
            "paths": [
              {
                "name": "01 - Source Setup",
                "stages": {
                  "edges": []
                }
              },
              {
                "name": "02 - Case Definition",
                "stages": {
                  "edges": [
                    {
                      "node": {
                        "stageId": 6749,
                        "name": "Case Store for header records"
                      }
                    }
                  ]
                }
              },
              {
                "name": "03 - Visualization",
                "stages": {
                  "edges": []
                }
              }
            ]
          }
        },
...