Oracle Rest Data Services (ORDS) (MOSC)

MOSC Banner

Retrieve receivables invoices from REST API within date range

edited Nov 22, 2023 2:38PM in Oracle Rest Data Services (ORDS) (MOSC) 1 commentAnswered

Hello,

We are trying to retrieve all the receivables invoices within a creation date range.

However, when using the REST API below we are getting an error message:

REST API:/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'

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center