Unable to delete OData resource

(3) Share

Report

Posted on by SW-10010725-0

I am doing data cleanse and need to delete records from PartyLocationPostalAddressV2 entity. I am testing this via Postman but receive a 404 error:

"No HTTP resource was found that matches the request URI 'https://baseurl/data/PartyLocationPostalAddressesV2(PartyNumber='000030015',LocationId='000033119',ValidFrom='2025-01-09T14:56:43Z')'. No route data was found for this request."
 
This would seem to indicate that the endpoint cannot locate the record but the key/values are correct.
 
My DELETE request is
{{resource}}/data/PartyLocationPostalAddressesV2(PartyNumber='000030015',LocationId='000033119',ValidFrom='2025-01-09T14:56:43Z') 
 
The key fields for the data entity are confirmed as per AOT browser and I have tried with combinations of all three.
 
I have confirmed the keys and values by doing a GET request
{{resource}}/data/PartyLocationPostalAddressesV2?$filter=LocationId eq '000033119'
 
        {
            "@odata.etag": "W/\"JzEsNTYzNzI0MzU4MDsxODIwNjQxODMwLDU2MzcyMTY1Nzkn\"",
            "PartyNumber": "000030015",
            "LocationId": "000033119",
            "ValidFrom": "2025-01-09T14:56:43Z",
            "IsPrimary": "No",
            "CityInKana": "",
            "IsRoleDelivery": "No",
            "IsPrivate": "No",
            "Address": "123 My Avenue\nLondon\nW1 2JG\nGBR",
            "TimeZone": null,
            "Street": "123 My Avenue",
            "Latitude": 0,
            "Description": "Address 3",
            "IsRoleInvoice": "No",
            "Roles": "Business",
            "StreetInKana": "",
            "IsRoleHome": "No",
            "Apartment_RU": "",
            "IsPrimaryTaxRegistration": "No",
            "FormattedDeliveryAddress": "123 My Avenue\nLondon\nW1 2JG\nGBR",
            "AssignmentDate": "2025-01-09T14:57:15Z",
            "DunsNumber": "",
            "AttentionToAddressLine": "",
            "ValidTo": "2154-12-31T23:59:59Z",
            "County": "",
            "IsLocationOwner": "Yes",
            "Building_RU": "",
            "DistrictName": "",
            "IsPrivatePostalAddress": "No",
            "Longitude": 0,
            "City": "London",
            "StreetNumber": "",
            "IsRoleBusiness": "Yes",
            "CountryRegionId": "GBR",
            "State": "",
            "PostBox": "",
            "BuildingCompliment": "",
            "ZipCode": "W1 2JG",
            "CountryRegionISOCode": "GB"
        }
 

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Here's the get url:
{{resource_dev12}}/data/PartyLocationPostalAddressesV2?$filter=LocationId eq 'FO-000259089' and PartyNumber eq 'FO-000410001' and ValidFrom eq 2025-01-10T19:09:06Z

and here's the delete url:
{{resource_dev12}}/data/PartyLocationPostalAddressesV2(LocationId='FO-000259089',PartyNumber='FO-000410001',ValidFrom=2025-01-10T19:09:06Z)

I just tried it and it works fine, the record was deleted successfully (you need to remove the single quotations from the dateTime)

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future.

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your issue solved? If yes then please don't forget to verify the answer if it helped.

Was this reply helpful? Yes No
SW-10010725-0 11 on at

Like (1)

Report
Copy link

Link copied!

Worked great. Should have spotted the single quotes on the date.

Question resolved thank you.

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I'm glad your issue is fixed.

Can you please verify the answer by going to the reply that had the answer, and then tick the box that says "Does this answer your question"

Was this reply helpful? Yes No