Export Datatable to .csv file using API or automation/batch file(Creating backup of datatable)

Hello Team,

Greetings, Could someone please help me with the API name which could be used to take a backup of existing datatables(Export all the records of a datatable into CSV file) I have many datatables and wanted to take a backup of each on daily basis.
Or is there any other alternative through which this process could be automated.

Thanks in advance.

Hello,

You can export your datatable using POST /api/v2/flows/datatables/{datatableId}/export/jobs

You can check the status of the job (wiating for status: 'Succeeded') and retrieve the downloadUri (to the CSV file) using GET /api/v2/flows/datatables/{datatableId}/export/jobs/{exportJobId}.

This is what Genesys Cloud Desktop is invoking when you ask to export data for an Architect Datatable (Genesys Desktop - Admin UI).

Regards,

1 Like

Superb..!!! Thanks a lot...!!!

That worked as expected.