Hi @David
Thanks. I see my filter can be written;
{“glue”:“and”,“conditions”:[{“glue”:“and”,“conditions”: [{“object”:“organization”,“field_id”:“3997”,“operator”:"<",“value”:“2018-06-25 12:00:00”},{“object”:“organization”,“field_id”:“3998”,“operator”:">",“value”:“2018-06-25 12:00:00”}]},{“glue”:“or”,“conditions”:[]}]}
Any tips on the PUT to write filter updates from vba?
I’m using;
strURL = strURL & “/filters/{25}?api_token=” & strToken
'Set filter
With CreateObject(“MSXML2.XMLHTTP”)
.Open “PUT”, strURL, False
.setRequestHeader “Content-Type”, “application/json”
.Send (strSql)
txt = .responseText
End With
{“status”:false,“error”:“Unknown method .”}