Pro Tips of the Month - API Datasets - July 2024

POSTED BY Khai Ahmed Salma | 10 Jul 2024 |

What are APIs and How Can You Use Them?

OneGMS collects a variety of data from the information entered into the system. This data can be used for many purposes, such as creating Annual Reports or to analyze financial information recorded in OneGMS. To facilitate this, the OneGMS team is offering OCHA staff the ability to access this data according to their needs, in the form of API Datasets. Some of the datasets are public and can be extracted by anyone and some are secured for limited use.  

What Are API Datasets Used For?

API datasets can be used by many stakeholders for diverse purposes. These datasets are a shortcut of sorts, providing preformatted data for easy use and analysis.

Examples of OneGMS API Datasets

  • Refund Query: This dataset is particularly relevant for our finance teams both in-country and at HQ level, as well as for the BoA when needed. It extracts data on refunds per fund and per project, offering a comprehensive overview of refund statuses, amounts, and more.
  • Organizations Detailed Master: This unique dataset provides a detailed overview of all organizations registered in OneGMS, including their risk level, eligibility, and DD status. Most importantly, it highlights the organizations' leadership and focus markers such as WLO, WRO, OPDs, and YLO.
  • Annual Report Extracts: These datasets are tailored to support the drafting of annual reports but can also be used in many other contexts due to their comprehensiveness. Some examples include:
    • Lists of sub-implementing partners
    • Cash Tracking (OneGMS projects only)
    • Beneficiaries targeted and reached by beneficiary type and project.

Did you know? Once the API dataset is extracted, you can build your own pivot tables to adjust to your needs, and the data will stay up to date and refreshed if the source is still connected.

A detailed guide on how to access the APIs and extract the data into Excel can be found here: https://gms.unocha.org/en/content/how-extract-api-data-excel-sheet. If you encounter any issues, have questions, or need credentials for the secure APIs, please do not hesitate to reach out to GMS Support at gms-support@un.org.