We are trying to collect some information while on a voice call via SMS and respond back via voice the data collected. (example, get the callers address).  We have a data table that we insert the callers ANI with while on the voice call.  We send an agentless SMS from the voice flow to the caller.  When the caller responds on the inbound message flow we detect the ANI as a match against the data table, then we update another table (we will call it response) with the ANI and SMS response. (from the sms flow)  Now on the voice flow, we loop or pause until we find the ANI in the response table, which does seem to work but it never seems to be able to see the data in the response column.  It seems like architect / the data action does not refresh with the most current data in the tables while in the flow, like it is cached from the start of the flow.  Also, definitely open to alternative methods if anyone has any suggestions.

Hello Rob, 

I believe there is a small delay with updating the data table. You maybe hitting that. But I would love to see the rest of the community feedback as well. 

Cheers, 

We are trying to collect some information while on a voice call via SMS and respond back via voice the data collected. (example, get the callers address).  We have a data table that we insert the callers ANI with while on the voice call.  We send an agentless SMS from the voice flow to the caller.  When the caller responds on the inbound message flow we detect the ANI as a match against the data table, then we update another table (we will call it response) with the ANI and SMS response. (from the sms flow)  Now on the voice flow, we loop or pause until we find the ANI in the response table, which does seem to work but it never seems to be able to see the data in the response column.  It seems like architect / the data action does not refresh with the most current data in the tables while in the flow, like it is cached from the start of the flow.  Also, definitely open to alternative methods if anyone has any suggestions.

We are trying to collect some information while on a voice call via SMS and respond back via voice the data collected. (example, get the callers address).  We have a data table that we insert the callers ANI with while on the voice call.  We send an agentless SMS from the voice flow to the caller.  When the caller responds on the inbound message flow we detect the ANI as a match against the data table, then we update another table (we will call it response) with the ANI and SMS response. (from the sms flow)  Now on the voice flow, we loop or pause until we find the ANI in the response table, which does seem to work but it never seems to be able to see the data in the response column.  It seems like architect / the data action does not refresh with the most current data in the tables while in the flow, like it is cached from the start of the flow.  Also, definitely open to alternative methods if anyone has any suggestions.

#API/Integrations
#ArchitectureandDesign

------------------------------
Rob Bennett
Assistant Director IT, Technical Support
------------------------------

For the collection, I prefer to use a bot, but I can see where that can probably be an issue with names and addresses.  I would build in a pause with a table lookup and some loops in the call flow.  

1. Send SMS with Data Action
2. Loop with delay to wait for SMS and to ask them to check for SMS occasionally and/or offer to resend.
3. Have them reply to SMS
4. Take SMS number and data and write to a table
5. Check table on each loop with messaging to caller
6. Get data and delete row in table.

------------------------------
Robert Wakefield-Carl
ttec Digital
Sr. Director - Innovation Architects
Robert.WC@ttecdigital.com
https://www.ttecDigital.com
https://RobertWC.Blogspot.com

Original Message:
Sent: 11-27-2024 13:25
From: Rob Bennett
Subject: Architect data tables - refreshing while in the flow

We are trying to collect some information while on a voice call via SMS and respond back via voice the data collected. (example, get the callers address).  We have a data table that we insert the callers ANI with while on the voice call.  We send an agentless SMS from the voice flow to the caller.  When the caller responds on the inbound message flow we detect the ANI as a match against the data table, then we update another table (we will call it response) with the ANI and SMS response. (from the sms flow)  Now on the voice flow, we loop or pause until we find the ANI in the response table, which does seem to work but it never seems to be able to see the data in the response column.  It seems like architect / the data action does not refresh with the most current data in the tables while in the flow, like it is cached from the start of the flow.  Also, definitely open to alternative methods if anyone has any suggestions.

#API/Integrations
#ArchitectureandDesign

------------------------------
Rob Bennett
Assistant Director IT, Technical Support
------------------------------

Thanks Robert.  That is what we are doing but the voice bot flow never seems to pick up the updated data in the table.  We can see the data in the UI while testing however it appears that if we update the data table from the inbound SMS flow, the voice bot flow never sees that updated row, we have a wait now up to 3 minutes with no success.

