---
updatedAt: 2026-06-18T21:15:59.000Z
agentTools:
  siteIndex: https://developers.liveramp.com/llms.txt
  projectIndex: https://developers.liveramp.com/clean-room-api/llms.txt
---

# Fetch a list of all Cleanroom Question Runs for a Cleanroom Question

This operation fetches a list of all the Cleanroom Question Runs (including metadata) for a given Cleanroom Question. The Customer can optionally use the status parameter to filter the list of Cleanroom Question Runs.

> 📘 Changed default `limit`
> The default `limit` value of this call changed from 500 to 30, with a maximum `limit` of 100.

# Troubleshooting question run failure

If the question run status is `FAILED`, possible causes include:

* Issues with data connections
* Missing data
* SQL or Python misconfiguration
* Transient memory issues.

LiveRamp will automatically retry jobs which are failing due to infrastructure issues. You should manually or programmatically retry only if `isRetryable` is true in the API response.

# OpenAPI definition

```json
{
  "openapi": "3.0.0",
  "info": {
    "version": "v1.0.0",
    "title": "External APIs for Customer Integration",
    "description": "APIs to create and fetch Clean Room and related details from LiveRamp (previously Habu) for Customer Integration.",
    "contact": {
      "name": "LiveRamp (previously Habu)",
      "url": "https://liveramp.com/",
      "email": "platform_admin@habu.com"
    }
  },
  "security": [
    {
      "application": []
    }
  ],
  "paths": {
    "/cleanroom-questions/{cleanroomQuestionId}/cleanroom-question-runs": {
      "get": {
        "summary": "Fetch a list of all Cleanroom Question Runs for a Cleanroom Question",
        "operationId": "getAllCleanroomQuestionRuns",
        "description": "This operation fetches a list of all the Cleanroom Question Runs (including metadata) for a given Cleanroom Question. The Customer can optionally use the status parameter to filter the list of Cleanroom Question Runs.",
        "parameters": [
          {
            "name": "cleanroomQuestionId",
            "in": "path",
            "description": "The Cleanroom Question ID to fetch all the associated Cleanroom Question Runs",
            "schema": {
              "type": "string"
            },
            "required": true
          },
          {
            "name": "status",
            "in": "query",
            "description": "The status of the Cleanroom Question Run",
            "schema": {
              "type": "string",
              "enum": [
                "QUEUED",
                "RUNNING",
                "COMPLETED",
                "FAILED",
                "PARTNER_QUEUED",
                "PARTNER_RUNNING",
                "PARTNER_COMPLETED",
                "PARTNER_FAILED",
                "ERROR",
                "PENDING_RETRY"
              ]
            },
            "required": false
          },
          {
            "name": "startDate",
            "in": "query",
            "description": "A filter applied on the SubmitAt field for a Cleanroom Question Run that marks as the beginning of the range of dates. Default is empty - meaning no filter applied. The format is yyyy-MM-dd",
            "schema": {
              "type": "string",
              "format": "date",
              "example": "2024-01-01"
            }
          },
          {
            "name": "endDate",
            "in": "query",
            "description": "A filter applied on the SubmitAt field for a Cleanroom Question Run that marks as the end of the range of dates. Default is empty - meaning no filter applied. The format is yyyy-MM-dd",
            "schema": {
              "type": "string",
              "format": "date",
              "example": "2024-01-01"
            }
          },
          {
            "name": "limit",
            "in": "query",
            "description": "The number of Cleanroom Question Runs returned per page - default is 30 and maximum is 100",
            "schema": {
              "type": "integer",
              "default": 30,
              "maximum": 100
            }
          },
          {
            "name": "offset",
            "in": "query",
            "description": "The offset - default is 0",
            "schema": {
              "type": "integer",
              "default": 0
            }
          }
        ],
        "responses": {
          "200": {
            "description": "Successfully fetched Cleanroom Question Run details",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/QuestionRunsMetadata"
                }
              },
              "application/xml": {
                "schema": {
                  "$ref": "#/components/schemas/QuestionRunsMetadata"
                }
              }
            }
          },
          "400": {
            "$ref": "#/components/responses/BadRequest"
          },
          "401": {
            "$ref": "#/components/responses/Unauthorized"
          },
          "404": {
            "$ref": "#/components/responses/NotFound"
          },
          "500": {
            "$ref": "#/components/responses/InternalServerError"
          }
        },
        "tags": [
          "Cleanroom Question Runs"
        ]
      }
    }
  },
  "components": {
    "responses": {
      "BadRequest": {
        "description": "Bad Request - Incorrect syntax or request",
        "content": {
          "application/json": {
            "schema": {
              "$ref": "#/components/schemas/ReturnObject"
            }
          },
          "application/xml": {
            "schema": {
              "$ref": "#/components/schemas/ReturnObject"
            }
          }
        }
      },
      "NotFound": {
        "description": "The specified resource was not found",
        "content": {
          "application/json": {
            "schema": {
              "$ref": "#/components/schemas/ReturnObject"
            }
          },
          "application/xml": {
            "schema": {
              "$ref": "#/components/schemas/ReturnObject"
            }
          }
        }
      },
      "Unauthorized": {
        "description": "Authorization information was missing or invalid",
        "content": {
          "application/json": {
            "schema": {
              "$ref": "#/components/schemas/ReturnObject"
            }
          },
          "application/xml": {
            "schema": {
              "$ref": "#/components/schemas/ReturnObject"
            }
          }
        }
      },
      "InternalServerError": {
        "description": "Internal Server Error",
        "content": {
          "application/json": {
            "schema": {
              "$ref": "#/components/schemas/ReturnObject"
            }
          },
          "application/xml": {
            "schema": {
              "$ref": "#/components/schemas/ReturnObject"
            }
          }
        }
      }
    },
    "schemas": {
      "QuestionRunMetadata": {
        "description": "Model containing the Cleanroom Question Run Metadata",
        "properties": {
          "id": {
            "type": "string"
          },
          "name": {
            "type": "string"
          },
          "status": {
            "type": "string"
          },
          "submittedAt": {
            "type": "string",
            "format": "date-time"
          },
          "executedAt": {
            "type": "string",
            "format": "date-time"
          },
          "completedAt": {
            "type": "string",
            "format": "date-time"
          },
          "parameters": {
            "type": "object",
            "additionalProperties": {
              "type": "string"
            },
            "example": {
              "parameter1": "Value1",
              "parameter2": "Value2"
            }
          },
          "partitionParameters": {
            "$ref": "#/components/schemas/CleanroomQuestionRunPartitionParameters"
          },
          "runMetadata": {
            "type": "object",
            "properties": {
              "dataOutLocation": {
                "type": "string"
              },
              "datasetParameters": {
                "type": "array",
                "items": {
                  "properties": {
                    "dataSetId": {
                      "type": "string"
                    },
                    "dataSetName": {
                      "type": "string"
                    },
                    "dataInLocation": {
                      "type": "string"
                    },
                    "hashedColumns": {
                      "type": "array",
                      "items": {
                        "type": "string"
                      },
                      "example": [
                        "column1",
                        "column2",
                        "column3"
                      ]
                    }
                  }
                }
              },
              "saltKey": {
                "type": "string"
              }
            }
          },
          "failureReason": {
            "type": "string"
          },
          "isRetryable": {
            "type": "boolean"
          },
          "runMessage": {
            "type": "string"
          },
          "questionVersion": {
            "type": "integer"
          }
        }
      },
      "CleanroomQuestionRunPartitionParameters": {
        "description": "A list of Cleanroom Question Run Partition Parameters",
        "type": "array",
        "items": {
          "$ref": "#/components/schemas/CleanroomQuestionRunPartitionParameter"
        }
      },
      "QuestionRunsMetadata": {
        "description": "A list of Cleanroom Question Runs and their Metadata",
        "type": "array",
        "items": {
          "$ref": "#/components/schemas/QuestionRunMetadata"
        }
      },
      "CleanroomQuestionRunPartitionParameter": {
        "type": "object",
        "properties": {
          "name": {
            "type": "string",
            "description": "Name of Cleanroom Question Run Partition Parameter"
          },
          "value": {
            "type": "string",
            "description": "Value of Cleanroom Question Run Partition Parameter"
          },
          "dataType": {
            "type": "string",
            "description": "Data Type of Cleanroom Question Run Partition Parameter"
          }
        }
      },
      "ReturnObject": {
        "type": "object",
        "properties": {
          "code": {
            "type": "string"
          },
          "message": {
            "type": "string"
          }
        },
        "required": [
          "code",
          "message"
        ]
      }
    },
    "securitySchemes": {
      "application": {
        "type": "oauth2",
        "flows": {
          "clientCredentials": {
            "tokenUrl": "https://api.habu.com/v1/oauth/token",
            "scopes": {}
          }
        }
      }
    }
  },
  "servers": [
    {
      "description": "External APIs for Customer Integration",
      "url": "https://api.habu.com/v1/"
    }
  ],
  "x-readme": {
    "explorer-enabled": false,
    "proxy-enabled": false
  }
}
```