Site
Home / Forum / Developers / Is there a standard for strStatus?

Is there a standard for strStatus?


Posted: 09 Apr 2021 10:41
Pete


Posts: 5
Joined: 2021

Hi All,

I'm working on a project that uses the eventsday endpoint and figured out if a start time is not known, strTime and (sometimes) the time element of strTimestamp will be 00:00:00, and then the strStatus field will be 'Time to be defined' - but only about 2/3rds of the time. 'Match Cancelled' / 'Match Postponed' also seem to be regular entries for this field, and 'Not Started' or 'NS' - which I'm guessing mean the same thing, but I wouldn't have thought effect the start time? (or do they?). There are also a fair number of events that have strStatus = NULL, but strTime = 00:00:00 which I'm going to assume are because they are all-day events? And maybe some of these events genuinely do start at 00:00 UTC in their timezone.

How have others tackled this? Is there a way of being sure strTime = 00:00:00 means start time unknown, or all day, or whatever other reason?

Ta

Pete

Posted: 09 Apr 2021 22:27

zag


Posts: 3,511
Joined: 2020

Hi, couple of questions in there so I will attempt to answer

- No standard for strStatus sadly, since we support far too many sports and have a lot of imported data from different sources which use different strings.

- Regarding the time of 00:00, this is usually the default for events which do not have a time. Its hard when we have automated importers but also manual entries from users to know, but maybe it can be improved if I have a think about it some more.

Posted: 09 Apr 2021 22:27

zag


Posts: 3,511
Joined: 2020

You can also see the match status data items in this thread that we listed so far

https://www.thesportsdb.com/forum_topic.php?t=5236


Who is Online?

In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm

About Us

Discussion forum for TheSportsDB.com site and related topics

Rules

- Be Polite
- Respect other users
- Always post log files with issues
- Try to be helpful
- No Piracy discussion

Showing 0 to 3 (Total: 3)