Web Service Data Source - Unable to case object of type 'System.String

0 Answers 235 Views
Report Designer (standalone) Report Parameters
Balaji
Top achievements
Rank 1
Veteran
Balaji asked on 23 Mar 2022, 08:52 AM

Hi,

I am using Web Service DS and i get this error in the standalone report designer.

I have been able to return the data in json format via Postman with the same Header parameters, but when i try to configure the data source in the report designer, I get the following error. 

System.InvalidCastException: Unable to cast object of type 'System.String' to type 'Newtonsoft.Json.Linq.JToken'.

Issue Value

{"esFilters":{"Paging":[{"paged":false,"resultsPerPage":0,"pageNumber":0}]}}

or

{ esFilters: {"Filters":[{"filterName":"","filterValue":"","filterOperator":""}],"Paging":[{"paged":true,"resultsPerPage":100,"pageNumber":1}]}}

Please advice. Thsi API works in the application and postman without any issues.

Thanks,

BV

 

 

Balaji
Top achievements
Rank 1
Veteran
commented on 24 Mar 2022, 04:53 AM

Please ignore this issue. I had solved this buy adding the correst response type in the header. application/json; charset=utf-8

Thanks.

 

No answers yet. Maybe you can help?

Tags
Report Designer (standalone) Report Parameters
Asked by
Balaji
Top achievements
Rank 1
Veteran
Share this question
or