Macro to get data from url.

  • Hi,


    I am trying to get data from url below is the vba code which i am using to get data but unable to get complete data.


    My output should {"response": {"objects": [["natural_light", 612, 881, 1124, 1118]]}, "error": "false"} in range ("B2").


    below is my vba code.


    I have also posted my query at:-https://www.excelforum.com/exc…to-get-data-from-url.html