I am building a replica using REST api to get at hosted features on ArcOnline. At the moment I am not considering attachments and the output I am expecting is a SQLite geodatabase that will be downloaded
I am struggling on creating a layer query to take rows with a date greater than a certain date and I am getting an "invalid parameter" error. Since the feature classes in the service are rather large, I need to filter them down prior to download. For a check, I am able to substitute the date condition with say "objected<300" and everything runs fine. It appears my issue is the formatting of the date condition of which I can't find anywhere.
I've tried date'2018-04-04 12:05:45', date'04/04/2018 12:05:45', date'04/04/2018 12:05:45PM' and others...
Any help would be appreciated.
The JSON return is