Elon Report Posted September 14, 2023 Share Posted September 14, 2023 (edited) I read that external database access is disabled for security. I cannot find any documentation on how to search with rest api. I have a table (vendor) that has three columns - the id, date and tax - all are integers. I have the two integers (date, tax) I want to search for. How can I search this table and get back an array of ids that match the query? Edited September 14, 2023 by MartinLawrence Link to comment Share on other sites More sharing options...
Marc Stridgen Posted September 14, 2023 Share Posted September 14, 2023 You are indeed correct in that there is no access to the database on our cloud environment. You would need to create a plugin that returns that information if you need it. When you refer to a table 'vendor', is this something added from a 3rd party application somewhere? If so, you would be best to contact the author of that application Link to comment Share on other sites More sharing options...
Elon Report Posted September 14, 2023 Author Share Posted September 14, 2023 2 hours ago, Marc Stridgen said: When you refer to a table 'vendor', is this something added from a 3rd party application somewhere? If so, you would be best to contact the author of that application No, "vendor" is just my name for one of your custom tables. Date and GST are integer columns. It is something as simple as SELECT ID FROM VENDORS WHERE DATE=4 AND GST=2 Do I need to create a plug in for something so simple? Is there a way to use /core/search to search custom tables like it does forums? Link to comment Share on other sites More sharing options...
Solution Miss_B Posted September 14, 2023 Solution Share Posted September 14, 2023 3 minutes ago, MartinLawrence said: Do I need to create a plug in for something so simple? Is there a way to use /core/search to search custom tables like it does forums? You will need indeed a custom app for that. It's fairly easy to do. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted September 14, 2023 Share Posted September 14, 2023 There appears to be some confusion here. We do not have a table named vendors Link to comment Share on other sites More sharing options...
Elon Report Posted September 14, 2023 Author Share Posted September 14, 2023 (edited) 14 minutes ago, Miss_B said: You will need indeed a custom app for that. It's fairly easy to do. It's not just the code, it's learning an infrastructure I fear may change in the near future. I don't want to have to write an application every time I want to search a database... I'm using zapier and it takes care of almost everything I need. Edited September 14, 2023 by MartinLawrence Link to comment Share on other sites More sharing options...
Marc Stridgen Posted September 14, 2023 Share Posted September 14, 2023 If you are using something custom, then custom is indeed what you would need to write. There is no access to the database on the cloud platform. As mentioned, the table you are talking about there is not our table, and we host only our own tables here. So its not actually clear what you are trying to achieve Link to comment Share on other sites More sharing options...
Elon Report Posted September 15, 2023 Author Share Posted September 15, 2023 21 hours ago, Marc Stridgen said: As mentioned, the table you are talking about there is not our table, and we host only our own tables here. So its not actually clear what you are trying to achieve As mentioned, "vendor" was just my name for one of your custom tables. 🙂 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted September 15, 2023 Share Posted September 15, 2023 39 minutes ago, MartinLawrence said: As mentioned, "vendor" was just my name for one of your custom tables. 🙂 We dont have a table named vendor. Are you perhaps referring to a database you have created? Link to comment Share on other sites More sharing options...
Recommended Posts