When I thought I had my notation correct, it would only point to one video, even if I changed the video name...
the API to get my structured format is:
https://<realm>.quickbase.com/db/<dbid>?a=API_doQuery&query={'3'.EX.'3'}&fmt=structured.....
My main code to get the File's URL is as follows (part of a button click even):
$("a.Launch").on('click', function(event) {
var rid = this.dataset.rid;
var parser = document.createElement('a');
parser.href = window.location.href;
var realmHost = parser.hostname;
var url = "
https://"+parser.hostname+parser.pathname+"?a=API_doQuery&query={'3'.EX.'"+rid+&q...;
var Request = new XMLHttpRequest();
Request.open("GET",url,true);
Request.onload = function(){
console.log(Request.responseXML);
var file = (Request.responseXML.documentElement.getElementsByTagName("url"))[0].innerHTML;
I know that the XMLHhttpRequest is older notation... but it's functional.
After this I take the URL and place into a html string to add to the body and continue with the process