Your webhook currently uses hardcoded data in the
In this step of the tutorial,
you will create a
database, populate it with covered destinations,
and update your function to query the database.
It is important that your Dialogflow agent and the database are both in the same project. This is the easiest way for your function to have secure access to your database. Also, you must enable the Spanner API.
Before creating the database, select your project from the Google Cloud console.
Enable the Spanner API for the project.
Create a Spanner instance
When you first use Spanner, you must create an instance, which is an allocation of resources that are used by Spanner databases in that instance.
In the Google Cloud console, go to the Cloud Spanner Instances page.
Click Create instance.
For the instance name, enter Tutorial Instance.
The instance ID is automatically entered based on the instance name.
In Choose your configuration, retain the default option Regional and select the same region location that you chose when creating the function.
In Allocate compute capacity, enter 100 processing units. This provides a minimal capacity for the tutorial.
Click Create. The Google Cloud console displays the Overview page for the instance you created.
Create a Spanner database
Now that you have an instance, you need to create a database. To create a database:
- In the instance Overview page, click Create database.
- For the database name, enter tutorial-database.
- Select the Google Standard SQL database dialect.
- Click Create. The Google Cloud console displays the Overview page for the database you created.
Create a table for your database
Now that you have a database, you need to create a table for the database. To create a table:
- In the Tables section of the database Overview page, click Create table.
In the Write DDL statements page, enter:
CREATE TABLE Destinations ( Destination STRING(1024), Covered BOOL, ) PRIMARY KEY(Destination);
Click Submit. The Google Cloud console returns to the database Overview page and shows that Schema updates are underway. Wait until the update is complete.
Insert data into your table
Now that your database has a table, you need to add data to the table. To add data:
- In the list of tables on the database Overview page, click the Destinations table. The Google Cloud console displays the Destinations table's Schema page.
- In the left navigation menu, click Data to display the Destinations table's Data page.
Click Insert. The Google Cloud console displays the Destinations table's Query page with a new query tab that contains
SELECTstatements. Overwrite those statements with the following:
INSERT INTO Destinations (Destination, Covered) VALUES('anguilla', TRUE), ('canada', TRUE), ('china', TRUE), ('italy', TRUE), ('mexico', TRUE), ('spain', FALSE);
In the left navigation menu, click Data again to display the Destination table's data. Confirm that the table contains the desired data.
Update the Cloud Function to query the database
cruisePlanCoverage function in the webhook code
checks whether specific environment variables are set
with information for connecting to the database.
If these environment variables are not set,
the function uses a hardcoded list of destinations.
Now that you have a database set up, update your Cloud Function to set required environment variables:
Open the Cloud Functions overview page.
Click the tutorial-telecommunications-webhook function to go to its details page.
Open the Runtime, build and connections settings section.
Select the Runtime tab.
Add the following variables in the Runtime environment variables section:
PROJECT_ID: your project ID
SPANNER_INSTANCE_ID: your Spanner instance ID (probably
SPANNER_DATABASE_ID: your spanner database ID (probably
Wait until the status indicator shows that the function has successfully deployed.
Test your agent
Your agent is now ready to try. Click the Test Agent button from the Dialogflow console to open the simulator. Attempt to have the following conversation with the agent:
|1||Hello||Hi! I'm the virtual telecommunications agent. I can help you resolve billing and plan questions, troubleshoot, and add travel and cruise plans. How can I assist you today?|
|2||I want to add a cruise plan||Let me take a look for you. What is your phone number with us?|
|3||123-123-1234||How many days is your cruise?|
|4||7||Option 1 includes talk and text. It costs $[XX]/day. More info here [URL]. Option 2 includes talk, text and data. It costs $[XX]/day. More info here [URL]. Which cruise plan would you like to add?|
|5||Option 1||Got it. I've added that plan to your account. While on your cruise, you may also need coverage on land. What port will you be stopping at?|
|6||Italy||And, how many days are you spending there?|
|7||3||Great news! Italy has free coverage on land. You're all set. Is there anything else I can help you with today?|
If you examine the code, Italy is not in the hardcoded list of covered destinations. This means that your webhook has successfully connected to the database, which does include Italy.
The webhook code includes logging statements. If you are having issues, try viewing the logs for your Cloud Function.
If your function is not connecting to the database,
and you see a permission error in the logs,
you may need to fix the role for the default service account
used by your function.
This service account is of the form
You can fix this in one of the following ways:
If the default service account is shown on the IAM main page, change permissions for the service account. The Editor role will work, but you may want a more granular role in a production scenario.
If the a default service account is not shown on the IAM main page, grant the required role by adding the service account as a new principal.
Alternatively, you can use a service account that you create.
For more information about the steps above, see:
- Using Cloud Spanner with Cloud Functions
- Create and query a database by using the Google Cloud console
- Google Standard SQL data definition language
- Google Standard SQL data manipulation language