CODEWITHSUNDEEP
smartsheet-apipowerquery
Ivan Oboth
Ivan Oboth

Reputation: 41

Connect Excel to Smartsheet via Power Query

I have been trying to pull data from one of my Sheets in Smartsheet using Power Query without no luck. I generated an API token from Smartsheet that I used in the Power Query Wizard but still failed.

Upvotes: 0

Views: 2491

Answers (1)

Ivan Oboth
Ivan Oboth

Reputation: 41

  1. In power query editor I basically hardcoded the authorization header + API token:

= Web.Contents(
    "https://api.smartsheet.com/1.1/sheet/4693183612381060", 
    [
        Headers = [
            #"Authorization" = "Bearer YOUR_API_TOKEN"
        ]
    ]
)
  1. Then when prompted to enter credentials on the next screen, I chose Anonymous instead of Web API, as someone suggested in the comments here

http://www.powerpivotblog.nl/getting-data-into-power-query-with-the-twitter-search-api-how-to-hack-pq-to-use-oauth/

Upvotes: 2

Related Questions