Data issue

63 views
Skip to first unread message

John Currey

unread,
Sep 6, 2021, 8:55:46 AM9/6/21
to SDQL API
Hi, 

I accidentally added a game where t:team and o:team are a list, and it won't let me remove it. Is there any way I can get it out?

Sep6.JPG
Thanks.

Joe Meyer

unread,
Sep 6, 2021, 10:39:45 AM9/6/21
to sdq...@googlegroups.com
John,

you can remove all games for a date by setting "t:team" to the wildcard character "*". 

Like this:
    d = { "date": 20210906, "t:team": "*"}
    h = {'token':jcurrey_TOKEN,'client':'jcurrey','league':'NFL','action':'remove'}
    ret = requests.post(url,json=d, headers=h)

Best regards,

Joe Meyer


--

---
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/7a6dc81c-cb3a-47b1-8ffe-69052c9c947cn%40googlegroups.com.

John Currey

unread,
Sep 6, 2021, 11:20:34 AM9/6/21
to SDQL API
Oh, sweet! It worked like a charm, thanks!

John Currey

unread,
Oct 18, 2021, 5:52:12 PM10/18/21
to SDQL API
I'm trying to remove the only game on 20211007 without success. It's the Thursday Night game between the Rams and the Seahawks. I inadvertently entered the Rams as both the home and away teams. 

Here's the code I think should work that I copied from above:

d = { "date": 20211007, "t:team": "*"}
h = {'token':token,'client':'jcurrey','league':'NFL','action':'remove'}
ret = requests.post(remove_url,json=d, headers=h)

This is what the API has to say:
  • ret: 200 {"error": "team needs to be made of letters, spaces, underscores and dots. You have: *"}

Joe Meyer

unread,
Oct 19, 2021, 9:38:18 AM10/19/21
to sdq...@googlegroups.com
John,

I believe this is patched.
Please try that request again.

best,

Joe Meyer

John Currey

unread,
Oct 19, 2021, 10:12:56 AM10/19/21
to SDQL API
All is now good! Thanks Joe!
Reply all
Reply to author
Forward
0 new messages