Hello Team,
Could you help me with the following question.
I cannot filter Customers by date and time.
Example:
http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$top=1000&$filter=DateLastMaintained gt 2000-01-01T01:08:35 or DateOfLastActivity gt 2000-01-01T01:08:35
Response:
400 Bad Request: [{
“error”: {
“code”: “InvalidParameters”,
“message”: {
“lang”: “en-US”,
“value”: “The DateTimeOffset text ‘2000-01-01T01:08:35’ should be in format ’yyyy-mm-ddThh:mm:ss(’.’s+)?(zzzzzz)?' and each field value is within valid range.”
}
}
}]
Could you help me with how I should change a request to eliminate the error?
268
260