CakePHP URL - specify a named filed as "null" -
i working on app connects 3rd party cakephp api system. here sample output of url:
https://<server>/api/events.json
output:
{"events":[{"event":{"id":"11902","monitorid":"5","name":"new event","cause":"continuous","starttime":"2016-08-15 17:10:00","endtime":null,"width":"2304","height":"1296","length":"319.81","frames":"1600","alarmframes":"0","totscore":"0","avgscore":"0","maxscore":"0","archived":"0","videoed":"0","uploaded":"0","emailed":"0","messaged":"0","executed":"0","notes":""},"thumbdata":""},{"event":{"id":"11903","monitorid":"7","name":"new event","cause":"continuous","starttime":"2016-08-15 17:10:00","endtime":"2016-08-15 17:11:00" ,"width":"1280","height":"720","length":"316.73","frames":"1900","alarmframes":"0","totscore":"0","avgscore":"0","maxscore":"0","archived":"0","videoed":"0","uploaded":"0","emailed":"0","messaged":"0","executed":"0","notes":""},"thumbdata":""}
note in cases, endtime
field null , in cases not. want craft url returns fields endtime null.
the api allows named filters. example:
https://<server>/api/events/index/endtime >=: 2016-11-07 10:10:10.json
accurately returns values endtime > value specified.
how 1 ask endtime = null?
i tried:
https://<server>/api/events/index/endtime =: null.json
that doesn't work (also tried quotes)
thanks
Comments
Post a Comment