Graphics

 View Only

  • 1.  Using Google Sheets for real-time data

    Posted 04-08-2021 12:07
    #XPression
    Does Xpression Datalinq support Google Sheets to retrieve real-time data such as changing dollar amounts the someone enters?  I have only used RSS feeds and EXcel for data before but I need a different way to get data for a project.  I would appreciate anyone's advice on this.  Thank you.​

    ------------------------------
    Mark Stasiowski
    ------------------------------


  • 2.  RE: Using Google Sheets for real-time data

    Posted 04-08-2021 12:32
    There's no direct integration between Datalinq and google sheets but I will send you something you can try.

    ------------------------------
    Simon Redmile
    Ross Video
    ------------------------------

    Original Message


  • 3.  RE: Using Google Sheets for real-time data

    Posted 04-12-2021 14:59
      |   view attached
    I haven't tried this method recently - but it worked last time I tried it in summer 2020. See attached PDF.


    Attachment(s)

    pdf
    Using Google Sheets as an XML.pdf   467 KB 1 version
    Original Message


  • 4.  RE: Using Google Sheets for real-time data

    Posted 04-13-2021 11:21
    Garner and Simon -
    Thank you both for your help.  I will be working on this in the next few days and I appreciate all of the information you both have given me.  I will update you with my progress.

    ------------------------------
    Mark Stasiowski
    ------------------------------

    Original Message


  • 5.  RE: Using Google Sheets for real-time data

    Posted 04-26-2021 23:40
    Update:  Everything went well.  Thank you Garner and Simon for once again helping me with an XPression question.  Greatly appreciated!

    ------------------------------
    Mark Stasiowski
    ------------------------------

    Original Message


  • 6.  RE: Using Google Sheets for real-time data

    Posted 06-15-2022 20:48
    Hey Garner, I tried using this pdf guide to get a google sheet to populate in datalinq, but when I go to browse the data, the window is empty - no data. Has anything changed with this since you originally posted in 2021?

    ------------------------------
    Chris Simonson
    ------------------------------

    Original Message


  • 7.  RE: Using Google Sheets for real-time data

    Posted 06-16-2022 08:35
    I tried the pdf just now, out of curiosity, without success. Looks like the Sheets v3 API has been turned down. I'm commenting on this thread so that I get notified, in case someone knows how to use Google Sheets in 2022.

    ------------------------------
    Matt Finlayson
    Brigham Young University
    ------------------------------

    Original Message


  • 8.  RE: Using Google Sheets for real-time data

    Posted 06-16-2022 11:02
      |   view attached
    Google has been locking down a lot of access methods to their services recently. I'm not to surprised that this method no longer works. 

    The most foolproof way of using Google Sheets in Datalinq is to use the CDATA Google Sheets ODBC Driver. This driver logs into your google account and makes all your google sheets accessible to Datalinq via ODBC. Which means Google sheets will appear as a database source in Datalinq. This gives you a stable connection to Google Sheets and allows you to query Google Sheets as if they were a database. However this driver is not free. 

    Attached to this post is an appnote describing how to use the CDATA ODBC plugin with Google sheets and XPression Datalinq. 

    Main landing page for CDATA Google Sheets plugin: https://www.cdata.com/drivers/gsheets/
    Pricing: https://www.cdata.com/drivers/gsheets/order/odbc/#desktop 

    Attachment(s)

    dotx
    XPression DataLinq - Connecting with CData.dotx   5.05 MB 1 version
    Original Message