Retrieve receivables invoices from REST API within date range
Summary:
We are trying to retrieve all the receivables invoices within a creation date range.
Content (please ensure you mask any confidential information):
However, when using the REST API below we are getting an error message:
Error message: An instance of type java.sql.Timestamp cannot be created from string BETWEEN '1999-01-01T08: 30: 40'. The string value must be in format YYYY-MM-DDTHH:MI:SS.sss+hh:mm.
Version (include the version you are using, if applicable):
23C
Code Snippet (add any code snippets that support your topic, if applicable):
REST API: {ORACLE ERP}/fscmRestApi/resources/11.13.18.05/receivablesInvoices?offset=0&limit=10&finder=invoiceSearch;BillToCustomerNumber=1659812492620001,TransactionType="FR1-F Vente de Packs"&orderBy=TransactionDate:desc&onlyData=true&orderBy=TransactionDate:des&onlyData=true&totalResults=true&q=CreationDate BETWEEN '1999-01-01T08:30:40' AND '1999-12-01T08:30:40'