How to debug error accessing JSON provider via URL

Posted by: kyle.chamberlin on 3 February 2022, 11:43 am EST

  • Posted 3 February 2022, 11:43 am EST

    Hi all. I am currently evaluating this product, so please forgive a newcomer's question... I searched but did not find anything addressing my issue.

    I have a JSON blob available at a given URL:



    I have an RDL report with this URL in the data source, like so:



    When I try to preview the report with a basic data-dump table, I get the following error:



    I believe the presence of the < in the JSON parse exception means that my web service is returning an error of some sort instead of the JSON blob. Does anybody have any advice on how to find out what exactly this error is and how to resolve it? Does the ActiveReports VS extension have detailed logging somewhere?

    I just installed ActiveReports 16 today, and I'm using Visual Studio 2022. If any more information is needed I will be happy to provide.
  • Replied 9 February 2022, 1:14 am EST

    Hi Kyle,

    Apologies for the delay. I have made a sample report using the sample data mentioned in your query and was unable to replicate your issue. The data is being stored at the following URL:
    https://api.jsonbin.io/b/620148bf4ce71361b8d1ed38/2

    It seems the issue is with the format of the JSON data returned from the API used in your application.
    I have attached a sample report for your reference along with.

    Regards,

    Akshay
    SampleWithJsonData.zip
  • Replied 11 February 2022, 8:35 am EST

    Thank you for the reply. I don't believe my API is returning the JSON at all, I think it is returning an error message in HTML format. The issue is that the Visual Studio plugin doesn't tell me what the error is, so I'm not sure what to do to fix it.
  • Marked as Answer

    Replied 13 February 2022, 7:12 pm EST

    Hi Kyle,

    You can check if the API is working using Postman(https://www.postman.com/). As this issue is unrelated to ActiveReports you may refer to the following pages on the Microsoft Forum and StackOverFlow:

    https://social.msdn.microsoft.com/Forums/en-US/a3d0a7e1-9755-4b14-823b-b7c30ce195a6/getjsonasync-is-throwing-an-exception-in-browser?forum=aspblazor

    https://stackoverflow.com/questions/67927285/api-net-core-error400-i-is-an-invalid-start-of-a-value-path-linenumbe
  • Replied 14 February 2022, 11:23 am EST

    Thank you. I tried with Postman, and I see that my browser had cached a login that I was unaware of... it is a sign-in page that's being returned.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels