Power Platform Community Forum Thread Details

my use case is to fill the tprm excel automatically by using the data inside the documents providing by the user . I want to create an agent SDK not a declarative one for this usecase ,I already developed a python SDK for this. But my current query is how can i integrate this SDK to the Copilot Studio

Categories:

Bot extensibility

Hello MS-07010443-0,

To connect your Python SDK with Copilot Studio, you'll need to make it accessible as an API that Copilot Studio can interact with.

Here's how you can integrate your Python SDK with Copilot Studio:

Convert your Python SDK into a REST API:
- Use frameworks like Flask, FastAPI, or Azure Functions.
- Set up an endpoint (e.g., /process-tprm) to accept documents and return an Excel file URL.
Deploy your API:
- Host it on Azure Functions (recommended) or another suitable service.
- Obtain the API endpoint URL.
Prepare an OpenAPI specification for your API.
Connect your API to Copilot Studio:
- Navigate to Actions → Add action → Custom connector.
- Import your OpenAPI specification.
- Set up authentication as needed.
Utilize the API within an Agent:
- Create a topic in Copilot Studio.
- Add an Action node to trigger your Python API.
- Manage document input, call the API, and return the resulting Excel file.