I am trying to delete some data from Dataverse using the API, I need to run this after some testing during a pipeline, hence why I need to use the API.
I am noticing differences between using the API vs UI.
I am trying to delete any rows which were created by a User which starts with SVC...
The below runs successfully in the UI and deletes the relevant rows:
I then try to re-create this with the API, here is the JSON I use:
{
"QuerySet":
[
{
"EntityName": "customeraddress",
"Criteria":
{
"FilterOperator": "And",
"Conditions":
[
{
"AttributeName": "createdby",
"Operator": "BeginsWith",
"Values" : [
{
"Type": "System.String",
"Value": "SVC"
}
]
}
]
}
}
],
"JobName": "Bulk Delete Address - Test Account",
"SendEmailNotification": false,
"RecurrencePattern": "",
"StartDateTime": "2024-12-18T11:09:00Z",
"ToRecipients": [],
"CCRecipients": []
}
I get the below error:
{
"error": {
"code": "0x80040203",
"message": "An exception System.FormatException was thrown while trying to convert input value '[REDACTED]' to attribute 'customeraddress.createdby'. Expected type of attribute value: System.Guid. Exception raised: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)."
}
}
Why can I create this via the UI but not the API?
Any help would be appreciated, thanks.
