How to debug error accessing JSON provider via URL

How to debug error accessing JSON provider via URL

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

• 

  kyle.chamberlin

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 February 2022, 11:43 am EST - Updated 30 September 2022, 7:28 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:

  

  716×219 10.4 KB

  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:

  

  1365×190 32.6 KB

  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.

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  kyle.chamberlin

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  kyle.chamberlin

  • Post Options:
  • Link
    Copy

  Posted 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.