Access value from the database

Studio
1

Hi…

https://community.yellow.ai/t/displaying-api-response/1906

how can we use this in conversational Studio UI as shown in the query above? any doc or guide on this.
my output show [object object]

2

Hey @izuan.yusop
First, you need to store the result of a database search in an object variable. Now, in the Text message node, you can access it with this syntax {{variables.db_result.0.column_name}}

Here the column name is the same column name in the database. I hope this helps!

3

Hi Pratik,

how about db_result? is it a default? or is it represent table or variable name.
{{variables.db_result.0.os_custid}}

4

@izuan.yusop here db_result is a variable in which you’re storing the database search result.
0 is the index value and column_name is the column name of the table on which you’re trying to run a search query.

5

image
Hii @Pratik As you can see I have used the same format as you mentioned but I am not getting the value displayed in the response. I have even used the same with 3 pairs of curly braces however the response remains the same. The part containing the value is always omitted.

6

Hi Pratik,

Thanks for your reply.
As per your instruction, still unable to display the output from the database created.

below is to explain what I try to achieve.
-key in serial number
-match with database
-if success, to display cust info

Flow1
Flow11152×648 64.2 KB

Flow1a
Flow1a774×655 47.3 KB

Flow1b
Flow1b694×640 52.8 KB

appreciate your reply. thank you very much

7

Can you please share bot access with me at pratik@yellow.ai?

8

Hey @izuan.yusop
It’s been fixed now. It was my bad, correct syntax to access values from database is {{{variables.db_response.records.0.column_name}}}

11

Hi Pratik,

Now it works. thank you very much for your support

result1
result1968×511 80.9 KB

result2