For the collection, I prefer to use a bot, but I can see where that can probably be an issue with names and addresses.  I would build in a pause with a table lookup and some loops in the call flow.  

1. Send SMS with Data Action
2. Loop with delay to wait for SMS and to ask them to check for SMS occasionally and/or offer to resend.
3. Have them reply to SMS
4. Take SMS number and data and write to a table
5. Check table on each loop with messaging to caller
6. Get data and delete row in table.

------------------------------
Robert Wakefield-Carl
ttec Digital
Sr. Director - Innovation Architects
Robert.WC@ttecdigital.com
https://www.ttecDigital.com
https://RobertWC.Blogspot.com

Original Message:
Sent: 11-27-2024 13:25
From: Rob Bennett
Subject: Architect data tables - refreshing while in the flow

We are trying to collect some information while on a voice call via SMS and respond back via voice the data collected. (example, get the callers address).  We have a data table that we insert the callers ANI with while on the voice call.  We send an agentless SMS from the voice flow to the caller.  When the caller responds on the inbound message flow we detect the ANI as a match against the data table, then we update another table (we will call it response) with the ANI and SMS response. (from the sms flow)  Now on the voice flow, we loop or pause until we find the ANI in the response table, which does seem to work but it never seems to be able to see the data in the response column.  It seems like architect / the data action does not refresh with the most current data in the tables while in the flow, like it is cached from the start of the flow.  Also, definitely open to alternative methods if anyone has any suggestions.

#API/Integrations
#ArchitectureandDesign

------------------------------
Rob Bennett
Assistant Director IT, Technical Support
------------------------------

We have seen no delays between the writing to the data table and reading information from it unless it is a huge table.  You should be deleting each row as you read it to keep the table small and to reuse rows.  Can you read anything from that table in your flow?  What does Execution History show?

Thanks Robert.  That is what we are doing but the voice bot flow never seems to pick up the updated data in the table.  We can see the data in the UI while testing however it appears that if we update the data table from the inbound SMS flow, the voice bot flow never sees that updated row, we have a wait now up to 3 minutes with no success.

For the collection, I prefer to use a bot, but I can see where that can probably be an issue with names and addresses.  I would build in a pause with a table lookup and some loops in the call flow.  

1. Send SMS with Data Action
2. Loop with delay to wait for SMS and to ask them to check for SMS occasionally and/or offer to resend.
3. Have them reply to SMS
4. Take SMS number and data and write to a table
5. Check table on each loop with messaging to caller
6. Get data and delete row in table.

------------------------------
Robert Wakefield-Carl
ttec Digital
Sr. Director - Innovation Architects
Robert.WC@ttecdigital.com
https://www.ttecDigital.com
https://RobertWC.Blogspot.com

Original Message:
Sent: 11-27-2024 13:25
From: Rob Bennett
Subject: Architect data tables - refreshing while in the flow

We are trying to collect some information while on a voice call via SMS and respond back via voice the data collected. (example, get the callers address).  We have a data table that we insert the callers ANI with while on the voice call.  We send an agentless SMS from the voice flow to the caller.  When the caller responds on the inbound message flow we detect the ANI as a match against the data table, then we update another table (we will call it response) with the ANI and SMS response. (from the sms flow)  Now on the voice flow, we loop or pause until we find the ANI in the response table, which does seem to work but it never seems to be able to see the data in the response column.  It seems like architect / the data action does not refresh with the most current data in the tables while in the flow, like it is cached from the start of the flow.  Also, definitely open to alternative methods if anyone has any suggestions.

#API/Integrations
#ArchitectureandDesign

------------------------------
Rob Bennett
Assistant Director IT, Technical Support
------------------------------

Thanks Robert.  When we receive the SMS response, in the SMS flow we can see the data in the table, we send a SMS response as validation.  While that is happening (really at the same time), on the voice call flow when we query the data we can only see the key, it never sees that data in the response column, even with the lengthy timeout.  Very strange.

We have seen no delays between the writing to the data table and reading information from it unless it is a huge table.  You should be deleting each row as you read it to keep the table small and to reuse rows.  Can you read anything from that table in your flow?  What does Execution History show?

