Create an API connection to Cisco Firewall Management Center for reporting

[smmoore34]

We are using Cisco Secure Firewall Management Center (FMC). I've created several CSV reports in that I'm able to use as datasets in PowerBi.

I want to automate this through an API so I do not have to generate the datasets in Cisco FMC. Does anyone have experience in using the CISCO FMC API?

[Anonymous]

Thank you for your prompt reply!!  @foodd 

Hi @smmoore34 

Here’s a concise action plan to help you achieve this:

1. Cisco FMC API: First, ensure you're familiar with the Cisco FMC API documentation to understand how to authenticate and fetch the datasets you need. Cisco FMC API documentation will provide details on endpoints to fetch reports or datasets. You can find more information on Cisco's official documentation or developer community forums.

2. Power Automate: Use Microsoft Power Automate to create a custom flow that connects to the Cisco FMC API, fetches the data, and then processes it as needed. You can use the HTTP action in Power Automate to make requests to the Cisco FMC API and handle the response. For guidance on triggering Power Automate flows and creating custom actions, refer to the Use custom actions to trigger Power Automate flows - Microsoft Fabric | Microsoft Learn

3. Power BI Data Refresh: Once you have your data in a suitable format (e.g., a CSV file or directly into a Power BI dataset), you can set up Power BI to refresh the dataset automatically. This can be configured within the Power BI service under the dataset settings.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[foodd · Accepted solution]

Start by familiarizing yourself with the REST API Quick Start Guide, and the API Explorer:

Firepower Management Center REST API Quick Start Guide, Version 7.0

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.