The “open_hours” column in the "safegraph-core" table only returns None values using Place API

Questions & Help
,
1

I was testing out the Place API, and found that some of the columns have only “None” values.
The “open_hours” column is one example. Other columns that I’ve tested so far include “top_categories”, and “sub_categories”.
I remember the old datasets that I downloaded through Data Catalog contain a decent amount of meaningful values for all these columns. So I’m thinking maybe there is something wrong with how the API is set-up.

Can someone verify?

2

Hey @Ruilin_Chen_Boston_College - can you share the queries you’re using? Will help us look further into the issue. Separately, based on recent feedback, we pushed back the Catalog deprecation until Spring 2022. If you need additional time on the Data Catalog, feel free to continue using.

3

Below is how the query is formatted.
I know the Data Catalog is up and running, but I like the API approach much more. Looking forward to the transition!


def get_query_for_filter_by_index(count=10, end_cursor=''):
    query_string = """
    query {
        search(filter: {
            naics_code: 721110
            address: {
                region: "CA",
                iso_country_code: "US"
            }
        }){
            places {
                results(first: %d, after: "%s") {
                    pageInfo { hasNextPage, endCursor}
                    edges {
                        node {
                            placekey
                            safegraph_core {
                                                location_name
                                                street_address
                                                naics_code
                                                top_category
                                                sub_category
                                                category_tags
                                                latitude
                                                longitude
                                                city
                                                region
                                                postal_code
                                                open_hours
                            }
                        }
                    }
                }
            }
        }
    }
    """ % (count, end_cursor)
    return query_string