All samples

CRUD APIs with Northwind database data

This sample contains a CRUD API for the 'Connect Copilot for Microsoft 365 to your external data in real-time with message extension plugins built with .NET and Visual Studio' learn module. The CRUD API simulates the behavior of a custom API protected with Microsoft Entra that returns product data. Using this preset you can complete exercises from the learn module without having to create a real custom API.

Garry Trinder

CRUD API for the “Connect Copilot for Microsoft 365 to your external data in real-time with message extension plugins built with .NET and Visual Studio” learn module

Summary

This sample contains a CRUD API for the Connect Copilot for Microsoft 365 to your external data in real-time with message extension plugins built with .NET and Visual Studio learn module. The CRUD API simulates the behavior of a custom API protected with Microsoft Entra that returns product data. Using this preset you can complete exercises from the learn module without having to create a real custom API.

Compatibility

Dev Proxy v2.1.0

Contributors

Version history

VersionDateComments
1.4February 4, 2026Updated to Dev Proxy v2.1.0
1.3January 18, 2026Moved config files to .devproxy folder
1.2January 5, 2026Updated to Dev Proxy v2.0.0
1.1June 27, 2025Updated to Dev Proxy v0.29.1
1.0July 23, 2024Initial release

Minimal path to awesome

Features

This preset contains the following endpoints and operations.

Authentication

The CRUD API is configured to use Microsoft Entra authentication.

[!IMPORTANT] All requests must send an OAuth 2.0 Bearer Token containing a scope named Product.Read.

Products

EndpointMethodDescriptionExample
productsGETGet all productsGET https://api.contoso.com/v1/products
products?name={name}GETGet products by nameGET https://api.contoso.com/v1/products?name=mark8
products?category={category}GETGet products by categoryGET https://api.contoso.com/v1/products?category=Consumer
products?name={name}&category={category}GETGet products by name and categoryGET https://api.contoso.com/v1/products?name=mark8&category=Consumer

Help

We do not support samples, but this community is always willing to help, and we want to improve these samples. We use GitHub to track issues, which makes it easy for community members to volunteer their time and help resolve issues.

You can try looking at issues related to this sample to see if anybody else is having the same issues.

If you encounter any issues using this sample, create a new issue.

Finally, if you have an idea for improvement, make a suggestion.

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.