Using bearer auth token on excel export Kendo MVC

[MOZ]

Hello 

I'm using an external api for my grid datasource, for authorization I'm using this solution:

https://www.telerik.com/forums/asp-net-core-custom-datasource-pass-bearer-token

and is working fine for read event.

 $(() => {
        var grid = $("#grid").data("kendoGrid");
        grid.dataSource.transport.options.read.beforeSend = beforeSendHandler;
    });

But unfortunately is not working in Excel Export option, apparently is creating a new web request that doesn't follow the beforeRequest function flow. 

Is it possible to add the header to the export request or should I create be a custom action?

 

Greetings 

[Anton Mironov]

Hello,

Thank you for the details provided.

In order to achieve the desired behavior, I would recommend using the "excelExport" Event of the Kendo UI Grid. 

Use the function handler of the Event, make the needed tests, and preventDefault behavior if needed.

Find more information about the Excel Export in the following article:

• https://docs.telerik.com/aspnet-mvc/html-helpers/data-management/grid/export/excel-export

I hope this information helps.


Kind Regards,
Anton Mironov
Progress Telerik

[MOZ]

Hello Anton

I tried the approach you're suggesting but the excelExport event is for files configuration purposes and it triggers after the requests, it's like the saveAsExcel() function is not using the beforeRequestHandler function on the datasource transport options. 

Regards.

[MOZ]

Hello there.
I managed to set the beforeSend option overriding the excel/kendo-excel definition and adding this line:


this.dataSource.transport.options.read.beforeSend = beforeSendHandler;


After creating the new excelExporter, either way, if there's an easier way to do this, I will appreciate it to let me know. 


Thank you in advance.

[Anton Mironov]

Hello,

You are totally correct this approach is an excellent decision.

Another one that I would recommend is handling the "click" event of the Excel export button. Prevent the default behavior, implement the needed logic and then manually force the export functionality.

I hope this information helps. Let me know if I should look for another solution, or if further assistance is needed.

 

Best Regards,
Anton Mironov
Progress Telerik