using the API to access OECD microdata

[kprior91]

Hello
I would very much like to access Donor Agency information in the CRS1 dataset using the OECD package via the OECD API.
Using EU Institutions as an example, if I go onto the OECD website and download disbursement data for EU Institutions there is a column 'Donor Agency' that is not included if I pull EU Institutions using the API (code 918). Is there a way to also include the Donor Agency information in the OECD package?
Many thanks

[luifrancgom]

Hello kprior91,

I acknowledge that this update might come with some delay. I navigated to the OECD website and successfully retrieved the disbursement data related to EU Institutions. In order to streamline the management of this substantial dataset, I opted for the Generate Delimited Text (CSV) file export feature. By employing this approach, I gained access to the entire array of variables at our disposal. Additionally, I applied a targeted query to narrow down the data points. Given the expansive nature of the complete dataset, our primary focus lies on the columns rather than the rows, enabling us to concentrate our analysis effectively. Here is the query for reference:

https://stats.oecd.org/restsdmx/sdmx.ashx/GetData/CRS1/918.10100.1000.100+11+13+19+14+30.100.A+D.112.100/all?startTime=2021&endTime=2021.

Upon executing this query, I obtained a CSV file named CRS1_06082023040436762.csv. However I couldn't locate a column labeled Donor Agency. Could you please upload the file you referred to with the Donor Agency column and include in extreme detail how you obtain this file from the OECD website?