[DDS] Failed to GET resource flexibleengine_dds_databaserole

[valentin-dubreuil]

Problem

In the resource flexibleengine_dds_databaserole GET request return HTTP 400 (FlexibleEngine API) error when the ressource does not exist. For crossplane an error must not be returned if the resource does not exist

https://github.com/FrangipaneTeam/provider-flexibleengine/blob/6a4a2050f0a4865faca93b5a6e9ac6271de2b0b3/examples/dds/databaserole.yaml#L1-L2

Error message in provider

Status:
  At Provider:
  Conditions:
    Last Transition Time:  2022-12-28T10:18:05Z
    Message:               observe failed: cannot run refresh: refresh failed: error getting database role (example-dds-database) from DDS instance : Bad request with: [GET https://dds.xxx.prod-cloud-ocb.orange-business.com/v3/xxx/instances/xxx/db-roles?db_name=example_dds_database&role_name=example-dds-database], error message: {"error_code":"DBS.200823","error_msg":"The database does not exist."}:

This error is returned by HuaweiCloud Terraform Provider

https://github.com/huaweicloud/terraform-provider-huaweicloud/blob/ebb8bbb6ae31563c4d3a73fa7b47a1f3dd5e8808/huaweicloud/services/dds/resource_huaweicloud_dds_database_role.go#L276-L280

resp, err := roles.List(client, instanceId, opts)
if err != nil {
	return common.CheckDeletedDiag(d, err, fmt.Sprintf("error getting database role (%s) from DDS instance (%s)", name, instanceId))

Reproduce

1. Clone repo
2. Use branch feature-dds
3. kubectl apply -f examples/dds/databaserole.yaml -f examples/dds/instance.yaml -f examples/vpc/securitygroup.yaml -f examples/vpc/vpcsubnet.yaml -f examples/vpc/vpc.yaml