Hello,
We've got a lot of needs for relatively straightforward integrations with Tessitura and other tools we use, and comparatively less time/resources spend on traditional software development. I've recently been eyeing a few low-code platforms (Mendix, Pega, Retool, PowerApps, etc.) and am curious if anyone has used this sort of thing with Tessitura.
I haven't gotten very far into this, but a lot of the quick demos I've watched start out with by either storing data within the platform itself or via a SQL connnection - I'm less sure how well something like this works if we're trying to keep all of the interactions via REST APIs. Many also advertise pre-built integrations with systems like Salesforce, but I don't think Tessitura is usually on their radar.
Would love to hear either general opinions about platforms or more specific stories about how this sort of thing has been used with Tessitura and/or to tie Tess to other systems.
-David DwigginsCIO, Historic New England
The Technical Consulting team at Tessitura has done some research and prototyping using Power Automate. Specifically building solutions to create and update data in Tessitura based on data from other applications. With Power Automate Tessitura is not available as a pre-built integration but you can create a connector that will allow you to integrate Tessitura using the Tessitura REST API. Utilizing the REST API is important to ensure that existing business requirements are being leveraged but this means that knowledge of the REST API is required to build a solution.
Jim Shea
VP, Technical Consulting
Hi,
I've had some success with Power Automate and creating a custom connector - we have an online form hosted by JotForm (Sign up for your Barclays Dance Pass - Sadler's Wells (sadlerswells.com) that triggers a Flow that creates accounts in Tessitura (if they don't have an account already) and adds a suitable constituency with expiry date.
The biggest challenge with creating a custom connector for Power Automate is that it will only accept Swagger files smaller than 1MB - and the Tessitura API schema is substantially larger. So, the only way I've found to get this working is to look at the Tessitura provided Swagger file and extract the paths/calls I need (plus the object definitions) and create a smaller Swagger file to import into the connector.
I keep meaning to write-up a walk-through, but haven't had the time yet!