Hi,
I am trying to pull data out based on the lastModifiedDate field using the REST API. I am successful on getting this to work for records such as salesOrders but when trying to do the same for supportCase records, I am getting the following response:
'{"type":"https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1","title":"Bad Request","status":400,"o:errorDetails":[{"detail":"Unknown field name \'lastMessageDate\' in the search query. The field does not exist on this record type.","o:errorQueryParam":"q","o:errorCode":"NONEXISTENT_FIELD"}]}\n'
I can confirm that the field does exist based on previous data extracts.
Here's a sample of the API call request:
url = 'https://<instance>.suitetalk.api.netsuite.com/services/rest/record/v1/supportCase'
headers = {
"Content-Type": "application/json",
"Accept": "application/json"
}
params = {'q': 'lastModifiedDate ON_OR_AFTER "21/02/2025"'}
response = requests.get(url, headers=headers, auth=auth, params=params)