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

Copper 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

@Nilesh_c 

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