Forum Discussion

lawsonbe's avatar
lawsonbe
Helper I
7 years ago

MasteryConnect API Connection "A web API key can only be specified with a web API key is provided."

I have been trying for several days to connect PowerBI to MasteryConnect through their API. MasteryConnect is an educational services provider that hosts student testing information. They allow teach...
Need Help
lawsonbe's avatar
lawsonbe
Helper I
7 years ago

I tried that method and it did not work for me. 

  • lawsonbe's avatar
    lawsonbe
    Helper I
    7 years ago

    I am trying a new tactic on this issue. I found the following OAuth 1.0 script and am trying to use it to create the GET to the MasteryConnect API. PowerBI does not like the https part of the statement and calls it out as a syntax error in the advanced querry editor. Obviously I am subbing out my own information for the key, code, signature, etc..

     

    let

    Source = Web.Contents("https://api.masteryconnect.com/api/students.json?page=1″, [Headers=[#”Authorization”=”OAuth oauth_consumer_key=””YOURKEY””, oauth_nonce=””YOURCODE””, oauth_signature=””YOURSIGNATURE””, oauth_signature_method=””HMAC-SHA1″”, oauth_timestamp=””TIMESTAMP””, oauth_token=””YOURTOKEN””, oauth_version=””1.0″””]]
    )
    in
    Source

Related content