Skip to content

kulikov-dev/filemaker

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Connector to the relational database FileMaker for PHP 5.5 >=

The connector allows to communicate with the FileMaker tables through the REST API, realizing operations of obtaining, finding and updating data. Support scripts.

Before work you need to initialize a connector with your credentials:

    private static function initialize_fileMaker()
    {
        self::$file_maker_connector = new filemaker_connector();
        self::$file_maker_connector->set_credentials('login', 'pass');
        self::$file_maker_connector->set_entry_point('https://a111111.fmphost.com/fmi/data/v1/databases/test');
        self::$file_maker_connector->open_connection();

        if (self::$file_maker_connector == null || !self::$file_maker_connector->is_opened()) {
            die('Initialize FileMakerConnector before work with Test database.');
        }
    }

After that the connector is ready to work. Below are samples of obtaining data with a FileMaker script:

 $script = '&script=FindActiveForModifiedOnly&script.param=' . date("m-d-Y H:i:s", time());
 $indexer = self::$file_maker_connector->get_table_content('Inventory', $script);

And updating a record in the FileMaker database:

  $new_record = [];
  $new_record["pk"] = strval($employee_info["WOVEN_ID"]);

  $new_record["first"] = $employee_info["FNAME"];
  $new_record["last"] = $employee_info["LNAME"];
  $query_info = [
            "query" => [[
                "Employee" => '=' . $new_record["pk"]
            ]],
            "limit" => "1",
            "script" => "Employee DataAPIUpdate",
            "script.param" => json_encode($new_record)
        ];

  self::$file_maker_connector->update_record("Employees", $query_info);