Stored procedure parameter missing from URL

Radzen Blazor Studio
1

Hello,

When I infer a data source, the Service.cs file excludes parameters from the generated URL for exporting a stored procedure with paramters to Excel / CSV.

For example, here is some generated code:

public async System.Threading.Tasks.Task ExportVerifyRawuploadsToExcel(Guid? RawUploadKey, Query query = null, string fileName = null)

        {

            navigationManager.NavigateTo(query != null ? query.ToUrl($"export/wv_dev/verifyrawuploads/excel(fileName='{(!string.IsNullOrEmpty(fileName) ? UrlEncoder.Default.Encode(fileName) : "Export")}')") : $"export/wv_dev/verifyrawuploads/excel(fileName='{(!string.IsNullOrEmpty(fileName) ? UrlEncoder.Default.Encode(fileName) : "Export")}')", true);

        }

But for it to work I have to edit it as:

public async System.Threading.Tasks.Task ExportVerifyRawuploadsToExcel(Guid? RawUploadKey, Query query = null, string fileName = null)

        {

            navigationManager.NavigateTo(query != null ? query.ToUrl($"export/wv_dev/verifyrawuploads/excel(RawUploadKey={RawUploadKey}, fileName='{(!string.IsNullOrEmpty(fileName) ? UrlEncoder.Default.Encode(fileName) : "Export")}')") : $"export/wv_dev/verifyrawuploads/excel(RawUploadKey={RawUploadKey}, fileName='{(!string.IsNullOrEmpty(fileName) ? UrlEncoder.Default.Encode(fileName) : "Export")}')", true);

        }
2

Please send us the procedure definition to make sure we are troubleshooting the exact case.

3 
ALTER PROCEDURE [stage].[verify_RawUpload] @RawUploadKey UNIQUEIDENTIFIER AS

SET NOCOUNT ON;

SELECT
    RowIndex + 2 AS RowNumber
    , ColumnName AS [Column]
    , CellValue AS [Value]
    , Error
FROM [stage].[ErrorLog]
WHERE RawUploadKey = @RawUploadKey;
4

Thanks @Zach.E! We were able to identify and fix the problem and it will be part of our next update early next week!

5

Great, thank you very much!