Update database records
Not only can you add new records to a Flokzu database at any stage of your process, but you can also update those records if some of the information previously sent to the database has changed.
Example: You have an Office Supplies Request process where you buy supplies from different Suppliers. Some of the contact information from your Suppliers may vary, which is why it’s necessary to be able to update your database when needed.
The first option to update your database is doing so manually. However, this option is not viable when you have dozens or even hundreds of records in your database. For these cases, it is preferably to use our Update record web service.
Here are the steps you need to follow to use this web service:
1. Set up your database
First, you need to set up a Flokzu database to which new records will be sent and updated.
Remember to include all the columns you want to save information from your form to.
2. Build your form
Add the form fields that will be involved in your process. In this example, we have included a combo box (“Supplier”) that will be charged automatically from the previously created database, and a text field called “Enter New Supplier Name” to register new suppliers.
3. Set up add record and update record paths
In this example, we have forked different paths depending on whether the supplier is new or old. If the supplier is new, then we will call our Add record web service to add a new record. If the supplier is old, we will call the Update record web service to update the existing record.
4. Add field to save record ID
5. Set up the combo box to show old records
While editing the combo, you will need to select the database you want to get the information from and also the Value to display in the combo box.
6. Trigger old records from the combo box
While editing the combo box, navigate to the Trigger tab and select the Column headings (the name of the columns from your database) and the Fields to which the values will be populated.
Important: Don’t forget to select the “Id” as column heading to populate the ID record field that you have created in step No. 4.
7. Set up the Update record web service as follows:
URL: https://app.flokzu.com/flokzuopenapi/api/ApiKey/database/dbase/update
ApiKey: is the Api Key for your account.
dbase: is the exact name of your database, taking into account upper and lowercase letters, as well as specific characters.
Method: PUT.
Parameter name: Here you need to enter the exact names of your database columns. Don’t forget to include the “Id” column and get that information from the “ID record” field value.
Value: Here you need to include all the fields whose values will be taken into account in order to update the record columns.
Content-Type: application/json
X-Api-Key: your account’s Api Key.
X-Username: a valid email address from your account.
Example: You have an Office Supplies Request process where you buy supplies from different Suppliers. Some of the contact information from your Suppliers may vary, which is why it’s necessary to be able to update your database when needed.
The first option to update your database is doing so manually. However, this option is not viable when you have dozens or even hundreds of records in your database. For these cases, it is preferably to use our Update record web service.
Here are the steps you need to follow to use this web service:
1. Set up your database
First, you need to set up a Flokzu database to which new records will be sent and updated.
Remember to include all the columns you want to save information from your form to.
2. Build your form
Add the form fields that will be involved in your process. In this example, we have included a combo box (“Supplier”) that will be charged automatically from the previously created database, and a text field called “Enter New Supplier Name” to register new suppliers.
3. Set up add record and update record paths
In this example, we have forked different paths depending on whether the supplier is new or old. If the supplier is new, then we will call our Add record web service to add a new record. If the supplier is old, we will call the Update record web service to update the existing record.
4. Add field to save record ID
5. Set up the combo box to show old records
While editing the combo, you will need to select the database you want to get the information from and also the Value to display in the combo box.
6. Trigger old records from the combo box
While editing the combo box, navigate to the Trigger tab and select the Column headings (the name of the columns from your database) and the Fields to which the values will be populated.
Important: Don’t forget to select the “Id” as column heading to populate the ID record field that you have created in step No. 4.
7. Set up the Update record web service as follows:
URL: https://app.flokzu.com/flokzuopenapi/api/ApiKey/database/dbase/update
ApiKey: is the Api Key for your account.
dbase: is the exact name of your database, taking into account upper and lowercase letters, as well as specific characters.
Method: PUT.
Input:
Parameter name: Here you need to enter the exact names of your database columns. Don’t forget to include the “Id” column and get that information from the “ID record” field value.
Value: Here you need to include all the fields whose values will be taken into account in order to update the record columns.
Headers:
Content-Type: application/json
X-Api-Key: your account’s Api Key.
X-Username: a valid email address from your account.
Updated on: 20/02/2019
Thank you!