JSON file not parsing due to some error in link provider

%3CLINGO-SUB%20id%3D%22lingo-sub-1388002%22%20slang%3D%22en-US%22%3EJSON%20file%20not%20parsing%20due%20to%20some%20error%20in%20link%20provider%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388002%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20the%20link%20of%20JSON%20file%20from%20National%20Stock%20Exchange%20of%20India%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.nseindia.com%2Fapi%2Foption-chain-indices%3Fsymbol%3DNIFTY%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.nseindia.com%2Fapi%2Foption-chain-indices%3Fsymbol%3DNIFTY%26nbsp%3B%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.nseindia.com%2Fapi%2Foption-chain-equities%3Fsymbol%3DAMARAJABAT%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.nseindia.com%2Fapi%2Foption-chain-equities%3Fsymbol%3DAMARAJABAT%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20gives%20output%20in%20JSON%20format%20but%20when%20i%20tested%20this%20link%20on%20JSON%20formatter%2C%20it%20shows%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20any%20one%20help%20how%20can%20i%20correct%20this%20and%20get%20result%20in%20excel%20by%20using%20any%20transformation%20from%20Get%20and%20Transform%20%26gt%3B%20from%20web%20or%20from%20json%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eneed%20m%20code%20to%20get%20it%20into%20excel%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1388002%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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 

0 Replies