Expression.Error: We cannot apply operator & to types Text and Function.

%3CLINGO-SUB%20id%3D%22lingo-sub-1580554%22%20slang%3D%22en-US%22%3ERe%3A%20Expression.Error%3A%20We%20cannot%20apply%20operator%20%26amp%3Bamp%3B%20to%20types%20Text%20and%20Function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1580554%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F755456%22%20target%3D%22_blank%22%3E%40Nilesh_c%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20query%20shall%20not%20work%20at%20all%2C%20at%20least%20Symbol%2C%20FromDate()%2C%20Todate()%20are%20not%20defined.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1581276%22%20slang%3D%22en-US%22%3ERe%3A%20Expression.Error%3A%20We%20cannot%20apply%20operator%20%26amp%3Bamp%3B%20to%20types%20Text%20and%20Function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581276%22%20slang%3D%22en-US%22%3EThnx%20Brother.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1580122%22%20slang%3D%22en-US%22%3EExpression.Error%3A%20We%20cannot%20apply%20operator%20%26amp%3Bamp%3B%20to%20types%20Text%20and%20Function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1580122%22%20slang%3D%22en-US%22%3EDetails%3A%3CBR%20%2F%3EOperator%3D%26amp%3Bamp%3B%3CBR%20%2F%3ELeft%3D%26amp%3Bnbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.nseindia.com%2Fapi%2Fhistorical%2Fcm%2Fequity%3Fsymbol%3D%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.nseindia.com%2Fapi%2Fhistorical%2Fcm%2Fequity%3Fsymbol%3D%3C%2FA%3E%3CBR%20%2F%3ERight%3D%5BFunction%5D%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3E%26amp%3Bnbsp%3Blet%3CBR%20%2F%3ESource%20%3D%20Csv.Document(Web.Contents(%22%3CA%20href%3D%22https%3A%2F%2Fwww.nseindia.com%2Fapi%2Fhistorical%2Fcm%2Fequity%3Fsymbol%3D%26quot%3B%26amp%3Bamp%3BSymbol%26amp%3Bamp%3B%26quot%3B%26amp%3Bamp%3Bseries%3D%5B%2522EQ%2522%5D%26amp%3Bamp%3Bfrom%3D%26quot%3B%26amp%3Bamp%3BFromDate()%26amp%3Bamp%3B%26quot%3B%26amp%3Bamp%3Bto%3D%26quot%3B%26amp%3Bamp%3BTodate()%26amp%3Bamp%3B%26quot%3B%26amp%3Bamp%3Bcsv%3Dtrue%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.nseindia.com%2Fapi%2Fhistorical%2Fcm%2Fequity%3Fsymbol%3D%22%26amp%3Bamp%3BSymbol%26amp%3Bamp%3B%22%26amp%3Bamp%3Bseries%3D%5B%2522EQ%2522%5D%26amp%3Bamp%3Bfrom%3D%22%26amp%3Bamp%3BFromDate()%26amp%3Bamp%3B%22%26amp%3Bamp%3Bto%3D%22%26amp%3Bamp%3BTodate()%26amp%3Bamp%3B%22%26amp%3Bamp%3Bcsv%3Dtrue%3C%2FA%3E%22%2C%20%5BHeaders%3D%5B%23%22Accept-Encoding%22%3D%22gzip%2C%20deflate%22%2C%20%23%22Accept-Language%22%3D%22en-GB%2Cen%22%2C%20%23%22User-Agent%22%3D%22Mozilla%2F5.0%20(Windows%20NT%206.1)%20AppleWebKit%2F537.36%20(KHTML%2C%20like%20Gecko)%20Chrome%2F84.0.4147.105%20Safari%2F537.36%22%2C%20Cookie%3D%22Cookies()%22%5D%5D)%2C%5BDelimiter%3D%22%2C%22%2C%20Columns%3D14%2C%20Encoding%3D65001%2C%20QuoteStyle%3DQuoteStyle.None%5D)%3CBR%20%2F%3Ein%3CBR%20%2F%3ESource%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3CBR%20%2F%3E%26amp%3Bnbsp%3B%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1580122%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor
Details:
Operator=&
Left= https://www.nseindia.com/api/historical/cm/equity?symbol=
Right=[Function]
 
 let
Source = Csv.Document(Web.Contents("https://www.nseindia.com/api/historical/cm/equity?symbol="&Symbol&"&series=[%22EQ%22]&am...", [Headers=[#"Accept-Encoding"="gzip, deflate", #"Accept-Language"="en-GB,en", #"User-Agent"="Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.105 Safari/537.36", Cookie="Cookies()"]]),[Delimiter=",", Columns=14, Encoding=65001, QuoteStyle=QuoteStyle.None])
in
Source
 
 
2 Replies
Highlighted

@Nilesh_c 

This query shall not work at all, at least Symbol, FromDate(), Todate() are not defined.

Highlighted