Oracle CRM On Demand REST API Developer's Guide > Using the Oracle CRM On Demand REST API > Querying a Collection Resource >

Sample Query Request and Response

The following is a sample query REST API request and response. In this example, this query searches for an Accounts resource where the CustomCurrency0 field has a 10000.50 value.

• URL: URL https://<host>/OnDemand/user/Rest/latest/Accounts?fields=AccountName,CustomCurrency0&q=CustomCurrency0=10000.50
• Response body:

{
   "Account": [
     {
        "AccountName": "test",
        "CustomCurrency0": {
           "type": "currency",
           "value": "10000.50",
           "Modifier": "USD"
        },
        "links": {
           "self": {
             "rel": "self",
             "href": "/OnDemand/user/Rest/Account/1QA2-22D3XZ"
           },
           "canonical": {
             "rel": "canonical",
             "href": "/OnDemand/user/Rest/Account/1QA2-22D3XZ"
           },
        }
     }
   ],
     "links": {
        "self": {
           "rel": "self",
           "href": "/OnDemand/user/Rest/Account"
       }
      },
      "_contextInfo": {
        "limit": 100,
        "offset": 0
   }
}