Genesys Cloud - Main

Hi.

Let me talk about "data table search" in Architect.

It is assumed to use such a way that a phone number is registered in the data table
and if the caller number matches the telephone number of the table, it will arrive at
a specific queue.

Currently, the expression: Call.Ani is specified for "input" in "Data table search"
of Architect, but it can not match on the table. To "input" literal: 080XXXXXXXX (number itself)
is specified, the table matches and assumes the operation.

Is it necessary to convert the type to match Call.Ani with the key of the data table?



------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

Call.Ani usually looks like tel:+13175551111.  If you just want to get digits part of the phone number, use ToPhoneNumber(Call.Ani).subscriberNumber.

Here's an article talking about phone number formats.
https://help.mypurecloud.com/articles/about-the-phone-number-data-type/

Lastly a debugging tip--when a value appears to be wrong during a call flow execution, it can be useful to either write to somewhere that you can access or play it out to the caller (only when debugging of course) to see what it actually is.  You could use the Set Participant Data action to write the value out on the conversation object, if you know how to use the api to fetch a conversation.  To play it out loud during the call make sure you choose Speak each character.



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

Original Message:
Sent: 07-12-2018 01:21
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi.

Let me talk about "data table search" in Architect.

It is assumed to use such a way that a phone number is registered in the data table
and if the caller number matches the telephone number of the table, it will arrive at
a specific queue.

Currently, the expression: Call.Ani is specified for "input" in "Data table search"
of Architect, but it can not match on the table. To "input" literal: 080XXXXXXXX (number itself)
is specified, the table matches and assumes the operation.

Is it necessary to convert the type to match Call.Ani with the key of the data table?



------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

Hi, ​Melissa Bailey.

I was able to do something safely with the answers you gave me.
Thank you very much !!

------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

Original Message:
Sent: 07-12-2018 09:27
From: Melissa Bailey
Subject: How to match ANI to data tables

Call.Ani usually looks like tel:+13175551111.  If you just want to get digits part of the phone number, use ToPhoneNumber(Call.Ani).subscriberNumber.

Here's an article talking about phone number formats.
https://help.mypurecloud.com/articles/about-the-phone-number-data-type/

Lastly a debugging tip--when a value appears to be wrong during a call flow execution, it can be useful to either write to somewhere that you can access or play it out to the caller (only when debugging of course) to see what it actually is.  You could use the Set Participant Data action to write the value out on the conversation object, if you know how to use the api to fetch a conversation.  To play it out loud during the call make sure you choose Speak each character.



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

Original Message:
Sent: 07-12-2018 01:21
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi.

Let me talk about "data table search" in Architect.

It is assumed to use such a way that a phone number is registered in the data table
and if the caller number matches the telephone number of the table, it will arrive at
a specific queue.

Currently, the expression: Call.Ani is specified for "input" in "Data table search"
of Architect, but it can not match on the table. To "input" literal: 080XXXXXXXX (number itself)
is specified, the table matches and assumes the operation.

Is it necessary to convert the type to match Call.Ani with the key of the data table?



------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

Hi Makoto,

I am using a similar facility with Data Tables, (based on DNIS, not ANI).
I store the numbers as full E.164 format (including + ), and the Architect look-up is:
ToPhoneNumber(Call.CalledAddressOriginal).e164

Cheers,

Jean-Christophe

------------------------------
Jean-Christophe Poyelle
Foehn Ltd.
------------------------------

Original Message:
Sent: 07-16-2018 21:30
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi, ​Melissa Bailey.

I was able to do something safely with the answers you gave me.
Thank you very much !!

------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)

Original Message:
Sent: 07-12-2018 09:27
From: Melissa Bailey
Subject: How to match ANI to data tables

Call.Ani usually looks like tel:+13175551111.  If you just want to get digits part of the phone number, use ToPhoneNumber(Call.Ani).subscriberNumber.

Here's an article talking about phone number formats.
https://help.mypurecloud.com/articles/about-the-phone-number-data-type/

Lastly a debugging tip--when a value appears to be wrong during a call flow execution, it can be useful to either write to somewhere that you can access or play it out to the caller (only when debugging of course) to see what it actually is.  You could use the Set Participant Data action to write the value out on the conversation object, if you know how to use the api to fetch a conversation.  To play it out loud during the call make sure you choose Speak each character.



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

