Genesys Cloud - Main

 View Only

Sign Up

  Thread closed by the administrator, not accepting new replies.

  • 1.  Automate and Update Data tables

    Posted 01-03-2025 16:08
    No replies, thread closed.

    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.


    #ArchitectureandDesign

    ------------------------------
    Reuben Goodwin
    Sr. Telephony Engineer
    ------------------------------


  • 2.  RE: Automate and Update Data tables
    Best Answer

    Posted 01-03-2025 17:13
    No replies, thread closed.

    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. 



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



  • 3.  RE: Automate and Update Data tables

    Posted 01-07-2025 07:45
    No replies, thread closed.

    Thank you, Robert. Let me Look into it.

     

    Reuben Goodwin
    Sr. Telephony Engineer

    Reuben.Goodwin@loancare.com | NMLS 2916



    SERVICE BEYOND EXPECTATIONS
    Visit loancare.com for news and insights.





    Original Message


  • 4.  RE: Automate and Update Data tables

    Posted 02-20-2025 02:56
    No replies, thread closed.

    Hi Robert,

    The import/jobs API schema contains a string value for 'uploadURI' how is this defined to upload a edited file ?

    Thanks,



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

    Original Message


Related Content