Get Data from Cisco Spark WebEx Teams via REST API

[WatsonJ]

Hello!!!  I am trying to connect to the Cisco Spark instance for WebEx Teams via their REST API. 

I put the URL and the Authorization header parameter (access token) into the Web connector:

After I select the OK button, I get the following error:

Has anyone seen this error before or been succesful in connecting to the Cisc Spark Webex instance?

[v-eachen-msft · Accepted solution]

Hi @WatsonJ ,

You could configure the connection manually with m query.

let
Source = Json.Document(Web.Contents("insert the URL here you used to in the regular way, and add ", [Headers=[Authorization="Basic insert your token here="]])),
issues = Source[issues],
in
Source 

Here is a similar case for your reference:

https://community.powerbi.com/t5/Desktop/REST-API-web-data-source-Authentication-Header-is-gone/m-p/...

[WatsonJ]

I used your query, but the only thing I changed was the word "basic" to "bearer", which apparently Cisco Spark needs.  As soon as I figured that out, it worked!  Hopefully if anyone searches for the meta tags on this question, they can find this solution useful.  Thanks again!

[SteveCampbell]

What's the authorization flow? From the site it looks there's a couple of ways - does the token have an expiry? It looks like they do, you'll need to generate a valid token first

[Greg_Deckler]

Pretty sure that Anonymous is not the way to go here. Just going to it in a web browser returns:

{"message":"The request requires a valid access token set in the Authorization request header.","errors":[{"description":"The request requires a valid access token set in the Authorization request header."}],"trackingId":"ROUTER_5E9783E2-D7C3-01BB-40F0-18D0D9BE40F0"}

So, I'm guessing Web API and you probably need to generate an access token in same manner.