Forum Discussion

DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago

Access Record data from an html page via API call

I have had a hard time getting accustomed to working with API calls from outside of Quick Base and since I have limited experience with XML. Finally after struggling quite a bit I have come up with a ...
APIs and custom code
Security and SSO
Tips and tricks
DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago
Just figured I would add code for how to pull values into the code page from a URL button within QB. Just replace "rid" with the name of your parameter name.

<script>
function getUrlParameters() {
    var params = {};
    var parts = window.location.href.replace(/[?&]+([^=&]+)=([^&]*)/gi, function(m,key,value) {
        params[key] = value;
    });
    return params;   }
function doCode(){
var recordID=getUrlParameters() ["rid"]; 
alert(recordID); 
 }
</script>
DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago
This is one way to make further API calls after processing data on code page -->

var request = new XMLHttpRequest();
request.open('POST', 'https://yourdomain.quickbase.com/db/yourtable?a=API_yourAPIcall&apptoken=yourapptoken', true);
request.onload = function () {
    alert("record added");