Genesys Cloud - Main

What is the "reference key" in data table of Genesys architect

My question is whether the reference key is like a inbuilt variable or just a discription . I do not understand how it is applicable when it is called in an architect. Also would like to know how to block a call based on ANI using data table 

#ArchitectureandDesign

------------------------------
Manzoor Kolathingal
ACI Payments, Inc
------------------------------

It is the column that you are using to perform a lookup in the table. So, say it's a table of Customers, it might be the Customer ID, or their Phone Number.

HTH

------------------------------
Paul Simpson
Eventus Solutions Group
------------------------------

Does the reference key have a type? 

I want to store phone numbers and then check if the phoen number is in the data table, do I need to convert the phone number to a string or an integer or can I make the reference key a phone muber type?

------------------------------
Bruce Dunn
State of Delaware - Department of Transportation
------------------------------

Original Message:
Sent: 03-16-2023 10:55
From: Paul Simpson
Subject: What is the "reference key" in data table of Genesys architect

It is the column that you are using to perform a lookup in the table. So, say it's a table of Customers, it might be the Customer ID, or their Phone Number.

HTH

------------------------------
Paul Simpson
Eventus Solutions Group
------------------------------

Datatables only support boolean, integer, decimal, and string types.

https://help.mypurecloud.com/articles/create-a-data-table/

Before you just ToString the value, read https://help.mypurecloud.com/articles/about-the-phone-number-data-type/ 

You need to make sure you use a consistent format for the phone number so the lookup can find it, something like this expression ToPhoneNumber("insertPhoneNumberHere").e164

------------------------------
Melissa Bailey
Genesys - Employees
------------------------------

Original Message:
Sent: 05-19-2023 13:00
From: Bruce Dunn
Subject: What is the "reference key" in data table of Genesys architect

Does the reference key have a type? 

I want to store phone numbers and then check if the phoen number is in the data table, do I need to convert the phone number to a string or an integer or can I make the reference key a phone muber type?

------------------------------
Bruce Dunn
State of Delaware - Department of Transportation
------------------------------


Original Message:
Sent: 03-16-2023 10:55
From: Paul Simpson
Subject: What is the "reference key" in data table of Genesys architect

It is the column that you are using to perform a lookup in the table. So, say it's a table of Customers, it might be the Customer ID, or their Phone Number.

HTH

------------------------------
Paul Simpson
Eventus Solutions Group