NHL issues

18 views
Skip to first unread message

John Currey

unread,
Sep 29, 2022, 5:42:35 PMSep 29
to SDQL API
Hi,

I'm trying to get the NHL going. I expected last year's stuff to just work as it did through the Stanley Cup. However, the API struggles with several variables, most notably, goals. 

This query shows the issue:
  • date,goals@team='Maple Leafs'

This, as expected, works fine:

Thanks.


Joe Meyer

unread,
Oct 2, 2022, 2:08:21 AMOct 2
to sdq...@googlegroups.com
Hi John and SDQL API Friends,

I do not see any errors.
Can you please clarify?

Best regards,

Joe Meyer
Sports Database LLC

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/157b7d2f-0a9d-4106-983a-0e6341676b10n%40googlegroups.com.

John Currey

unread,
Oct 2, 2022, 11:30:32 AMOct 2
to SDQL API
If I enter this query it works as expected.
  • date@team=Devils
If I add "goals" or "saves" (or several other valid parameters) to the query, it fails. For example:
  • date,goals@team=Devils
https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cgoals%40team%3DDevils&submit=++S+D+Q+L+%21++

This query was working for sure as of the last game of the 2021 Stanley Cup. The only thing I did since then was I added the 2022 schedules. I removed the 2022 games this morning and it still fails. The UI returns "the parameter reference `goals not found uniquely in []` returned no parameters"

Thanks. 

Joe Meyer

unread,
Oct 2, 2022, 3:55:59 PMOct 2
to sdq...@googlegroups.com
John,

thanks for the clarification. 
I see that the query works when logged in as guest and fails why logged in with your credentials.
I'll post when patched.

Best regards,

Joe Meyer
Sports Database LLC

Joe Meyer

unread,
Oct 2, 2022, 4:17:40 PMOct 2
to sdq...@googlegroups.com
John,

I see that my player-level parameter `goals` was causing your query to fail.
I temporarily removed my NHL data so that your query now works.
I'll post here again when the underlying bug is fixed.

Best regards,

Joe Meyer
Sports Database LLC

Reply all
Reply to author
Forward
0 new messages