Skip to main content
Question

Accessing the XML API from Excel - authentication issue

  • Apr 1, 2026 5:56 PM UTC
  • 1 reply
  • 77 views

Forum|alt.badge.img

I am trying to access the XML API from Excel. If I embed my User Token in the request URL, things work fine: I go to Data -> From Web, paste in my query URL, and after a little drilling down, I got my data.

HOWEVER: The spreadsheet that calls the API is to be passed around, and word on the street is that leaving my User Token in a shared document is Not A Great Idea(tm).

If I use the query URL without my User Token, I get an authentication window of sorts from Excel, but if I select the Basic tab and enter my credentials, I get a message "We couldn't authenticate with the credentials provided. Please try again".

My goal is to have every user enter their own QuickBase credentials when refreshing the data in the spreadsheet. I can't use the QuickBase add-on for Excel, and I can't create a shared account to access the data.

Is there a good way to do this?

 

Thanks!

 

1 reply

Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 16, 2026 4:13 PM UTC

Excel's Basic auth dialog is looking for HTTP Basic username/password. The Quickbase XML API does not authenticate that way, so those credentials fail even when they are valid Quickbase logins.

Supported API auth is a user token (or a ticket from API_Authenticate). On a URL call that looks like:

https://yourrealm.quickbase.com/db/DBID?a=API_DoQuery&query=...&usertoken=USER_TOKEN

For a workbook that gets passed around, don't leave a user token in the shared URL or sheet. A few patterns that work:

1. Each person who refreshes creates their own user token (My preferences → Manage user tokens), assigns it only to the apps they need, and pastes it into their own local copy of the query or Power Query parameter, never into the shared file.

2. Use the JSON API with an Authorization header (QB-USER-TOKEN …) in Power Query, so the token lives in that user's Excel credentials instead of a URL you email around.

There's no documented way for Excel's built-in Basic prompt to turn Quickbase passwords into API access for a shared From Web query.

https://help.quickbase.com/docs/create-and-use-user-tokens

https://help.quickbase.com/docs/authentication-and-secure-access

https://help.quickbase.com/docs/api-doquery

https://developer.quickbase.com/auth

https://developer.quickbase.com/operation/runQuery