Import OData In Excel - Udenrigsministeriet/iati-api GitHub Wiki

It is possible to import OData from the IATI API directly into Excel. This short guide shows how to do this.

1. Import Data From OData Feed

Select Data > From Other Sources > From OData Data Feed

1_import_odata_data_feed

2. Provide Address For OData Endpoint

Enter the v2 address for the IATI API OData endpoint The current production endpoint is: http://iati.um.dk/api/v2/ODataService.svc

See the Endpoints page for a list of all endpoints

2_provide_address_odata_data_feed

3. Select Tables To Download

Activities tabellen er så stor, at Excel normalt ikke kan hente den. På nogle kraftige desktop computere er det lykkedes, men det har taget >15min at hente og åbne den.

Activity_Budget og Activity_Transactions er også store, og kan give problemer på nogen computere og med ældre versioner af Excel.

3_select_tables_to_download

And press Ok to import data

3_1_select_tables_to_download

4. Create Pivot Table In Excel

4_create_pivot_table_excel