Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Unable to delete OData resource

(2) ShareShare
ReportReport
Posted on by 9
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:
  • Layan Jwei Profile Picture
    Layan Jwei 7,340 Super User 2024 Season 2 on at
    Unable to delete OData resource
    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"
     
  • SW-10010725-0 Profile Picture
    SW-10010725-0 9 on at
    Unable to delete OData resource
    Worked great. Should have spotted the single quotes on the date. 
     
    Question resolved thank you.
  • Layan Jwei Profile Picture
    Layan Jwei 7,340 Super User 2024 Season 2 on at
    Unable to delete OData resource
    Hi,
     
    Is your issue solved? If yes then please don't forget to verify the answer if it helped.
  • Verified answer
    Layan Jwei Profile Picture
    Layan Jwei 7,340 Super User 2024 Season 2 on at
    Unable to delete OData resource
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,883 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans