Forum Discussion
Connect to Quickbase
Hi alexbe,
Please refer to below links about invoke api through web connector with xml contents.
Understanding the API call reference
POST http(s) request with xml content in Power Query
Web Services And POST Requests In Power Query
Regards,
Xiaoxin Sheng
Hi Alex,
Do you have access to Quick Base University? I just presented this at our annual conference, and the method for doing this is in there:
Quick Base and PowerBI - Better Together - (you can skip to around minute 19 to get right to it)
Let me know if you need additional information.
Jacob
I am trying to connect within powerBi.. I create a blank query and paste this in
= Csv.Document(Web.Contents("https://ga.quickbase.com
/db/bitfp9mn2?a=API_GenResultsTable&options=csv&qid=1",
[Content=Text.ToBinary("usertoken=b36sn5_ump_bk5kydsdgrx3d3bejw5m8cxyzxyz")]))
And I get
DataFormat.Error: Invalid URI: The hostname could not be parsed.
Details:
https://ga.quickbase.com
/db/bitfp9mn2?a=API_GenResultsTable&options=csv&qid=1
Any idea ?
The newest version of PowerBI (Feb '19) now includes a native connector to Quick Base. You may need to clear your current connection via the steps here:
Hope this helps!