NHL issues

[John Currey]

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'

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cgoals%40team%3D%27Maple+Leafs%27&submit=++S+D+Q+L+%21++

This, as expected, works fine:

• date,line,total@team='Maple Leafs'

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cline%2Ctotal%40team%3D%27Maple+Leafs%27&submit=++S+D+Q+L+%21++

Thanks.

[Joe Meyer]

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]

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]

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

To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/8177bf6d-94ea-4db4-a066-94bf800bd191n%40googlegroups.com.

[Joe Meyer]

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