Genesys Cloud - Main

I know this has to be fairly simple, but I guess my brain is on vacation this week!
#ArchitectureandDesign

------------------------------
Brenda Wynne
Alcon Vision LLC
------------------------------

If someone doesn't send one before Monday I can send you something then Brenda.  Usually the main sticking point is in getting the ANI formatted to match what format you're entering the ANIs into the data table.  What I usually do is format the ANI to get the subscriber number part, and prefix that with a 0.  That's because that matches what most of our contact centre people are used to dialing, e.g., 0211234567 instead of +64211234567.  Then in your data table you would have the 0211234567 value.  So start off by formatting the ANI into a variable for how you want it to match your entries in the data table.  Then when you do your data table lookup, use that ANI formatted variable to look for the row.

One of the only downsides to this approach for us is if you use the export to CSV function to do bulk updates on data table rows.  Excel will not play nice and try to strip those leading zeroes.

------------------------------
Vaun McCarthy
------------------------------

Original Message:
Sent: 8/13/2022 2:16:00 AM
From: Vaun McCarthy
Subject: RE: Looking for example flow that checks a data table for ANI and returns values based on ANI match

If someone doesn't send one before Monday I can send you something then Brenda.  Usually the main sticking point is in getting the ANI formatted to match what format you're entering the ANIs into the data table.  What I usually do is format the ANI to get the subscriber number part, and prefix that with a 0.  That's because that matches what most of our contact centre people are used to dialing, e.g., 0211234567 instead of +64211234567.  Then in your data table you would have the 0211234567 value.  So start off by formatting the ANI into a variable for how you want it to match your entries in the data table.  Then when you do your data table lookup, use that ANI formatted variable to look for the row.

One of the only downsides to this approach for us is if you use the export to CSV function to do bulk updates on data table rows.  Excel will not play nice and try to strip those leading zeroes.

------------------------------
Vaun McCarthy
------------------------------

Hey Brenda,

We're using a lookup for our known 'abusive callers' numbers and have them loaded in a Data Table in the E.164 format

In Architect, the ANI that's available will be formatted with either 'sip:' or 'tel:' as the first four digits.

So we strip off the first four digits of the ANI before doing the data table lookup in the E.164 format.

Hope that helps!

Cheers,
Jeff

Hi Jeff

Another way of achieving what you've got with your subsring function to get the E164 is to use the additional properties on the ANI - something like:

ToString(ToPhoneNumber(Call.Ani).e164)

https://help.mypurecloud.com/articles/about-the-phone-number-data-type/

------------------------------
Vaun McCarthy
------------------------------

Original Message:
Sent: 08-14-2022 19:58
From: Jeffrey Hoogkamer
Subject: Looking for example flow that checks a data table for ANI and returns values based on ANI match

Hey Brenda,

We're using a lookup for our known 'abusive callers' numbers and have them loaded in a Data Table in the E.164 format

In Architect, the ANI that's available will be formatted with either 'sip:' or 'tel:' as the first four digits.

So we strip off the first four digits of the ANI before doing the data table lookup in the E.164 format.

Hope that helps!

Cheers,
Jeff

Thanks Vaun!

Hadn't even considered to look for additional properties on the ANI - that'll be much cleaner.

------------------------------
Jeffrey
------------------------------

Original Message:
Sent: 08-14-2022 20:58
From: Vaun McCarthy
Subject: Looking for example flow that checks a data table for ANI and returns values based on ANI match

Hi Jeff

Another way of achieving what you've got with your subsring function to get the E164 is to use the additional properties on the ANI - something like:

ToString(ToPhoneNumber(Call.Ani).e164)

https://help.mypurecloud.com/articles/about-the-phone-number-data-type/

------------------------------
Vaun McCarthy
------------------------------


Original Message:
Sent: 08-14-2022 19:58
From: Jeffrey Hoogkamer
Subject: Looking for example flow that checks a data table for ANI and returns values based on ANI match

Hey Brenda,

We're using a lookup for our known 'abusive callers' numbers and have them loaded in a Data Table in the E.164 format

In Architect, the ANI that's available will be formatted with either 'sip:' or 'tel:' as the first four digits.

So we strip off the first four digits of the ANI before doing the data table lookup in the E.164 format.

Hope that helps!

Cheers,
Jeff

Original Message:
Sent: 8/14/2022 7:58:00 PM
From: Jeffrey Hoogkamer
Subject: RE: Looking for example flow that checks a data table for ANI and returns values based on ANI match

Hey Brenda,

We're using a lookup for our known 'abusive callers' numbers and have them loaded in a Data Table in the E.164 format

In Architect, the ANI that's available will be formatted with either 'sip:' or 'tel:' as the first four digits.

So we strip off the first four digits of the ANI before doing the data table lookup in the E.164 format.

Hope that helps!

Cheers,
Jeff

Tiny note for everyone doing a substring or a left+right -- you can get by with just right(call.ani,10) and not have to remember the counts for the substring. Blocked caller lookup+block is also a great use case for common modules.