Cannot connect to webservice data source in report designer

2 posts, 0 answers
  1. Andrew
    Andrew avatar
    1 posts
    Member since:
    Jun 2015

    Posted 17 Jul Link to this post

    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? 

  2. Neli
    Admin
    Neli avatar
    190 posts

    Posted 22 Jul Link to this post

    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
    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
Back to Top