Has anyone done an integration of any sort with Airtable? Our Artistic team is looking to use this for literary management and would like to have some of the information feed into Tessitura.
Thanks in advance for any insight!
Coincidentally enough, I've had this on my mind recently. We are currently planning a summer season which will have hybrid performances (both in-person and streaming audiences), and are projecting that we might use Airtable for some front-of-house needs since it supports real-time cloud syncing and has a tablet-native user interface. I've worked with the Airtable API in the past using their Node.js client library and found it to be fairly accessible, but that was a few years ago and I know the Airtable platform has grown considerably in the meantime. Likely will be digging deeper in the near future...
Interesting. I'm kinda flying blind here since I've never touched Airtable before. I will likely be picking your brain in the near future once the team has more to share with me other than "oh yeah, they said it can integrate with Tessitura." Is it accessible enough for a RAMP user?
I'm not aware of an existing Tessitura-specific integration, so my expectation is for this to be within the realm of custom development. That said, we are getting to the point where custom integrations with Tessitura are possible to host easily on serverless infrastructure -- this is primarily due to the fact that RAMP is changing their API access policies to not rely on an IP whitelist. This means that one could use a service like Pipedream (which is extremely affordable) and a few lines of JavaScript to create a custom integration between Tessitura and practically anything else.
Nick Reilingh,
Over the past few years, I've done a bit of work with various rest APIs for data management.
When I saw the post from Madeline Dummerth (Past Member) I wondered how hard this might be to work with airtable.
Last night when I was poking at this I discovered this iPython / Jupyter Notebook
https://github.com/gtalarico/airtable-python-wrapper/blob/master/Airtable.ipynb
With this notebook, I was able to connect to AirTable in about an hour or so and was able to pull Airtable data. So access to that data seems realistic. Hosting a process and moving data into Tessitura is the next question.
Nick Reilingh pipedream looks really interesting. It also appears that they may support Python.
Since I finally started to grok Pipedream it's become one of my absolute favorite new tools. I know Python support is on their roadmap, but I believe it's still in alpha at the moment.