PowerBI access forbidden to Quick Base
Have other people been suddenly encountering the problem of "Access Forbidden" to Quick Base via PowerBI? The thread below implies it is a Quick Base problem and not the PBI connector. https://community.powerbi.com/t5/Service/Scheduled-refresh-not-working-Quick-base-Invalid-Credentials/m-p/1557637#M116258 ------------------------------ Sarah W ------------------------------8Views1like6CommentsQuickBase to Sharepoint Sync?
So I have a lot of Data I like to keep track of in QuickBase. I have several dozen customized reports I check daily and weekly. Some of this data contains percentage scores for coworkers, averages, etc.. I used to use Google Suite to track this information, but now we are using Microsoft Office 365 and Sharepoint. So I've been trying to find a way to export this data live from QuickBase into Excel in Office 365. Our spreadsheets where we track and update information is in Excel on SharePoint. I've tried using the desktop version of Office 365's Excel and go into the Data and Get Data From Web and other options. I've went into the refresh options to try to refresh hourly. It won't. Is it not possible to sync them so the information in QuickBase exports and updates the data in sharepoint? I can save the data in Quickbase as a Spreadsheet CSV file and load it into Excel just fine, but it won't refresh and update. ------------------------------ Joey Fletcher ------------------------------7Views0likes7CommentsAutomation to get data from a non-QuickBase API
Can anyone help me understand how to create an automation (or other automated tool) to get data from an external (non-QuickBase) API on a schedule? For example, I would like to get daily weather data from the Dark Sky API. In order to use that API, you have to set up a free account to get your own API key. Once you have that, you can get daily weather data from that API using a URL that contains the date, lat/long and your API key as shown below (in this example it is for Feb 17, 2020, 11:00 AM at Boeing Field in Seattle) : https://api.darksky.net/forecast/your API key goes here/47.528340,-122.301837,2020-02-17T11:00:00?exclude=hourly,currently,monthly,flags,alerts Once per day, I would like my automation to create a new row in the Weather table of my app; make an API call to DarkSky for the previous calendar date; and fill in the new row in my Weather table with the date and the summary, temperatureHigh, temperatureLow and precipIntensity fields from the API call. Any help appreciated! ------------------------------ Robin Gold ------------------------------6Views0likes4CommentsIs there any way to trigger python script based on any event in QuickBase?
Can you please let me know if there is any way to trigger python script based on any update in QuickBase (Master/Source Data)? Either through Quickbase action/automation/pipelines. ------------------------------ Sudhir B ------------------------------6Views0likes1CommentUpload csv to SFTP server from QuickBase
I know we can create connected tables to csv files stored in SFTP server. Is there a way to send or export QuickBase data in a table as csv file to an SFTP folder location? ------------------------------ Karthik Sekhar ------------------------------4Views0likes0CommentsBest way to automatically import data from emailed CSV to QuickBase
Previously, there was a technique to use something like Box Drive to automatically grab an email attachment and upload to Box, and then use a QuickBase Sync Table to then take that information and upload into QuickBase. Is this still the most efficient method for this purpose (auto importing data from an email attachment)? Or with the introduction of Pipelines, is there another method? ------------------------------ Michael Tamoush ------------------------------4Views0likes1CommentHow to download Work Order, Purchase Order, etc... as a PDF from QuickBase?
Hello all, I see others sending work orders, purchase orders, invoices, and/or etc. as a PDF from QuickBase. I have seen others do this at my company with our QuickBase system. Can someone please advise the process for saving an invoice, purchase order, or work order as a PDF? This would be extremely helpful as I have to send these purchase orders out to company's that do not have direct access to our system so "Send PO as email" or "Send WO as email" does not work in these cases. Even if I send the PO to myself it does not send it to me as an attachment, it copy/pastes the WO into an email. Any help would be great! ------------------------------ Bryce T. ------------------------------4Views0likes6CommentsLive sync of QuickBase calendar app to Outlook calendar?
Background: we have a QB app in which we store events. Those events are posted in a QB calendar report. It contains many pieces of info about each event in the event record – much more than we can do in Outlook. However, most everyone here still manages daily attendance to any event by Outlook. That is not up to change. Users in a large community can see this calendar and select events they need to attend. Currently, users who wish to attend the event can download the ICS file of the event on Quick Base and export that instance to Outlook. However that does not sync to later updates made in Quick Base. We need a live sync between the Quick Base events and Outlook events. If the event needs to change, we need the automatic live sync to change it/update it on the Outlook calendar of the attendees who signed up and send out a notification that this has occurred. Do we have any solutions, native or third party, that can do the second bullet above? This is the only functionality we currently lack. I actually think it would be nice if we could sync in the other direction, if events change in Outlook, they sync to the QB app too, but not sure that's as critical. Thanks! Carole Vandenberg ------------------------------ Carole Vandenberg Sr Global Presales Engineering Consultant - NCR ------------------------------3Views0likes5Comments