Forum Discussion
wkeicher
6 years agoHelper III
API Calls with Parameters = need help
Need Help with Invoking API Call with Paramaters. The API call is as follows. I am passing in the paramater (newsdate) https://api.sportsdata.io/v3/nba/scores/json/NewsByDate/2020-MAR-08 ...
- 6 years ago
I actually figured it out. I had to declare the (newsdate as text) =>
Source = Json.Document(Web.Contents(Text.From("https://api.sportsdata.io/v3/nba/scores/json/NewsByDate/"&(newsdate)&"
Thanks for your guidance.
v-yuta-msft
6 years agoCommunity Support
wkeicher ,
You need to convert date to text type like below:
Text.From(newsdate)
Or use query parameter instead and try again, please refer to:
https://docs.microsoft.com/en-us/power-query/power-query-query-parameters
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.