Skip to main content
Solved

Odata url for query single record.

  • May 5, 2025
  • 3 replies
  • 173 views
A
Forum|alt.badge.img

Hello,

I am trying to get data from SFSF and update in LeanIX.

For updating sing record i need to retrieve the ID of the factsheet users.

I used the url below in postman but i get the full result and not the single record which i wanted.

https://xxx.leanix.net/services/pathfinder/v1/factSheets?type=USERS&name='Acson Mino'

My first question is, is it possible with to do this?

If yes, any suggestion is appreciated.

Thanks in advance.

 

Regards,

Antony

Best answer by Antony

Hello All,

I found a solution of using the query below.

https://xxx.leanix.net/services/pathfinder/v1/suggestions?q=Aaron%20MORENO&perType=false

When i use this query i get results. I filter the type=USERS pragmatically and select the Id using Groovy script.

 

Thank you all.

 

Regards,

Antony

    3 replies

    geoffrey.lowney
    Forum|alt.badge.img+2

    My reading of https://xxx.leanix.net/openapi-explorer/#/%2FfactSheets/getFactSheets is that it doesn’t provide filtering.

    Would it be possible for you to use GraphQL instead of the REST API? The allFactSheets GraphQL query has a filter parameter which can be used to filter by displayName (and other things).

    If you need to use REST, you may have to pull the results and filter them yourself.

    Note, from your post above I was not entirely sure if you were looking for a factsheet of type USERS where the factsheet displayName == ‘Ascon Mino’, or if you were trying to find the ID of a system user by that name. For the latter, I believe you would use https://xxx.leanix.net/services/mtm/v1/users or https://xxx.leanix.net/services/mtm/v1/workspaces/<workspaceId>/permissions (see https://xxx.leanix.net/openapi-explorer/#/users/getUsers).

      A
      Forum|alt.badge.img
      • Antony
      • Author
      • Rookie
      • May 6, 2025

      Hi Geoffrey,

      Thanks for the reply. Really appreciated.

      Indeed i am trying to get the ID of the factsheet called ‘USERS’ by querying the name of the user ‘Ascon Mino’

      I need the REST because i use it in SAP CPI to get the ID for updating the Fact sheet for this single user. Ps i do not have access to use the GraphQL on LeanIX and i do not know whether it will help this integration!

      I tried the URL below in postman,

      https://xxx.leanix.net/services/mtm/v1/users and get the result 

      "message": "HTTP 404 Not Found"

       

      Is it something i have to look into the ‘Saved Search’ to achieve this? If yes then how can i send the parameter of the name or displayName?

      Any suggestion?

       

      Thanks in advance.

      Regards,

      Antony

       

      A
      Forum|alt.badge.img
      • Antony
      • Author
      • Rookie
      • Answer
      • May 6, 2025

      Hello All,

      I found a solution of using the query below.

      https://xxx.leanix.net/services/pathfinder/v1/suggestions?q=Aaron%20MORENO&perType=false

      When i use this query i get results. I filter the type=USERS pragmatically and select the Id using Groovy script.

       

      Thank you all.

       

      Regards,

      Antony

        Terms & ConditionsCookie settingsAccessibility statement