Nate Sheets Posted July 20, 2020 Posted July 20, 2020 Hi there! I am excited about the prospects of using the Database function in invisioncommunity. However, I would like to be able to have a more advanced form take the information. I use NinjaForms. I currently have Zapier, and there is a place to add MySql databases. I have been trying to get this to work with my database within invision, but it is not working. 1) Are the "databases" that we can add to pages and have users add/edit MySQL? 2) If so, where can I get the following information? I cannot find it anywhere in the Admin areas of through documentation. Host ("The IP address or hostname (db.example.com) of where your database instance resides. Note, localhost and 127.0.0.1 are not valid! Make sure it is accessible from these IPs: 54.86.9.50") i. I can't find any IP address references nor has using my site's address worked Port Couldn't find a single reference to this in documentation. Am I wrong??? Database I assume short name? (e.g. happypeople vs. Happy People Database) Username and Password They suggest making a user with very limited access but with database access, which i have done SSL Client Certificate (optional) and SSL Private Key (optional) Invision set me up with this--can I get the info from them somehow? Thank you so much for any advice or help you can give!
Joel R Posted July 20, 2020 Posted July 20, 2020 The Databases function is more like an Excel worksheet than a MySQL database, if that makes sense. It is entirely a surface / user-level database to input and display data, not anything that connects with a back-end MySQL. Nate Sheets 1
Nate Sheets Posted July 20, 2020 Author Posted July 20, 2020 Woe is me! Damn! Thank you for your response!
Nate Sheets Posted July 20, 2020 Author Posted July 20, 2020 @Mark, any chance that the Zapier integration you're working on will address this???
Daniel F Posted July 20, 2020 Posted July 20, 2020 Our zapier Integration will of course include support for databases, records , comments and reviews. BTW, you’re already able to use our REST endpoints in combination with Zapier Webhooks to run operations with records, comments and reviews. https://invisioncommunity.com/developers/rest-api Nate Sheets 1
Nate Sheets Posted July 20, 2020 Author Posted July 20, 2020 Glad to hear that! Thank you for the API info. So far that has been out of my skill abilities but I'll take a look!
bfarber Posted July 21, 2020 Posted July 21, 2020 To be clear, "databases" within Pages are actually stored in a MySQL database table, however there's no way you would be able to remotely connect to our database network in order to directly reinsert data (since it sounds like you're using Community In The Cloud) so the option you were looking at in Zapier wouldn't work with our environment. We will offer direct Zapier integration with our upcoming 4.5 release however.
Recommended Posts