Pivot View, CSV remote binding

[MARCELO]

Hi.

Acording to the documentation HERE for me to be able to use the CSV function of the pivot view, i need to suply a url, the problem is, my backend is protected using identity server, so i would also need to inform 2 headers, one for the bearer token, and one for the api-version identification. how can i solve this?

I saw that in another sample, syncfusion uses another method to download the CSV and later parses that using a function, is this the only options? sample 

[Saranya Sivan]

Hi Marcelo, 

  

We are validating the reported requirement. And we will update you the further details in two business days. 

    

Regards,  

Saranya Sivan. 

 

[Saranya Sivan]

Hi Marcelo, 

  

We would like to inform you that your requirement can be achieved by adding the bearer token and API-version identification as a query string in the HTTP URL as mentioned in the below code snippet. 

  

Client:      

   dataSourceSettings: { 

            url: 'https://localhost:44336/api/values?key=8a1c6a354c884c658ff29a8636fd7c18', 

            type: 'CSV', 

            expandAll: true, 

            enableSorting: true, 

            allowLabelFilter: true, 

            allowValueFilter: true, 

            rows: [{ name: 'name' }], 

            columns: [{ name: 'isActive' }], 

            values: [{ name: 'age' }], 

            filters: [], 

        } 

 Server: 

public class ValuesController : ApiController 

    { 

        // GET api/values 

        [HttpGet] 

        public HttpResponseMessage Get() 

        { 

          IEnumerable<KeyValuePair<string,string>> header= Request.GetQueryNameValuePairs(); 

          //getting the value pairs from the query string 

            Console.WriteLine(header.ToList()[0].Value);//get the value in the header 

  

            HttpResponseMessage response = Request.CreateResponse(); 

            return response; 

        } 

    } 

  

  

Meanwhile, we have prepared a sample for your reference. Please find the sample link and video link below. 

  

Client sample link: https://stackblitz.com/edit/angular-4aegs4-wkcunk?file=app.component.ts 

  

Server sample link: https://www.syncfusion.com/downloads/support/directtrac/general/7z/CSVWebAPI143868584 

  

Video link: https://www.syncfusion.com/downloads/support/directtrac/general/7z/SYNCLA~1-1663238696 

  

Regards, 

Saranya Sivan.