• State Not Answered
  • Replies 1 reply
  • Subscribers 95 subscribers
  • Views 331 views
  • Users 0 members are here
Options
Related

REST API - Entities/Table/Count Body Format

bmj1id
3 months ago

We have a use case for an Internal Application to make an API call to Identity Manager to retrieve the count of approvals pending a specific person.

Has anyone managed to achieve this. My understanding would be that I would need to join for example AttestationCase to AttestationHelper so I can ensure the level numbers match to provide accurate count of pending attestation approvals for the person

The documentation gives basic use case examples and I just haven't been able to work this one out yet.

Thanks.

  • 0 2 months ago

    While there is a need for improved documentation around the APIs with decent examples, I was able to get around my issue by creating a view. 

    I created the view via schema editor, which then makes it accessible to query as table via the APIs. View provides counts of open approvals for requests and attestations and pulls different person Identifiers.

    I can query the view and target the approver with a field such as uid_person and get a response back of the approver and their total open approvalsCount.

    Example Call:
    AppServerInfoHere/AppServer/api/entities/CCCApprovalsCount?where=uid_person%3D'EnterUIDPerson'&displayColumns=Approvals&loadType=Default

    Response:
        "display": "UIDPerson",
    "longDisplay": "UIDPerson",
    "state": 1,
    "values": {
      "Approvals": 16