API Referencing Doubts

I am a new intern, and my first project is to create a program that accesses data of loop diagrams and converts it into an excel file. As I am a beginner to EB I am encountering several challenges. In this post, I’ll outline the critical questions I needed answers to before starting development, along with some insights on working with EB’s API.


1. Understanding API Access & Documentation
How do I confirm that my EB installation has API access enabled?
Where can I access the API on the EB Software?
Where can I find official documentation detailing all API functions?
Are there DLL files required to integrate EB into my .NET project, and where do I find them?
Does EB expose its API via .NET assemblies or COM components?

2. Database & Data Extraction Challenges
What database does the EB API interact with (SQL Server, internal EB DB, or another)?
What is the database structure of any diagram on the EB?
What are the key tables I need to query to extract loop diagrams and connection metadata?
Should I interact with EB via direct SQL queries, or strictly use the API?
Are there any restrictions or security limitations when pulling data from EB’s database?

3.Are there any coding standards to follow when working with EB API?