🧪 test-data.json

• Contextual name: 🧪 test-data.json
• ID: /ce/ca/google/sql/sql-instance-public-ip-whitelist/test-data.json

Used In

Logic	Policy	Flags
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Instance External Authorized Networks do not whitelist all public IP addresses 🟢	🟢 x3

Content

Open File

[
  {
    "expectedResult": {
      "status": "DISAPPEARED",
      "conditionIndex": "99",
      "conditionText": "isDisappeared(CA10__disappearanceTime__c)",
      "runtimeError": null
    },
    "context": { "snapshotTime": "2025-01-19T19:03:22Z" },
    "Id": "111",
    "CA10__disappearanceTime__c": "2023-12-06T13:34:16Z",
    "CA10__ipv4Enabled__c": false,
    "CA10__authorizedNetworksJson__c": "[]"
  },
  {
    "expectedResult": {
      "status": "INAPPLICABLE",
      "conditionIndex": "199",
      "conditionText": "extract('CA10__ipv4Enabled__c') != true",
      "runtimeError": null
    },
    "context": { "snapshotTime": "2025-01-19T19:03:22Z" },
    "Id": "112",
    "CA10__disappearanceTime__c": null,
    "CA10__ipv4Enabled__c": false,
    "CA10__authorizedNetworksJson__c": "[]"
  },
  {
    "expectedResult": {
      "status": "COMPLIANT",
      "conditionIndex": "300",
      "conditionText": "otherwise",
      "runtimeError": null
    },
    "context": { "snapshotTime": "2025-01-19T19:03:22Z" },
    "Id": "113",
    "CA10__disappearanceTime__c": null,
    "CA10__ipv4Enabled__c": true,
    "CA10__authorizedNetworksJson__c": "[{\"kind\":\"sql#aclEntry\",\"name\":\"VPN\",\"value\":\"100.150.200.250\"}]"
  },
  {
    "expectedResult": {
      "status": "INCOMPLIANT",
      "conditionIndex": "299",
      "conditionText": "extract('caJsonFrom_authorizedNetworksJson_value__c').contains('0.0.0.0/0')",
      "runtimeError": null
    },
    "context": { "snapshotTime": "2025-01-19T19:03:22Z" },
    "Id": "114",
    "CA10__disappearanceTime__c": null,
    "CA10__ipv4Enabled__c": true,
    "CA10__authorizedNetworksJson__c": "[{\"kind\":\"sql#aclEntry\",\"name\":\"VPN\",\"value\":\"0.0.0.0/0\"}]"
  }
]