Genesys Cloud - Main

hi all,
just need to check if it is possible or if there is a API to perform the below?

I am using Architech to create a entry into a Data Table for certain customers who calls in [Key = ANI; Date = date and time of call]
what i am looking for is, due to Data Table limitation "The number of data rows allowed in a single table is 5000.", is to delete all entries where date is => 2 days.

This will be used to identify repeat callers, so if the caller calls back for a second time and the ANI exist within the Data Table, i can then delete that entry.
the issue is that if a caller does not call in a second time in a certain timeframe, i need to delete the entries => 2 days old to ensure i don't exceed the 5000 limitation.

so basically i am looking for something similar to SQL script:

Delete *
Where X => Y
#ArchitectureandDesign

------------------------------
Reginald Sheraton
------------------------------

Hi all,
just an update on this.
I managed to resolve by running a API as a APP outside Architech which will run every hour on the hour to:

1. Get all entries in Data Table
2. Delete all entries where the date meets my criteria, older than a day

------------------------------
Reginald Sheraton
------------------------------

Original Message:
Sent: 06-23-2021 02:20
From: Reginald Sheraton
Subject: Delete Multiple Fields in a Data Table

hi all,
just need to check if it is possible or if there is a API to perform the below?

I am using Architech to create a entry into a Data Table for certain customers who calls in [Key = ANI; Date = date and time of call]
what i am looking for is, due to Data Table limitation "The number of data rows allowed in a single table is 5000.", is to delete all entries where date is => 2 days.

This will be used to identify repeat callers, so if the caller calls back for a second time and the ANI exist within the Data Table, i can then delete that entry.
the issue is that if a caller does not call in a second time in a certain timeframe, i need to delete the entries => 2 days old to ensure i don't exceed the 5000 limitation.

so basically i am looking for something similar to SQL script:

Delete *
Where X => Y
#ArchitectureandDesign

------------------------------
Reginald Sheraton
------------------------------

Hi Reginald,

Are you able to advise which API's you used, as I'm looking to perform something very similar. Have a data action that populate a table with certain captured info that's needed for a web survey, and I'm exploring ways to purge the table.

Feedback appreciated.

Thanks,

------------------------------
Neil Jones
Voice Comms Lead
Awaze Uk
United Kingdom
neil.jones@awaze.com
------------------------------

Original Message:
Sent: 06-23-2021 07:07
From: Reginald Sheraton
Subject: Delete Multiple Fields in a Data Table

Hi all,
just an update on this.
I managed to resolve by running a API as a APP outside Architech which will run every hour on the hour to:

1. Get all entries in Data Table
2. Delete all entries where the date meets my criteria, older than a day

------------------------------
Reginald Sheraton

Original Message:
Sent: 06-23-2021 02:20
From: Reginald Sheraton
Subject: Delete Multiple Fields in a Data Table

hi all,
just need to check if it is possible or if there is a API to perform the below?

I am using Architech to create a entry into a Data Table for certain customers who calls in [Key = ANI; Date = date and time of call]
what i am looking for is, due to Data Table limitation "The number of data rows allowed in a single table is 5000.", is to delete all entries where date is => 2 days.

This will be used to identify repeat callers, so if the caller calls back for a second time and the ANI exist within the Data Table, i can then delete that entry.
the issue is that if a caller does not call in a second time in a certain timeframe, i need to delete the entries => 2 days old to ensure i don't exceed the 5000 limitation.

so basically i am looking for something similar to SQL script:

Delete *
Where X => Y
#ArchitectureandDesign

------------------------------
Reginald Sheraton
------------------------------