Dialogflow CX: How To Integrate Data From BigQuery Into Agent Conversation?

[mariareccoppa]

I have a list of emails as structured data in BigQuery. I want the user to be able to type in a name and then the agent will be able to say what the email is. I do not know how to link the data store together with the flow. I already made an entity type of first_name and an intent. Any help would be appreciated! 

[thibaultconvert · Accepted solution]

I would use a webhook that would lookup the email in a table (or a file for that matter....)

[thibaultconvert · Accepted solution]

I would use a webhook that would lookup the email in a table (or a file for that matter....)

[lsolatorio · Accepted solution]

Hi @mariareccoppa, 

Welcome and thank you for reaching out to our community.

I agree with @thibaultconvert to use webhooks for this integration requirement.

Dialogflow CX currently provides several built-in integrations with other conversation platforms. These integrations provide a user interface to the end-user, and they call the Dialogflow API for you. All you need to do is build your agent and optionally implement a webhook service. Each integration handles interactions in a platform-specific way, so see the specific integration documentation for details.

---

Here's a webhook document that can guide you.