Skip to main content
Question

Uploading HTML to QuickBase with REST API

  • January 8, 2021
  • 0 replies
  • 100 views
Forum|alt.badge.img+1
Hi guys,

I am producing some Plotly charts and reports in Python by pulling raw data from QuickBase with the REST API. I would like to return the output (the reports and charts) to QuickBase so they can be displayed in pages. I can produce the output in HTML format in Python which I know can be displayed in a code page on QuickBase but I really don't have an idea on how to make the Python script update the HTML code within the page when a new run of the report is created. Manually pasting the HTML code everytime in the page is not really an option as I have a number of charts and reports with high update frequency. 

If you have any ideas, please share. It doesn't have to be a direct update to the page, if that needs to go through a QB table field and then the code page to somehow read the content of the field, that's also fine.

As a last resort, I can export the reports/charts as images and somehow get them onto QuickBase, which I am not sure how to do best either. However, this approach will make the charts static, without ability to use filters and drilldowns. 

Any help will be greatly appreciated!

Regards,

Yordan

------------------------------
Yordan Petrov
------------------------------
This topic has been closed for replies.

  • NathanHawe
  • Registered
  • January 8, 2021
There's an older XML API endpoint that can add/update pages https://help.quickbase.com/api-guide/add_replace_dbpage.html.  I think this would work well in your situation, you'd just have to change the way you make requests to this specific endpoint to match the XML requirements.  You can still use user tokens for most of these older XML APIs by passing it in a "usertoken" tag so you shouldn't need to authenticate differently.

Some people have used this to make deployment tools for code pages in the past.  I haven't used this personally, but looking at the code might be helpful https://github.com/cullenjett/quickbase-cli.

------------------------------
Nathan Hawe
------------------------------
    Forum|alt.badge.img+15
    • DonLarson
    • Registered
    • January 9, 2021
    Yordan,

    I am not familiar with Plotly but spent a couple minutes on their Intro Page
    https://dash.plotly.com/introduction

    It explicitly says that Dash app are rendered in the browser and can then be shared through URLs.   Have you tried to put one of these into the dashboard of Quick Base?  I have a customer that uses the commodity feeds from CNBC and they are imbedded into Quick Base with the Web Page widget feature.



    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
      Terms & ConditionsAccessibility statement