Page Comparison

Table of Contents

minLevel	1
maxLevel	7

System Profile

Business Owner

System Full Name	Aeronautical Products API
System Full Name (FR)	Produits Aeronautique - Prestation de services API	Business Administrator
Director	Subject Matter Expert	Michelle Coelho	Division	NTARS Code
Source Code Location	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/NAPA-SNAPA_API
Client ID	https:/APSD-PAPS_API/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

Technology Assessment

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

Environment Access Information

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.

API Architecture

...

doesn’t have a certificate to work with https

Azure Resources

Resource

Development

Production

Resource Group

TC-DevTest-CivAv-RGP

App Registration

CivAv-Dev-NAPA-SNAPA

CivAv-Prod-NAPA-SNAPA

Key Vault

civav-dev-kv-napa-snapa

(kv-napa-snapa-api-clientsecret)

civav-prod-kv-apsd-paps

API Architecture

...

API Infrastructure

...

➕ 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 goal

This same API, one time in the cloud, all negative points will be removed automatically.

...

Azure configuration

...

App registration

...

Civil Aviation - Aviation civile

...

Database Platform and Version

...

Oracle 11g

...

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

API Access

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

How to Publish NAPA-SNAPA 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