Thanks Robert.  That is what we are doing but the voice bot flow never seems to pick up the updated data in the table.  We can see the data in the UI while testing however it appears that if we update the data table from the inbound SMS flow, the voice bot flow never sees that updated row, we have a wait now up to 3 minutes with no success.

For the collection, I prefer to use a bot, but I can see where that can probably be an issue with names and addresses.  I would build in a pause with a table lookup and some loops in the call flow.  

1. Send SMS with Data Action
2. Loop with delay to wait for SMS and to ask them to check for SMS occasionally and/or offer to resend.
3. Have them reply to SMS
4. Take SMS number and data and write to a table
5. Check table on each loop with messaging to caller
6. Get data and delete row in table.

------------------------------
Robert Wakefield-Carl
ttec Digital
Sr. Director - Innovation Architects
Robert.WC@ttecdigital.com
https://www.ttecDigital.com
https://RobertWC.Blogspot.com

Original Message:
Sent: 11-27-2024 13:25
From: Rob Bennett
Subject: Architect data tables - refreshing while in the flow

We are trying to collect some information while on a voice call via SMS and respond back via voice the data collected. (example, get the callers address).  We have a data table that we insert the callers ANI with while on the voice call.  We send an agentless SMS from the voice flow to the caller.  When the caller responds on the inbound message flow we detect the ANI as a match against the data table, then we update another table (we will call it response) with the ANI and SMS response. (from the sms flow)  Now on the voice flow, we loop or pause until we find the ANI in the response table, which does seem to work but it never seems to be able to see the data in the response column.  It seems like architect / the data action does not refresh with the most current data in the tables while in the flow, like it is cached from the start of the flow.  Also, definitely open to alternative methods if anyone has any suggestions.

#API/Integrations
#ArchitectureandDesign

------------------------------
Rob Bennett
Assistant Director IT, Technical Support
------------------------------

So, you know the row is being written, but nothing is coming back?  Are you using a Table Lookup or a Data Action to read the table?

Thanks Robert.  When we receive the SMS response, in the SMS flow we can see the data in the table, we send a SMS response as validation.  While that is happening (really at the same time), on the voice call flow when we query the data we can only see the key, it never sees that data in the response column, even with the lengthy timeout.  Very strange.

We have seen no delays between the writing to the data table and reading information from it unless it is a huge table.  You should be deleting each row as you read it to keep the table small and to reuse rows.  Can you read anything from that table in your flow?  What does Execution History show?

Thanks Robert.  That is what we are doing but the voice bot flow never seems to pick up the updated data in the table.  We can see the data in the UI while testing however it appears that if we update the data table from the inbound SMS flow, the voice bot flow never sees that updated row, we have a wait now up to 3 minutes with no success.

For the collection, I prefer to use a bot, but I can see where that can probably be an issue with names and addresses.  I would build in a pause with a table lookup and some loops in the call flow.  

1. Send SMS with Data Action
2. Loop with delay to wait for SMS and to ask them to check for SMS occasionally and/or offer to resend.
3. Have them reply to SMS
4. Take SMS number and data and write to a table
5. Check table on each loop with messaging to caller
6. Get data and delete row in table.

------------------------------
Robert Wakefield-Carl
ttec Digital
Sr. Director - Innovation Architects
Robert.WC@ttecdigital.com
https://www.ttecDigital.com
https://RobertWC.Blogspot.com

Original Message:
Sent: 11-27-2024 13:25
From: Rob Bennett
Subject: Architect data tables - refreshing while in the flow

We are trying to collect some information while on a voice call via SMS and respond back via voice the data collected. (example, get the callers address).  We have a data table that we insert the callers ANI with while on the voice call.  We send an agentless SMS from the voice flow to the caller.  When the caller responds on the inbound message flow we detect the ANI as a match against the data table, then we update another table (we will call it response) with the ANI and SMS response. (from the sms flow)  Now on the voice flow, we loop or pause until we find the ANI in the response table, which does seem to work but it never seems to be able to see the data in the response column.  It seems like architect / the data action does not refresh with the most current data in the tables while in the flow, like it is cached from the start of the flow.  Also, definitely open to alternative methods if anyone has any suggestions.

#API/Integrations
#ArchitectureandDesign

------------------------------
Rob Bennett
Assistant Director IT, Technical Support
------------------------------