108
Views
10
Comments
Solved
How to get list of consumed Rest API methods

I've found this post that has helped me identify the REST services being consumed in my Factory using the OSSYS_REST_WEB_REFERENCE table. This table contains information at the Base URL level. However, I want to be able to find information about the API Methods being hosted.

Can anybody tell me if there's a system table available that I can query to reveal the URL Paths of consumed REST API's?

 

Thanks,

Ben 

UserImage.jpg
Ben Wolrige
Solution

Hey everyone - thank you all for your replies. What I have learned from our OutSystems technical success manager is that the Base URL can be obtained via the OSSYS_REST_WEB_REFERENCE table, however the relative path of each web method underneath the Base URL is held in the OML file and hence cannot be found via a query.

I'm planning to interrogate our Integration logs in Service Center to see if I can derive the report I need from there.

Thanks again - I was pleasantly surprised by how much help so many of you offered :)

2022-12-30 07-28-09
Navneet Garg

Thanks for sharing very good information.

2025-01-31 03-15-38
Irfan Ahamed Abdul Shukoor

Dear @Ben Wolrige ,

Greeting,

There is a table available, because we have analystis report that can be generated which will give us the integration details and API's that were hit and consumed. Let me try to find the table and update you.


Regards,
Irfan Ahamed

2022-12-30 07-28-09
Navneet Garg
UserImage.jpg
Ben Wolrige

Hi Navneet,

You've linked to the same post that I mentioned in my initial question :)

Unfortunately the OSSYS_REST_WEB_REFERENCE is not granular enough for my requirements, which is to get a list of the API methods. OSSYS_REST_WEB_REFERENCE only lists the Base URL.

I appreciate your response - so thanks!

2022-12-30 07-28-09
Navneet Garg

Oh sorry for that check the following

https://www.outsystems.com/forums/discussion/99242/how-to-list-rest-api-methods-and-they-parameters/

  • OSSYS_REST_API: Contains metadata for exposed REST APIs.
  • OSSYS_REST_API_METHOD: Contains methods for exposed REST APIs.

I am also trying this will let you know if get any solution.

2021-11-12 04-59-31
Manikandan Sambasivam

Hi,

You simply need to reference the Web_Reference entity from the System module and query it. 


2024-09-12 02-43-38
Deepsagar Dubey

Hi @Ben Wolrige 

You can try to use API Management Console forge component, It'll show you both URL & Effective URL of consumed API within an environment.

Thanks
Deep 

2024-12-02 13-16-47
Vipin Yadav

Hi,

To find the URL paths of consumed REST APIs, you can check the WEB_REFERENCE table. This table contains details about the individual API.

Thanks,

Vipin Yadav

2022-12-30 07-28-09
Navneet Garg

@Vipin Yadav WEB_REFERENCE shows only the name and url but not the method type like GET, POST, DELETE etc. is there any way to find that ?

I got one reference 

https://www.outsystems.com/forums/discussion/99242/how-to-list-rest-api-methods-and-they-parameters/

which talk about 

  • OSSYS_REST_API: Contains metadata for exposed REST APIs.
  • OSSYS_REST_API_METHOD: Contains methods for exposed REST APIs.
  • OSSYS_REST_WEB_REFERENCE: Contains metadata for consumed REST APIs.
  • OSSYS_REST_WEB_REF_METHOD: Contains methods for consumed REST APIs.
  • OSSYS_REST_API_PARAMETER: Contains parameters for both exposed and consumed APIs.

how we can get access to those tables ?

UserImage.jpg
Ben Wolrige
Solution

Hey everyone - thank you all for your replies. What I have learned from our OutSystems technical success manager is that the Base URL can be obtained via the OSSYS_REST_WEB_REFERENCE table, however the relative path of each web method underneath the Base URL is held in the OML file and hence cannot be found via a query.

I'm planning to interrogate our Integration logs in Service Center to see if I can derive the report I need from there.

Thanks again - I was pleasantly surprised by how much help so many of you offered :)

2022-12-30 07-28-09
Navneet Garg

Thanks for sharing very good information.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.