Hello @T Brack ,
Apologies for the delay and thank you for the clarification , I just tried to run that REST API and observed below:
For example resourceGroups (output1) & resourcegroups (output2). I think you were referring to those scenarios .
Output1:
"id": "/subscriptions/subid/resourcegroups/ace-cxp/providers/microsoft.search/searchservices/acecxp-as4abnidkrxv43o/providers/Microsoft.ResourceHealth/availabilityStatuses/current"
Output2:
"id": "/subscriptions/subid/resourceGroups/VisualStudioVM/providers/Microsoft.Compute/
virtualMachines/VisualStudioVM/providers/Microsoft.ResourceHealth/availabilityStatuses/current
As I am following up internally , as an alternate work around can you try converting everything to lower case before inserting into the database.
Regards,
Shiva.