No More Posting New Topics!

If you have a question or an issue, please start a thread in our Github Discussions Forum.
This forum is closed for new threads/ topics.

Navigation

    Quasar Framework

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Populate Data Table from Google Sheet JSON feed

    Framework
    1
    1
    652
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • L
      Loren last edited by Loren

      How would we load the following JSON list into QTable?
      (Sample data contains 68 state park rows, plus a column header row.)

      List:
      https://spreadsheets.google.com/feeds/list/1cHlozDLZd1dhjL6aJnJyOWETIDmUuetGLk0ipSnXF3A/1/public/full?alt=json

      Cells:
      https://spreadsheets.google.com/feeds/cells/1cHlozDLZd1dhjL6aJnJyOWETIDmUuetGLk0ipSnXF3A/1/public/full?alt=json

      QTable:
      http://quasar-framework.org/components/datatable.html

      Note: Adding a function to the Google Sheet would further simplify the JSON.

      JSON Sample:
      https://script.google.com/macros/s/AKfycbzpOcYAX9CrBxGKyQ18Nupe9EzGU-Byl7_A-fY-TSd1zbcvAw/exec?callback=export

      Function to add to Google sheet to simplify JSON:
      https://stackoverflow.com/questions/36231379/use-google-sheets-as-json-feed-for-image-carousel

      1 Reply Last reply Reply Quote 0
      • First post
        Last post