Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I am trying to find out a way for getting data from Cisco Switches, but there is not much information for this.
I'm not sure whether I can create a data gateway for this.
Would you give me any solutions or suggestions?
I'm really appreciate your time and support.
@lionx , is available via rest API or some other method?
Hi @amitchandak
I have found that I can access data I need through Cisco Rest API. I have set up and tested the API. The API work well when I try query with Curl. The syntax as follows:
curl -X GET https://30.10.543.65/api/v2/nodes -H "Accept: application/json" -H "Authorization: Bearer eyJwMyYiJ9.eyJpclciI6I30.lkAwbsfmNzA"
Now I try to create a Power Query Connector using Json Web Token (JWT) for authentication. The Curl snippet for query data is:
curl -k -H "Authorization: Bearer SIGNED_JWT" "https://30.10.543.65/api/v2/nodes/?fields=/system-state/basic&page=0&size=20&sort=ip,asc..."
However, I don't know how to work with JWT Authentication in Power Query. would you help me with this please? My power query connector starts as follows:
// This file contains your Data Connector logic
section CiscoSwitch;
[DataSource.Kind="CiscoSwitch", Publish="CiscoSwitch.Publish"]
shared CiscoSwitch.Contents = Web.Contents("https://30.10.543.65", [ApiKeyName="api_key"])
// Data Source Kind description
CiscoSwitch = [
Authentication = [
// Key = [],
// UsernamePassword = [],
// Windows = [],
Implicit = []
],
Label = Extension.LoadString("DataSourceLabel")
];
@amitchandak Thank you for your response.
I have seen any available API even I have tried to get through de API Documents from Cisco Cisco API Documentation - Cisco DevNet
Are there any other solutions like directly connecting to database?
What I need to do is extracted the data "Resorce Utilization" & "System Health" from Cisco Switch
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |