All IATI data is provided by publishers in XML format. The Datastore is able to automatically convert the published data into two other formats (JSON and CSV). Each of these has a range of benefits and limitations.
By default, data is filtered and output based on activities.
The Datastore returns the original activity XML as published. This is enhanced with metadata specifying the version that individual activities were published at, as well as details of the query result.
The Datastore will convert the published XML to a JSON format. All of the originally published information is present in this alternative format. The same metadata that is given in the XML output is available in the JSON output.
The Datastore will convert the published XML data into CSV format. Only a subset of published data is present. This format can be used to analyse information using spreadsheet software such as Microsoft Excel or Libreoffice Calc.
Rows in a CSV file may represent individual activities, budgets or transactions depending on the output format that is selected. Each of these may be expanded by sector or country so that percentage splits may be analysed.