May 13 2020 06:20 PM - edited May 13 2020 06:27 PM
This is the link of JSON file from National Stock Exchange of India
https://www.nseindia.com/api/option-chain-indices?symbol=NIFTY
https://www.nseindia.com/api/option-chain-equities?symbol=AMARAJABAT
It gives output in JSON format but when i tested this link on JSON formatter, it shows error
Can any one help how can i correct this and get result in excel by using any transformation from Get and Transform > from web or from json
need m code to get it into excel