How to get JSON textview from a normal URL

Hi, this post is related to the post below:
https://www.excelforum.com/excel-pro...e-table-2.html

I am trying to understand how to get the JSON textview from a URL? Is there a tool that I need to use to retrieve the information from any URL or is it simply to add something at the end of any URL?

I spent few hours researching on this but had no luck so far.

Any idea?

Thanks.

Hi !

Many samples on forums ! Like using VBA text functions (Split for example), via the ScriptControl object, via an add-in, …

If the response is in JSON format, you need to parse it. VBA does not have a native JSON parser, so you could use third parties API.

https://github.com/VBA-tools/VBA-JSON

This below link might also help you

https://stackoverflow.com/questions/...rnal-libraries

Hi Marc, Thank you for the tip. Unfortunately your answer still confuse me as I am still quite new to VBA and JSON. What I am trying to find is a method to get JSON script (textview) from a URL so I can use it to scrape data I want. Thanks.

Hi AB33, Thanks the the link. I found it really useful. But how can I find the JSON script or JSON URL from any random website? Is the data available on the browser somewhere or do I need to use a tool to extract the JSON file from a website? Sorry, I am very new to this and I am trying to learn so I can apply the method to my project. Thank you.

See if this helps

Please Login or Register  to view this content.

It's Not available for any site. It depends how the site is built. Different sites use different methods of populating the html. The site in the question uses an api to populate the table, you use developer tools in the browser to inspect the network requests filtered to xhr requests, then work through each one to see whether the data you want is in there.

Extracting data from websites is not a one size fits all, the method and code will be different for every site. To do it properly you need to understand a bit about web development and how sites are constructed

Thank you Jindon. Kyle123 has already provided the answer for my previous post which works perfectly well. And your code does the same work. Much appreciated.

Hi Kyle123, after hours of researching online, I could have a better understanding of how JSON are used on the web development. Thank you for the clarification.