Page Comparison

Table of Contents

minLevel	1
maxLevel	7

System Profile

Division

System Full Name	Aeronautical Products API
System Full Name (FR)	Produits Aeronautique - Prestation de services
Business Administrator	John Deruchie / Sharon Domitsu
Business Owner	Marc Caouette
Director	Nicholas RobinsonAPI
Subject Matter Expert	Michelle Coelho	National Aircraft Certification
NTARS Code	C110
Source Code Location	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/APSD-PAPS_APINAPA-SNAPA_API
Client ID	https://portal.azure.com/#blade/Microsoft_AAD_RegisteredApps/ApplicationMenuBlade/Overview/appId/22897920-2e0b-4e97-80ca-fbc41c5805cb/isMSAApp/
KeyVault Secret	https://portal.azure.com/#@034gc.onmicrosoft.com/asset/Microsoft_Azure_KeyVault/Secret/https://civav-dev-keyvault.vault.azure.net/secrets/APSD-PAPS-PowerApps

Platform Type	API
Database Platform and Version	Oracle 11g
Development Language and Framework	C#, .NET Core 6
Operating System and Version
Additional Dependencies
Authentication	Azure AD

ENV	UNC	WWWFILES	URL	DB
DEV Internal			Dev	~~https://catcappsx.tc.gc.ca/Saf-Sec-Sur/2/NAPA-SNAPA_API/swagger/index.html~~
Acc	https://catcappsxwwwappstestext.tc.gc.ca/Saf-Sec-Sur/2/APSRNAPA-SNAPA_API-Test/swagger/index.html	`NNACEP.WORLD`	Dev External
	Prod	https://wwwappstestextwwwapps.tc.gc.ca/Saf-Sec-Sur/2/NDWL2NAPA-LWND2-API	`NNACEP.WORLD`		SNAPA_API/swagger/index.html	`NNPROD.WORLD`

...

Note: the dev server dev external need to be updated to .netcore6. At this moment, the old version (.netcore3.1) is running.

...

...

doesn’t have a certificate to work with https

Resource

Development

Production

Resource Group

App Registration

Key Vault

(kv-napa-snapa-api-clientsecret)

civav-prod-kv-apsd-paps

...

...

➕ points	➖ points
Integration with Azure (Azure AD and possibility with KeyVault)	VPN dependency
Using the last version for software development platform	Oracle connection dependency
	Not scalable because is inside IIS
	30% of the app's power is being used
	Availability not guaranteed 24/7

The redirect URL from the API needs to be registered on app registration
Image Added
The option Access tokens need to be activated
Image Added
In Exposed API, add a scope
Image Added
Give access to your client ID
Image Added
In API permissions, grant access to your scope
Image Added
This configuration will be used in your API
Image Added
To configure your endpoint, you can see from here
Image Added

Open the API in development (see the address up)
Click on Authorize
Image Added
Select the scope and click on Authorize again. The Microsoft login page will open and you need to enter your credentials as MSTeams.
Image Added
After that, you can try to execute an API

Clone the repository: https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/NAPA-SNAPA_API
Open Visual Studio Code
Configure the appsettings.json file according to your azure configuration
Image Added
Open a terminal and type:
Code Block
dotnet publish -c Release
For development, dotnet publish is enough.
Image Added
At the end of the process, you have a path to find your files
Image Added
Open the path and copy and paste the files in the server
Image Added