Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: ea0921 on September 24, 2024, 04:12:48 pm

Title: Get history of API calls made to EA
Post by: ea0921 on September 24, 2024, 04:12:48 pm

Hello,

I have an application which communicates with EA using API to read/create/update entity in EA.

I want to know the history of API request which has been made in the API, along with their execution time from EA.

Is there any way to find out the following:
1. History of API request which has been made to EA
2. Execution time taken to process the given request

Thanks

Title: Re: Get history of API calls made to EA
Post by: Geert Bellekens on September 24, 2024, 04:21:54 pm

No, there isn't.

The best you can do is use some kind of monitoring tool for the database (for SQL Server that is SQL Server Profiling) to figure out which statements are being executed by EA on the database.

Almost all API requests will somehow use the database.

Geert

Title: Re: Get history of API calls made to EA
Post by: ea0921 on September 24, 2024, 04:40:16 pm

Is there any for sqllite3 or MS Access which we can do, because (.qea) and (.eapx) uses them internally.

Thanks

Title: Re: Get history of API calls made to EA
Post by: Geert Bellekens on September 24, 2024, 05:45:04 pm

From what I can see there are a few, but limited options.

https://stackoverflow.com/questions/10910157/enable-query-logging-in-sqlite-3 (https://stackoverflow.com/questions/10910157/enable-query-logging-in-sqlite-3)
https://stackoverflow.com/questions/2735412/is-it-possible-to-monitor-and-log-actual-queries-made-against-an-access-mdb (https://stackoverflow.com/questions/2735412/is-it-possible-to-monitor-and-log-actual-queries-made-against-an-access-mdb)

Geert

Title: Re: Get history of API calls made to EA
Post by: ea0921 on September 24, 2024, 06:06:58 pm

Thanks Geert, this will surely help me with my task