Integration API Cisco with Power BI

[alissonbucchi]

Hello Community!

I would like some information on to how connect CCW API Cisco to Power BI databases. I know something about M and DX languages that could be used to integrate systems, but I have some trouble accessing Cisco API. 

Thanks in advance!

Alisson T. Bucchi

Alliances Analyst & API Dev at Logicalis Portugal. 

[bigevilbeard · Accepted solution]

Might be 100% wrong here. Connecting the Cisco Collaboration Cloud APIs (CCW APIs) to Power BI databases isn't possible due to their different functionalities. But i think you can achieve data integration. by using an API gateway to act as an intermediary between CCW APIs and Power BI.

You could do this with a custom API using tools such as AWS Lambda. First you would call the CCW API to fetch data, then transform the data as needed using M ( other languages) Finally, push the data to a Power BI dataset using the Power BI REST APIs.

Hope this helps.

[alissonbucchi]

Hello Stuart!

Thanks for you previous clarification about this subject, I would like to change informations to obtain more explanations because here in Logicalis Portugal we are trying to connect this CCW APIs to our internal DB. Is it possible talk more about this in a meeting or using another way?

Thanks in advance!

Alisson T. Bucchi

Alliances Analyst & API Dev at Logicalis Portugal. 

(+351) 913353366

[bigevilbeard]

This isn't something i can support i am sorry. I am just humble community member within this community. 

[alissonbucchi]

Hello Stuart, 

Thanks for your previous response, we will think in another solution after your clarification! 

I would like some information about how to use the Hello API OpenAPI 3.0 from Cisco? Is it possible write a snippet into VSCode and obtain the response or need another programm to extract the informations?

Best regards, 

Alisson T. Bucchi 

Alliances Analyst & API Dev at Logicalis Portugal. 

(+351) 913353366

[bigevilbeard · Accepted solution]

This isnt something i have used tbh -  You could install the OpenAPI Extension for VSCode, the extension provides features for working with OpenAPI/Swagger files etc... including generating client code and sending requests to APIs. Install it from the VSCode Extensions Marketplace, here, https://marketplace.visualstudio.com/items?itemName=AndrewButson.vscode-openapi-viewer

Then you can import the OpenAPI Specification file (yaml or json) for the Cisco Hello API and import it into your VSCode workspace. You can typically find these specifications on the API documentation website/developer portal.

Hope this helps.