rest API Filter Invoices using trandate/Createddate
I am trying to get the invoices based on trandate or created date using “q” parameter in rest api url as below.
url = “https://xxxxxxx.suitetalk.api.netsuite.com/services/rest/record/v1/invoice?q=trandate+ON+2/15/2022”
performing get method on above url results in below error.
{'type': 'https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1', 'title': 'Bad Request', 'status': 400, 'o:errorDetails': [{'detail': 'Invalid search query. Provide a valid search query.', 'o:errorQueryParam': 'q', 'o:errorCode': 'INVALID_PARAMETER'}]} please someone help me to achieve what I wanted here. I am not able to figure out where am I getting this wrong.
Try this https://xxxxxxx.suitetalk.api.netsuite.com/services/rest/record/v1/invoice?q=createdDate ON “2/15/2022”
Also check your date format to match the format on the invoice.
Best!