Hi All,
I am new to macro. Need your help in reading the JASON contents from a url and writing it to a excel.
sample jason contents:
{"uuid":"345NJKNSERJN34334NJK","code":"KUSHI","name":"Kushi company","customerSegment":"BC","marketGroup":"BC","corporatePartnerType":"new CUST","divisions":[{"uuid":"abcd1234nejdj232","code":"KIMINCCCC","name":"Kim jobn","shortName":"Kim hojnh","remarks":"A Luxury Goods Company","businessPartners":[{"uuid":"4NJSNEJKR23434NJKN343","cw1Code":"CKSKII011","name":"KIM TRADITIONAL CORPORATION","address":{"uuid":"ABDSJF324324NSJKERNJK32434","addressLine1":"11958 NEW ST","city":"GARDEN CLOVE","zip":"600055","countryCode":"IN"}}]},{"uuid":"ASEJKRNJK3243423JNKJ234234","code":"KATHIRKCERE","name":"KATHIR Holdings","shortName":"KARTHIR Holdings","remarks":"Sells Packaging, Containers For MY Industry","businessPartners":[{"uuid":"SDHFNVKJE3456729VDKKENK34934M455","cw1Code":"INKUS008","name":"KATHIR HOLDINGS","address":{"uuid":"ZDFASER238374823108348838492NJHJ","addressLine1":"11958 KOIL STREET","city":"CLOVE GROVE","zip":"600044","countryCode":"INS"}}]}]}
Desired output:
"uuid","code","name","customerSegment","marketGroup","corporatePartnerType","divisions__uuid","divisions__code","divisions__name","divisions__shortName","divisions__remarks","divisions__businessPartners__uuid","divisions__businessPartners__cw1Code","divisions__businessPartners__name","divisions__businessPartners__address__uuid","divisions__businessPartners__address__addressLine1","divisions__businessPartners__address__city","divisions__businessPartners__address__zip","divisions__businessPartners__address__countryCode"
"345NJKNSERJN34334NJK","KUSHI","Kushi company","BC","BC","new CUST","abcd1234nejdj232","KIMINCCCC","Kim jobn","Kim hojnh","A Luxury Goods Company","4NJSNEJKR23434NJKN343","CKSKII011","KIM TRADITIONAL CORPORATION","ABDSJF324324NSJKERNJK32434","11958 NEW ST","GARDEN CLOVE","600055","IN"
"","","","","","","ASEJKRNJK3243423JNKJ234234","KATHIRKCERE","KATHIR Holdings","KARTHIR Holdings","Sells Packaging, Containers For MY Industry","SDHFNVKJE3456729VDKKENK34934M455","INKUS008","KATHIR HOLDINGS","ZDFASER238374823108348838492NJHJ","11958 KOIL STREET","CLOVE GROVE","600044","INS"