Hi all, I would like to be able to connect to an filemaker database and run any 'queries' on the database and retreive results in an ... array.
Is this possible? And how?
Hi all, I would like to be able to connect to an filemaker database and run any 'queries' on the database and retreive results in an ... array.
Is this possible? And how?
For a certain defined set of queries, the common approach nowadays is to add web service abilities to the database and then access it via a RESTful API.
For a certain defined set of queries, the common approach nowadays is to add web service abilities to the database and then access it via a RESTful API.
Being able to run any query you could think of versus only a select few requires very different approaches. The former would probably need to be implemented via a direct connection to the database. This can be tricky. The latter can be implemented via SOAP or REST calls and are the much more common approach nowadays. Since you want to do the latter, let's move on to that.
Actually I would just want to do some select queries.
Then I think you should look into setting up your Filemaker database as a web service that you can make REST calls against. Since I don't know much about Filemaker, I'll have to leave it to others as to how this might be done. Although I did find this in a quick Google search on "filemaker rest api": RESTfm