Vendor Matching In Master Database Using API
Using a webhook extension, you can do many extra activities that Rossum application does not do by default, for example validating the extracted vendor data against your database to match the correct vendor. We have published a sample vendor matching webhook that you can use on your Rossum account, set up and deploy all by yourself. Let's have a look at how to do it.
However we would first encourage you to check out our own data matching extension.
1. Set up a PostgreSQL database
To set up a PostgreSQL database, you may need to first download and install a management tool such as pgAdmin. Using this tool, create a database that your webhook will use to match the vendor data.
As the sample vendor matching webhook code uses a fuzzy matching trigram extension, you must call the extension before running the code. After you have created the database, run the following query once:
CREATE EXTENSION IF NOT EXISTS pg_trgm;
This will initialize the trigram functionality that is used in the webhook code.
2. Set up the microservice
Set up the microservice, install the required dependencies using command line:
$ sudo apt install python3-pip $ pip3 install -r requirements.txt
To allow the webhook to communicate with your PostgreSQL database, edit the access credentials stored in
Using .pgpass file
.pgpassfile shall be added manually to the same level where
webhook.pyis located. The file should contain credentials to your database in the following format:
There is no need to add the password to the database to
psygopg2will automatically look for the password in this file.
3. Fill the database with the vendor data
You can use the data stored in
supportive_data folder to fill your database for testing purposes. To import the testing vendor data to database, run:
$ python3 import_vendor_data.py supportive_data/vendor_data_de.csv
4. Add datapoints for matching to your schema
To see the matching happening, you must configure the schema appropriately. Update the schema for the webhook to work, using the example schema file
example_schema.json in the GitHub repository. You can change the schema using the Schema Editor in the Rossum UI.
5. Run the microservice
To run the webhook, proceed with steps 1-4 as described in this article.
Updated about 2 years ago