Original Message:
Sent: 07-12-2018 01:21
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi.

Let me talk about "data table search" in Architect.

It is assumed to use such a way that a phone number is registered in the data table
and if the caller number matches the telephone number of the table, it will arrive at
a specific queue.

Currently, the expression: Call.Ani is specified for "input" in "Data table search"
of Architect, but it can not match on the table. To "input" literal: 080XXXXXXXX (number itself)
is specified, the table matches and assumes the operation.

Is it necessary to convert the type to match Call.Ani with the key of the data table?



------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

​Hi Jean-Christophe Poyelle,

Thank you for telling me more tips !
I would like to try this.

------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

Original Message:
Sent: 07-17-2018 03:53
From: Jean-Christophe Poyelle
Subject: How to match ANI to data tables

Hi Makoto,

I am using a similar facility with Data Tables, (based on DNIS, not ANI).
I store the numbers as full E.164 format (including + ), and the Architect look-up is:
ToPhoneNumber(Call.CalledAddressOriginal).e164

Cheers,

Jean-Christophe

------------------------------
Jean-Christophe Poyelle
Foehn Ltd.

Original Message:
Sent: 07-16-2018 21:30
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi, ​Melissa Bailey.

I was able to do something safely with the answers you gave me.
Thank you very much !!

------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)

Original Message:
Sent: 07-12-2018 09:27
From: Melissa Bailey
Subject: How to match ANI to data tables

Call.Ani usually looks like tel:+13175551111.  If you just want to get digits part of the phone number, use ToPhoneNumber(Call.Ani).subscriberNumber.

Here's an article talking about phone number formats.
https://help.mypurecloud.com/articles/about-the-phone-number-data-type/

Lastly a debugging tip--when a value appears to be wrong during a call flow execution, it can be useful to either write to somewhere that you can access or play it out to the caller (only when debugging of course) to see what it actually is.  You could use the Set Participant Data action to write the value out on the conversation object, if you know how to use the api to fetch a conversation.  To play it out loud during the call make sure you choose Speak each character.



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

Original Message:
Sent: 07-12-2018 01:21
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi.

Let me talk about "data table search" in Architect.

It is assumed to use such a way that a phone number is registered in the data table
and if the caller number matches the telephone number of the table, it will arrive at
a specific queue.

Currently, the expression: Call.Ani is specified for "input" in "Data table search"
of Architect, but it can not match on the table. To "input" literal: 080XXXXXXXX (number itself)
is specified, the table matches and assumes the operation.

Is it necessary to convert the type to match Call.Ani with the key of the data table?



------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

2+ Years later, and this was exactly what I needed. Thanks!

------------------------------
Clay Cowell
Media Sales Plus, Inc.
------------------------------

Original Message:
Sent: 07-12-2018 09:27
From: Melissa Bailey
Subject: How to match ANI to data tables

Call.Ani usually looks like tel:+13175551111.  If you just want to get digits part of the phone number, use ToPhoneNumber(Call.Ani).subscriberNumber.

Here's an article talking about phone number formats.
https://help.mypurecloud.com/articles/about-the-phone-number-data-type/

Lastly a debugging tip--when a value appears to be wrong during a call flow execution, it can be useful to either write to somewhere that you can access or play it out to the caller (only when debugging of course) to see what it actually is.  You could use the Set Participant Data action to write the value out on the conversation object, if you know how to use the api to fetch a conversation.  To play it out loud during the call make sure you choose Speak each character.



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

Original Message:
Sent: 07-12-2018 01:21
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi.

Let me talk about "data table search" in Architect.

It is assumed to use such a way that a phone number is registered in the data table
and if the caller number matches the telephone number of the table, it will arrive at
a specific queue.

Currently, the expression: Call.Ani is specified for "input" in "Data table search"
of Architect, but it can not match on the table. To "input" literal: 080XXXXXXXX (number itself)
is specified, the table matches and assumes the operation.

Is it necessary to convert the type to match Call.Ani with the key of the data table?



------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

you can also use the "right" function to get the part of the ANI you care about for your lookup. 

For example, if my Call.Ani is tel:+18008675309
Right (Call.Ani,10) would get you 8008675309
Right (Call.Ani,12) would get you +18008675309

