Accessing the XML API from Excel - authentication issue
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!Reply to Email triggers URL button
We have a URL button that uses API_editrecord to check mark the completed box on a record. We have an email notification that is triggered when a new record is added to the table. When we reply to the email notification, just within our company emails, I noticed that the reply is triggering the URL button. Does anyone know why this is happening? I've removed the rich text button from the email notification but still trying to figure out why replying to an email acts like clicking a button.
Connected Table Refresh
Hello all! I've been scouring the discussions and I just wanted to make sure they're all still accurate since most of them are years old at this point. It seems the Refresh Connected Data button still doesn't show for non Admin level accounts. What is the best way for my Project Manager to force a data refresh? Is it still the webhook api calls? Or has there been a better way developed?Clearing a merge field?
Wondering if anyone has ever cleared a merge field in a child table? Based upon reference below, we can UPSERT to a child table using a merge field as the surrogate key and the relationship is made (the related parent record id# values are filled in on the child record). Now I am trying to break the relationship so the related value is empty after upsert using the merge field. I have tried 0, "", nil, null and nothing happens. Any ideas are appreciated. Reference below: Link related data by importing into lookup fields Builders now have an easier way to import records with related data or link related data in integrations. Now, any lookup field marked unique on the parent table can be used to match instead of reference fields. RESTful Upsert Records—Users can UPSERT data to lookup fields marked unique in the data array in Record Upsert. https://helpv2.quickbase.com/hc/en-us/articles/31900230487700-Quickbase-November-2024-Release-Notes
Code Page for User to Search And Return a Report Visual
I have the following Code page. I have successful code where the user inputs data into 2 fields and QuickBase data is returned. However, where I am struggling is instead of data being returned, a report being returned ideally or I have a formula URL field that can be returned but needs to be an iframe. <!DOCTYPE html> <html> <head> <title>Quickbase Data Retriever</title> </head> <body> <label for="inputField">Enter Record ID or Search Term:</label><br> <input type="text" id="inputField"><br><br> <button id="retrieveButton">Retrieve Data</button> <div id="result"></div> <script> document.getElementById('retrieveButton').addEventListener('click', function() { const inputValue = document.getElementById('inputField').value; const appDbId = 'XXXXXXXXXXX'; // Replace with your Quickbase App DBID const tableDbId = 'XXXXXXXX'; // Replace with your Quickbase Table DBID const targetFieldId = '6'; // THIS IS THE formula URL field const queryFieldId = '37'; // Replace with the FID of the field to query against const userToken = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'; const apiUrl = `https://xxxxxxxxxxx.quickbase.com/db/${tableDbId}? a=API_DoQuery&query= {'${queryFieldId}'.EX.'${inputValue}'}&clist=${targetFieldId}&usertoken=${userToken}`; ****I have also tried report is qid 6 const apiURL='https://xxxxxxxxxxx.quickbase.com/db/${tableDbId}? qid=6&nv=1&v0= {'${queryFieldId}'.EX.'${inputValue}'} fetch(apiUrl) .then(response => response.text()) // Quickbase returns XML .then(xmlStr => { // Parse the XML string into a DOM object const parser = new DOMParser(); const xmlDoc = parser.parseFromString(xmlStr, "application/xml"); // Extract the value inside <possible_url> const statusNode = xmlDoc.querySelector("possible_url"); if (statusNode) { document.getElementById('result').textContent = statusNode.textContent; } else { document.getElementById('result').textContent = "No field found in response."; } }) .catch(error => { console.error('Error:', error); document.getElementById('result').textContent = 'An error occurred during the API call.'; }); When I call the formula URL field I get this so 1) is there a way instead of the URL being retrieved to have it in a iframe so that the report visual is shown? 2) Is there a way to instead filter the report for example: const apiURL='https://xxxxxxxxxxx.quickbase.com/db/${tableDbId}? qid=6&nv=1&v0= {'${queryFieldId}'.EX.'${inputValue}'} (this URL does work: https://xxxxxxxxxxxxxxxx.com/nav/app/xxxxxxxx/table/xxxxxxxx/action/q?qid=6&nv=1&v0=Minnie123 (Minnie123 would be the user's input to filter/query based of) and then have visual show in the html? The report does have a filter of "ask the user"
API not deleting attachments
Hi all, hoping someone may be able to assist. Am using a pipeline to remove attachments using the format of 'fid_14=&delfile_fid_14=1' The result of this is that whilst the attachment looks to be removed from the form, it still is actually being stored (app file manager shows the attachments still exist). Has anyone else encountered this or possibly have a solution ? Cheers in advance.
Save & Continue on New Record form
Hello all, I'm trying to create a Save & Continue button for an add form that will return to the record to continue editing. I found this thread ( Add Save and Keep Working Button on form for a new record | Qrew Discussions ) from a few years ago which is exactly what I want to do, but it doesn't seem to be working as stated anymore. var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=%%RID%%"; var text link = "<a href='" & $URL & "' data-replaceRid='true' style='font-size: 11pt;margin-left: 5px; margin-top: 0px; height: 33px; width: 160px; text-align:center;background-color:#13294d;color:white;background-image: linear-gradient(to bottom, #13294d 0%, #13294d 100%);' class='SaveBeforeNavigating Vibrant'>Save and Continue</a>"; $link When I click the created button I do see the "saving record" alert appear and then the green "Record saved!" but then directly after a window pops up "Leave site? Changes you made may not be saved." with options of Leave and Cancel. It doesn't matter what option I select, the next screen is the quickbase error page "Record Not Found" and to either go to the application's dashboard or go back to the previous page. Although the record is there when I go back in manually. I'm not sure what to add to the formula to get it back to the created record in edit form. Thanks, Kelly
