How can I search a hosted database?

[Elon Report]

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

[Marc]

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

[Elon Report]

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?  

[Miss_B]

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. 

[Marc]

There appears to be some confusion here. We do not have a table named vendors

[Elon Report]

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

[Marc]

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

[Elon Report]

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.  🙂

[Marc]

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?