How to retrieve data from the data table in Dialog Task

Bot Builder and Task Execution Framework Dialog Builder
#1

Hi,

Greetings for the day…!!!

I am new to Kore.ai, Currently trying to develop a sample application.

Requirement: I am planning to retrieve data from the data table in Dialog Task. From data table, I have a Employee ID , Employee id needs to be verified with the User Input.

Things I did:
I have added data table, table view and App.
FYI,

Data Table:
image

Table View:
image

Apps:
image

Dialog Task:
image

Here in Dialog Task at Service node I am unable to get the data firstly.

image

Is this correct I am doing or can you please suggest how to work with the Data tables.

Thanks.

#2

Hi @kishore.nellutla,

Once you configure the service node with all the required settings, the data will be retrieved by the service node while executing the dialog task in the chat window.
You can access the data value through context object by using:
{{context.<service_node_name>.response.body.queryResult[].<column_name>}}

https://developer.kore.ai/docs/bots/advanced-topics/data-as-a-service/#Get_Data

You can use the given syntax in a message node or any other node as per your requirement.

Kindly let us know if you still observing the issue even after accessing the data value through the above syntax.

Regards,
Yoga Ramya

#3

Thank You YogaRamya for your kind help. It worked.