Genesys Cloud - Main

Hello , Is there a way to automatically import and update a data table using excel, csv with 2 fields? We have a simple manual task to import a excel sheet that has a key column and a code column. Trying to find a way to automate it maybe have the Genesys data table connect to some type of batch process file.

The Jobs API should do that. 

To get all rows of the data table:  https://developer.genesys.cloud/devapps/api-explorer#post-api-v2-flows-datatables--datatableId--export-jobs

To save all rows of the data table:  https://developer.genesys.cloud/devapps/api-explorer#post-api-v2-flows-datatables--datatableId--import-jobs

You can also delete all rows before importing with this KVP:   "importMode": "ReplaceAll"

You could run this in many ways and even use the Genesys Cloud CLI to automate this from a command prompt. 

Hello , Is there a way to automatically import and update a data table using excel, csv with 2 fields? We have a simple manual task to import a excel sheet that has a key column and a code column. Trying to find a way to automate it maybe have the Genesys data table connect to some type of batch process file.

The Jobs API should do that. 

To get all rows of the data table:  https://developer.genesys.cloud/devapps/api-explorer#post-api-v2-flows-datatables--datatableId--export-jobs

To save all rows of the data table:  https://developer.genesys.cloud/devapps/api-explorer#post-api-v2-flows-datatables--datatableId--import-jobs

You can also delete all rows before importing with this KVP:   "importMode": "ReplaceAll"

You could run this in many ways and even use the Genesys Cloud CLI to automate this from a command prompt. 

Hello , Is there a way to automatically import and update a data table using excel, csv with 2 fields? We have a simple manual task to import a excel sheet that has a key column and a code column. Trying to find a way to automate it maybe have the Genesys data table connect to some type of batch process file.