Skip to content

x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 1 reply
  • Subscribers 69 subscribers
  • Views 204 views
  • Users 0 members are here
Browse Forums
Announcements
141
topics
32
replies
General Discussion
6k
topics
18k
replies
Dan Canetti

RESTful API - Oppo_Deleted not showing

SOLVED
Posted By

Hi,

I'm working with the RESTful API on Sage CRM 2024 R2 and when I pull all Opportunities the Oppo_Deleted value is not showing - which has led to deleted opportunities being included in my results.


The API call I am using is:  XXX/sagecrm2/-/Opportunity


These are the results I am getting back (Demo Data):

The API documentation shows that the Oppo_Deleted value should be included in the returned results:

Has anyone come across this before?

Parents
  • +1
    verified answer

    Had a chance to look further into this and it appears that deleted opportunities aren't pulled into the API call. I've tested by pulling deleted records specifically E.G. sagecrm2/-/Opportunity('225')

    The response:

    {
        "$diagnoses": [
            {
                "$severity": "Error",
                "$applicationCode": "sdata133239",
                "$message": "The requested record was not found. ",
                "$stackTrace": "sdata133239",
                "status": "GONE",
                "$sdataCode": "ApplicationDiagnosis"
            }
        ]
    }
    From looking into the documentation this can also be confirmed by applying the filter ?where=oppo_deleted%20eq%20NULL to the query - this seems to be working for me.
Reply
  • +1
    verified answer

    Had a chance to look further into this and it appears that deleted opportunities aren't pulled into the API call. I've tested by pulling deleted records specifically E.G. sagecrm2/-/Opportunity('225')

    The response:

    {
        "$diagnoses": [
            {
                "$severity": "Error",
                "$applicationCode": "sdata133239",
                "$message": "The requested record was not found. ",
                "$stackTrace": "sdata133239",
                "status": "GONE",
                "$sdataCode": "ApplicationDiagnosis"
            }
        ]
    }
    From looking into the documentation this can also be confirmed by applying the filter ?where=oppo_deleted%20eq%20NULL to the query - this seems to be working for me.
Children
No Data

*Community Hub is the new name for Sage City