API Explorer

IFC Summary Consolidated Statement of Comprehensive Income

Data as of FY25 Q1 – Uploaded on 11/15/2024

Provides summary consolidated stat.ement of comprehensive income from quarterly financial statements

Important Note

We recommend users to adopt API service option only for datasets exceeding a million records. For other datasets, kindly use the JSON link available on the "Actions and Tools" section which enables extraction of all the records at once.

Parameters

Parameter	Description	API FIELD NAME	Data Type
Organization	Identifies the WBG organization to which the data is associated.	organization	STRING
Line Item	Represents the individual components of the Income Statement as published.	line_item	STRING
Fiscal Year	The fiscal year begins on July 1st of the previous year and runs through June 30th of the designated year.	fiscal_year	STRING
Amount (US$, Millions)	Amount in Million US Dollars.	amount_us__millions	NUMBER
Resource ID	ID of the associated Resource		STRING
Select	Fields that required E.g (fiscal_year\|supplier_country\|total_amount)		STRING
Top	Number of records to fetch		NUMBER
Skip	Skip the records from the ascending order		NUMBER

Please Note:

This API will support up to a maximum of 1000 records per request / page.
The date format for all date fields should be DD-MMM-YYYY.
Selection will allow for multiple parameters E.g (Country = India|Afghanistan).
The filters for blank and non-blank should be IS NULL and IS NOT NULL E.g (Country = IS NULL, Country = IS NOT NULL)

Dataset Identifier

DS00997

Data Provided By

World Bank Group

Owner

Finances One

Date Created

Dec 16, 2014

Last Updated

Nov 15, 2024

Licensing and Attribution

License

Creative Commons Attribution 4.0 International

Additional Information

Type

Time Series

Source

World Bank Group

Periodicity

Quarter

Granularity

Other

Provenance

official

Update Frequency

Quarterly

Range Column

fiscal_year

General Access Options

Query tool,API,Mobile App,Bulk download

Language

English

Update Schedule

Within 40 days after end of the quarter

Data As Of

FY25 Q1 – Uploaded on 11/15/2024

Data Last Updated

Nov 15, 2024

Metadata Last Updated

Nov 15, 2024

Scope

Institution

IFC

Topics

CategoryFinancial Reporting

Tags

MD&A financial statements

What's in this Dataset?

Rows

Columns

JavaScript makes it super simple to fetch from an API endpoint.

fetch('https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00997&resourceId=RS00927&top=100&type=json')
    .then(response => {
        if (!response.ok) {
            throw new Error('');
        }
        return response.json();
    })
    .then(data => {
        // Do something with the response data
        // console.log(data);
    })
    .catch(error => {
        console.error('Error:', error);
    });

Python for easily work with data.

import requests
url = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00997&resourceId=RS00927&top=100&type=json'
try:
    response = requests.get(url)
    response.raise_for_status()  # Raise an exception for 4XX and 5XX status codes
    data = response.json()  # Parse the JSON response
    print(data)  # Print the response data
except requests.RequestException as e:
    print(f'Error: {e}')

PowerShell code to extract data.

$url = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00997&resourceId=RS00927&top=100&type=json'
try {
    $response = Invoke-RestMethod -Uri $url -Method Get
    # Print the response
    Write-Output $response
} catch {
    # Print error message if request fails
    Write-Error "Error: $_"
}

The following snippet brings data into your application.

require 'net/http'
url = URI('https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00997&resourceId=RS00927&top=100&type=json')
begin
response = Net::HTTP.get_response(url)
if response.is_a?(Net::HTTPSuccess)
    puts response.body
else
    puts "Error: #{response.code} - #{response.message}"
end
rescue StandardError => e
puts "Error: #{e.message}"
end

Below code that makes usage with .NET more natural.

using System;
using System.Net.Http;
using System.Threading.Tasks;
class Program
{
    static async Task Main(string[] args)
    {
        var response = await new HttpClient().GetStringAsync("https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00997&resourceId=RS00927&top=100&type=json");
        Console.WriteLine(response);
    }
}

JAVA for easily work with data.

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
public class Main {
    public static void main(String[] args) throws Exception {
        URL url = new URL("https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00997&resourceId=RS00927&top=100&type=json");
        HttpURLConnection connection = (HttpURLConnection) url.openConnection();
        connection.setRequestMethod("GET");
        BufferedReader reader = new BufferedReader(new InputStreamReader(connection.getInputStream()));
        String line;
        StringBuffer response = new StringBuffer();
        while ((line = reader.readLine()) != null) {
            response.append(line);
        }
        reader.close();
        System.out.println(response.toString());
    }
}

The following snippet brings data into your application.

shell "curl -X GET https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00997&resourceId=RS00927&top=100&type=json"

PHP code to brings the data.

<?php
// Specify the URL you want to send the GET request to
$url = "https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00997&resourceId=RS00927&top=100&type=json";
// Initialize cURL session
$curl = curl_init();
// Set the cURL options
curl_setopt($curl, CURLOPT_URL, $url);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
// Execute cURL session
$response = curl_exec($curl);
// Close cURL session
curl_close($curl);
// Print the response
echo $response;
?>

Copy and paste the following to import this dataset into Stata.

clear
. import delimited "https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00997&resourceId=RS00927&top=100&type=json"

API Explorer

IFC Summary Consolidated Statement of Comprehensive Income

Please Note:

Request URL

Response Body

Response Code