Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone. I am trying to pull data from an external website into my excel file and I am getting a weird error message ->
Expression.SyntaxError: Token Comma expected.
Below is my below code and would really appreciate a new set of eyes on it to help identify where the error is coming from. it looks like it may be on line 5 or 6. Thanks!
let
Ticker= Excel.CurrentWorkbook(){[Name="Table1"]}[Content]{0}[Ticker1],
Source = Json.Document(Web.Contents("financialmodelingprep.com/api/v3/financial-ratios/" & Ticker & "?apikey=35c2f377815f4d1dd3d1654065134f33)),
ratios = Source[ratios],
#"Converted to Table" = Table.FromList(ratios, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"date", "investmentValuationRatios", "profitabilityIndicatorRatios", "operatingPerformanceRatios", "liquidityMeasurementRatios", "debtRatios", "cashFlowIndicatorRatios"}, {"date", "investmentValuationRatios", "profitabilityIndicatorRatios", "operatingPerformanceRatios", "liquidityMeasurementRatios", "debtRatios", "cashFlowIndicatorRatios"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"date", type date}, {"investmentValuationRatios", type any}, {"profitabilityIndicatorRatios", type any}, {"operatingPerformanceRatios", type any}, {"liquidityMeasurementRatios", type any}, {"debtRatios", type any}, {"cashFlowIndicatorRatios", type any}})
in
#"Changed Type"
Solved! Go to Solution.
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
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