Forum Discussion

WatsonJ's avatar
WatsonJ
New Member
6 years ago
Solved

Get Data from Cisco Spark WebEx Teams via REST API

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?

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    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.
  • SteveCampbell's avatar
    SteveCampbell
    Memorable Member

    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

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support

    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/1017833#M481066

     

    • WatsonJ's avatar
      WatsonJ
      New Member

      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!