Queries related to SAP IDM rest API V2 (Operator OR & Between)

[devaprakash_b]

Hello Experts,

If i would like to retrieve records using IDM REST API v2 for the following cases and unable to find right API.

1) list of users whose validity start date (MX_VALIDFROM) is between 2023-01-01 & 2023-06-30.
no between operator for the dates, so i need to fetch all the user records & store it in oData model & later filter it there if using SAP UI5?

2) list of users who are assigned with user group (MX_ADMINUNIT (help values)) both IT & TEST
Do i need to trigger two API calls one for each value and later merge the results or else fetch all the users assigned with user group and then filter from the list?



/Deva

[junwu]

no between operator for the dates? how you know there is no between operator?

[former_member780990]

Hi Deva,

Regarding your firtst observation, yes, you are correct - "between" operator is not supported in IDM Rest API as described in our documentation:

"Comparator   = Equal
Equal = ' eq '; (* Operator eq is case sensitive! *)" (https://help.sap.com/docs/SAP_IDENTITY_MANAGEMENT/4773a9ae1296411a9d5c24873a8d418c/9f07f3553758490e8...) So, the filtering you need should be done programatically in your UI implementation. This scenario is not supported also in the WebDynpro UIs and it will not be implemented.

Regarding your second question - the documentation states that "For attributes that have a value help, the value key has to be specified as search value. A search for the value text is not supported.". Also, since only AND operator is supported ("In the current version 2, the REST interface supports only the “and” operator."), you cannot really create a request that will check both keys of MX_ADMINUNIT attribute. So again, your suggestion to make to separate requests and merge the results is your best bet.

I hope that helps 🙂

Best regards,
Presiyan