Importing Smartsheet data into Pyramid

Hi Folks,

I'm leading a project, and the team wants to import Smartsheet data into Pyramid. We tried using the token, the sheet ID and the URL to do this, however, this method involves several steps which makes the whole process unintuitive but complicated. The other method we want to also try is to bring the data into Pyramid through SQL. My question, has anyone worked with Smartsheet data in Pyramid? How did you bring the data in? Simply put, is there a seamless, uncomplicated way to do this? Any thoughts? Thanks


1 reply

    • Senior Director of Product
    • Ian_Macdonald
    • 4 mths ago
    • Reported - view

    Hi Daniel,

    It seems CData provide a JDBC driver for SmartSheets. Check this out:


    Pyramid supports CData JDBC drivers as a custom connector. I believe CData offer a 30 day trial licence so you can try this for yourself.

    Hope that helps.


Content aside

  • Status Answered
  • 4 mths agoLast active
  • 1Replies
  • 38Views
  • 2 Following