Forum Discussion
Expression.Error: We cannot apply operator & to types Text and Function.
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]&from="&FromDate()&"&to="&Todate()&"&csv=true", [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
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]&from="&FromDate()&"&to="&Todate()&"&csv=true", [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
This query shall not work at all, at least Symbol, FromDate(), Todate() are not defined.
- Thnx Brother.
