---
sourceDocument: Xanadu API Reference
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/api-reference

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# Data Retrieval API

# Data Retrieval API {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Data Retrieval API method summaries and descriptions.
{#r_DataRetrievalAPI__id_gsh_xqt_3xb__entry__2}

| Method Summary | Description |
|-|-|
| [getKeys](https://servicenow-prod.fluidtopics.net/TwwR8WSM4nWfSkU5m5oZXA "Query the targeted table by example values and return a comma delimited sys_id list.") | Query the targeted table by example values and return a comma delimited `sys_id` list. |
| [getRecords](https://servicenow-prod.fluidtopics.net/vU542w8i0gI92wMPjG3Fcw "Query the targeted table by example values and return all matching records and their fields.") | Query the targeted table by example values and return all matching records and their fields. |
| get | Query a single record from the targeted table by `sys_id` and return the record and its fields. |
| [aggregate](https://servicenow-prod.fluidtopics.net/7aRKeAz_CQtdMuUSgS6uuw "Query a table using an aggregate function including SUM, COUNT, MIN, MAX, LAST, and AVG.") | Query using and aggregate functions SUM, COUNT MIN, MAX, LAST, and AVG. To enable the aggregate functions, activate the Aggregate Web Service Plugin. |
[Table 1. Data Retrieval API]

{#r_DataRetrievalAPI__id_gsh_xqt_3xb}
* **[getKeys](https://servicenow-prod.fluidtopics.net/TwwR8WSM4nWfSkU5m5oZXA)**   
  Query the targeted table by example values and return a comma delimited `sys_id` list.
* **[getRecords](https://servicenow-prod.fluidtopics.net/vU542w8i0gI92wMPjG3Fcw)**   
  Query the targeted table by example values and return all matching records and their fields.
* **[get](https://servicenow-prod.fluidtopics.net/t~wCoH8D7xehQDuCYDsz5w)**   
  Query a single record from the targeted table by `sys_id` and return the record and its fields.
* **[aggregate](https://servicenow-prod.fluidtopics.net/7aRKeAz_CQtdMuUSgS6uuw)**   
  Query a table using an aggregate function including SUM, COUNT, MIN, MAX, LAST, and AVG.

**Related reference**   

* [Data Modification API](https://servicenow-prod.fluidtopics.net/Sp6np4pwn2KhzWGpcxvAdw "Data Modification API method summaries and descriptions.")