Forum Discussion
Expression.SyntaxError: Token Eof expected. and Token Comma expected
Please, help, i can't understand my falt
Error in editor - Expression.SyntaxError: Token Eof expected.
Error in update - Token Comma expected
= Let (page as number) as table =>
Let yesterday = Date.ToText(Date.AddDays(DateTime.Date(DateTime.LocalNow()),-1),"yyyy-MM-dd"),
Source = Json.Document(Web.Contents("URL/api/v4/orders?filter[createdAtTo]="&yesterday&"&page=" & Number.ToText(page) & "&limit=100&apiKey=TOKEN")), orders = Source[orders],
#"Converted to Table" = Table.FromList(orders, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"
Power Query is case sensitive. Instead of "Let" use "let"
You can simplify "yesterday"yesterday = DateTime.ToText(DateTime.LocalNow()-#duration(1,0,0,0),"yyyy-MM-dd")
6 Replies
Power Query is case sensitive. Instead of "Let" use "let"
You can simplify "yesterday"yesterday = DateTime.ToText(DateTime.LocalNow()-#duration(1,0,0,0),"yyyy-MM-dd")now it shows that i have error with comma and "Expression.SyntaxError: Token Eof expected." (((
you need to put "let" before "yesterday"
I am recieving "Expression.SyntaxError: Token ',' expected" for expression
IF(AND([Team]="Johnson", "Ohio") THEN, "Maryland" else [Field Office]))). I cannot clear up my error. (first says IF is spelled incorrectly now I cant get past the Syntax error) Thanks
Bridgetter please open a new thread.
