topic Re: Python API query string in ArcGIS API for Python Questions

Python API query string

GrantHaynes — Mon, 11 Nov 2019 13:44:44 GMT

I'm trying to use the Python API in a regularly scheduled script to query data from a table, I'd like to query the weeks data for processing. I can query any non date field just fine, but whenever I try to query a date field I get either a 'where' parameter invalid or "Unable to perform query. Please check your parameters." Below is the code, I have also tried numerous different date formats, but to no avail.

timeDifference = datetime.datetime.now() - datetime.timedelta(days = 7)

queryString1 = 'Survey_Start>' + str(timeDifference)

query1Result = table.query(where=queryString1, out_fields='Project')

Re: Python API query string

JohannesBierer — Mon, 11 Nov 2019 14:05:30 GMT

And if you use .format() ?

queryString1 = 'Survey_Start>{}'.format(str(timeDifference))

Re: Python API query string

DanPatterson_Retired — Sun, 12 Dec 2021 08:53:48 GMT

You don't have to str objects prior to using python 'format' or f strings

"{} - {} = {} ".format(2, 1, 2-1)

'2 - 1 = 1 '‍‍‍

Re: Python API query string

GrantHaynes — Mon, 11 Nov 2019 15:15:31 GMT

It still fails

timeDifference = datetime.datetime.now() - datetime.timedelta(days = 7)

queryString1 = 'Survey_Start>{}'.format(str(timeDifference))

query1Result = table.query(where=queryString1, out_fields='Project')

message

'where' parameter is invalid

Re: Python API query string

JohannesBierer — Mon, 11 Nov 2019 15:35:20 GMT

What happens if you print out queryString1, maybe it doesn't fit to Survey_Start field?

Is this helpful?

4 Examples to convert Python datetime to string

Re: Python API query string

GrantHaynes — Mon, 11 Nov 2019 16:47:03 GMT

I figured it out, the query string needs the dates in a very specific format, thanks for helping out.

# time difference for querying

timeDifference = datetime.datetime.now() - datetime.timedelta(days = 7)

# create the query string for the first query

queryString1 = 'Survey_Start > date \'{}\''.format(timeDifference.strftime('%Y/%m/%d %H:%M:%S'))

Re: Python API query string

J_R_Matchett — Mon, 11 Nov 2019 23:16:09 GMT

Here's a useful post on the various date/time query formats for feature services: Querying Feature Services: Date-Time Queries