How to Purges data in an Log Analytics workspace with "between" operator by API?-CodePudding

I want to purges data for my custom log with TimeGenerated range.

Sample Request

POST https://management.azure.com/subscriptions/00000000-0000-0000-0000-00000000000/resourceGroups/OIAutoRest5123/providers/Microsoft.OperationalInsights/workspaces/aztest5048/purge?api-version=2020-08-01

Request Body

{
  "table": "MY_CUSTOM_TABLE",
  "filters": [
    {
      "column": "TimeGenerated",
      "operator": "between",
      "value": ["2022-01-02T04:00:00","2022-01-07T03:59:59"]
    }
  ]
}

Response Code: 400

Response Body:

{
  "error": {
    "message": "The request had some invalid properties",
    "code": "BadArgumentError",
    "correlationId": "00000000-0000-0000-0000-00000000000",
    "innererror": {
      "code": "QueryValidationError",
      "message": "The user with object Id '00000000-0000-0000-0000-00000000000' does not have the role 'Data Purger' required to perform purge operation on this resource"
    }
  }
}

CodePudding user response：

"message": "The user with object Id '00000000-0000-0000-0000-00000000000' does not have the role 'Data Purger' required to perform purge operation on this resource"

Looking at the Error Message that you have shared above, it is moreover related to access issue. You need to have DataPurger RBAC role on that resource inorder to perform data purge over a particular table in log analytic workspace.

Here is the reference documentation for more information about