I'm trying to get my table to export using the result of an AJAX request to my server.

Here is the code I am using:

jQuery.fn.DataTable.Api.register( 'buttons.exportData()', function ( options ) {
    if ( this.context.length ) {
        var jsonResult = $.ajax({
            url: 'http://leadbind.dev/backend/leads/datatable',
            //data: {search: $('#search').val()},
        success: function (result) {
            //Do nothing
        },
        async: false
    });

        console.log(jsonResult.responseJSON.data);

        return {body: jsonResult.responseJSON.data, header: $("#leads_datatable thead tr th").map(function() { return this.innerHTML; }).get()};
    }
} );

When I click the export button, I see this result for the request:

{draw: 0, recordsTotal: 9, recordsFiltered: 9,…}
data
:
[{id: "1", segment_id: "1", source_id: "1", source_cost: "55.00",…},…]
draw
:
0
input
:
[]
queries
:
[,…]
recordsFiltered
:
9
recordsTotal
:
9

The console.log result for jsonResult.responseJSON.data is:

Array(9)
0
:
{id: "1", segment_id: "1", source_id: "1", source_cost: "55.00", data: {…}, …}
1
:
{id: "2", segment_id: "1", source_id: "1", source_cost: "55.00", data: {…}, …}
2
:
{id: "3", segment_id: "1", source_id: "1", source_cost: "55.00", data: {…}, …}
3
:
{id: "4", segment_id: "1", source_id: "2", source_cost: "0.00", data: {…}, …}
4
:
{id: "5", segment_id: "1", source_id: "1", source_cost: "55.00", data: {…}, …}
5
:
{id: "6", segment_id: "1", source_id: "1", source_cost: "55.00", data: {…}, …}
6
:
{id: "7", segment_id: "1", source_id: "1", source_cost: "55.00", data: {…}, …}
7
:
{id: "8", segment_id: "1", source_id: "1", source_cost: "55.00", data: {…}, …}
8
:
{id: "9", segment_id: "1", source_id: "1", source_cost: "55.00", data: {…}, …}
length
:
9
__proto__
:
Array(0)

It creates the excel file but there are no rows in it, only headings. How do I fix this?