------------------------------
Mike Steinke
Inflow Communications
------------------------------

Original Message:
Sent: 07-12-2018 01:21
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi.

Let me talk about "data table search" in Architect.

It is assumed to use such a way that a phone number is registered in the data table
and if the caller number matches the telephone number of the table, it will arrive at
a specific queue.

Currently, the expression: Call.Ani is specified for "input" in "Data table search"
of Architect, but it can not match on the table. To "input" literal: 080XXXXXXXX (number itself)
is specified, the table matches and assumes the operation.

Is it necessary to convert the type to match Call.Ani with the key of the data table?



------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

BTW, in Australia, the area code is always read back with a leading zero ...

So you can also use ... Append("0",Right(Call.Ani,9))

If Ani = tel:+61401234567
then Result = 0401234567

------------------------------
Thanks and regards,

Malcolm Green (GCP - PureCloud)
Nexon Asia Pacific
------------------------------

Original Message:
Sent: 08-21-2020 13:23
From: Mike Steinke
Subject: How to match ANI to data tables

you can also use the "right" function to get the part of the ANI you care about for your lookup.

For example, if my Call.Ani is tel:+18008675309
Right (Call.Ani,10) would get you 8008675309
Right (Call.Ani,12) would get you +18008675309

------------------------------
Mike Steinke
Inflow Communications

Original Message:
Sent: 07-12-2018 01:21
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi.

Let me talk about "data table search" in Architect.

It is assumed to use such a way that a phone number is registered in the data table
and if the caller number matches the telephone number of the table, it will arrive at
a specific queue.

Currently, the expression: Call.Ani is specified for "input" in "Data table search"
of Architect, but it can not match on the table. To "input" literal: 080XXXXXXXX (number itself)
is specified, the table matches and assumes the operation.

Is it necessary to convert the type to match Call.Ani with the key of the data table?



------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

Maybe that will help someone.

If you have a 10 digit phone number in the data table for example: 2121234567 and you want to match on it via architect, CallerANI shows tel:+12121234567, then you you can remove the tel:+1 from CallerANI by using this function Replace(Call.Ani,"tel:+1","")

Rami

------------------------------
Rami Hachem
DiRAD Technologies, Inc.
------------------------------

Original Message:
Sent: 07-12-2018 01:21
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi.

Let me talk about "data table search" in Architect.

It is assumed to use such a way that a phone number is registered in the data table
and if the caller number matches the telephone number of the table, it will arrive at
a specific queue.

Currently, the expression: Call.Ani is specified for "input" in "Data table search"
of Architect, but it can not match on the table. To "input" literal: 080XXXXXXXX (number itself)
is specified, the table matches and assumes the operation.

Is it necessary to convert the type to match Call.Ani with the key of the data table?



------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------

Hi guys, my carrier in Mexico delivers the ANI without the +, so Genesys receives ANI 52xxxxxxx

How can I add in Genesys the "+" symbol to convert the ANI into E164 format?

------------------------------
Jesus Vallejo
CEMEX
------------------------------

Original Message:
Sent: 02-21-2023 09:00
From: Rami Hachem
Subject: How to match ANI to data tables

Maybe that will help someone.

If you have a 10 digit phone number in the data table for example: 2121234567 and you want to match on it via architect, CallerANI shows tel:+12121234567, then you you can remove the tel:+1 from CallerANI by using this function Replace(Call.Ani,"tel:+1","")

Rami

------------------------------
Rami Hachem
DiRAD Technologies, Inc.

Original Message:
Sent: 07-12-2018 01:21
From: Makoto Nagai
Subject: How to match ANI to data tables

Hi.

Let me talk about "data table search" in Architect.

It is assumed to use such a way that a phone number is registered in the data table
and if the caller number matches the telephone number of the table, it will arrive at
a specific queue.

Currently, the expression: Call.Ani is specified for "input" in "Data table search"
of Architect, but it can not match on the table. To "input" literal: 080XXXXXXXX (number itself)
is specified, the table matches and assumes the operation.

Is it necessary to convert the type to match Call.Ani with the key of the data table?



------------------------------
Makoto Nagai
Itochu Techno-Solutions Corporation(CTC)
------------------------------