Hello Everyone
We are building a new web application to allow our users to enter resource usage against Work orders using REST service, we are facing multiple issues, really appreciate your help / input
Issue # 1
Filter option not working with DateTime Fields, for example I have to extract records where lastModifiedDateTime is equal “2001-08-27” or NUll
As per documentation, applying this formula but its generating 500 error Msg.
?Filter=[{property:lastModifiedDateTime,operator:GreaterThan,value:{Date:{Year:{Add:-5,Day:1,Month:1}}}}]
It is also not accepting as string and generating same error msg.
?Filter= [{property:lastModifiedDateTime,value:'2001-08-27T12:16:38.0000000-04:00'}]
"data": [
{
"contractId": "ROAD REHAB",
"section": "A.CONCRETE",
"subsection": "02.A",
"reference": " ",
"description": "REMOVE EXISTING CONC. SIDEWALK",
"lastModifiedBy": "OHALLORA",
"lastModifiedDateTime": "2001-08-27T12:16:38.0000000-04:00",
"id": 1314
}
}
Issue # 2.
Any Idea how to use IN, Contains and Like operator for example I like to extract data where contractId In (“xxx”,”xxx”)
Issue # 3.
How to get selected property data for example, from data object I like to get 2 fields instead of complete data Object like “section and subsection”
/select=[{section,subsection}] not working?
Thanks,
Amir
