I am trying to connect to a web api via the webservice data connector in the standalone report designer. I have been able to return the data in json format via Postman with the same query 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'.
Any thoughts on what the issue could be?
1 Answer, 1 is accepted
0
Hi Andrew,
From the error message I suspect that a parameter may not be correctly set in the Wizard. For example, you might need to add quotes - see the attached screenshot of using POST method with parameters.
Can you give us more details about the scenario of the report and the settings of the WebServiceDataSource?
You can also consider opening a new Support ticket where you can provide us the problematic report with sample data.
Regards,
Neli
Progress Telerik
From the error message I suspect that a parameter may not be correctly set in the Wizard. For example, you might need to add quotes - see the attached screenshot of using POST method with parameters.
Can you give us more details about the scenario of the report and the settings of the WebServiceDataSource?
You can also consider opening a new Support ticket where you can provide us the problematic report with sample data.
Regards,
Neli
Progress Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items