Forum Discussion
Expression.SyntaxError - Toke Comma Expected
Hi Anonymous
It's the Source line. You're not closing the string at the end. You can see it from the colors in the editor and by clicking on "Show error" it will take you to the approximate area of the error, if not the exact place. You have
"?apikey=35c2f377815f4d1dd3d1654065134f33))
Where's the " to indicate the end of the string? Try
Source = Json.Document(Web.Contents("financialmodelingprep.com/api/v3/financial-ratios/" & Ticker & "?apikey=35c2f377815f4d1dd3d1654065134f33" ) ),
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers
Community ChampionHi Anonymous
It's the Source line. You're not closing the string at the end. You can see it from the colors in the editor and by clicking on "Show error" it will take you to the approximate area of the error, if not the exact place. You have
"?apikey=35c2f377815f4d1dd3d1654065134f33))
Where's the " to indicate the end of the string? Try
Source = Json.Document(Web.Contents("financialmodelingprep.com/api/v3/financial-ratios/" & Ticker & "?apikey=35c2f377815f4d1dd3d1654065134f33" ) ),
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers