Need query parameter format to call REST API with date condition
Summary
Call fscmRestApi/resources/11.13.18.05/supplyPlans/:planid/child/PlanningSupplies with query parameter on ScheduleDueDate fall in next 30 daysContent
HI,
Can you please advice on how to pass date condition to a REST API call in query parameter to fetch where schedule due date fall in next 30 days. Like ScheduleDueDate <= sysdate - 30. if i use sysdate - 30 i am getting an error message like wrong format.
Kindly advice.
REST API call URL: https://hostname.oraclecloud.com/fscmRestApi/resources/11.13.18.05/supplyPlans/:planid/child/PlanningSupplies?q=SuggestedDueDate lt sysdate - 10;&offset=5000&limit=1000&totalResults=true
Response:
An instance of type java.sql.Date cannot be created from string lt sysdate -
Tagged:
0