Our semantic search service allows you to search for any product, purchase, expenditure, or sector and get the Scope 3 emissions intensity. The search uses AI to find the best-matching sector in the Eora model. If you are already using Eora classification labels you can use the Eora sector labels as a search query and the system will return data for that sector.
This can be used with the REST Data API. It can be used easily in Google Sheets, Python, R, or almost any other language.
To get the correct Scope 3 intensity you must specify the country where the good or service was sourced from.
We've integrated a translation feature so you can search in English or any of 100 other langauges.
Query:
https://new.worldmrio.com/api/search/v1/?q=&query_lang=&country=&clientid=&output=
=IMPORTHTML("https://new.worldmrio.com/api/search/v1/?q=red+peppers&clientid=1234","table",1)
The IMPORTHTML function in Google Sheets can call this API:
IMPORTHTML(url, query, index) -
docsurl - See below for REST endpoint.query - For this endpoint this parameter should always be "table".index - The index, starting at 1, which identifies which table should be read. See the REST
endpoint description below for documentation on the tables available.
https://new.worldmrio.com/api/search/v1/?q=bananas&clientid=1234
https://new.worldmrio.com/api/search/v1/?q=bananas&clientid=1234&output=json
https://new.worldmrio.com/api/search/v1/?q=ホテル&clientid=1234&query_lang=jaBase GET URL: https://new.worldmrio.com/api/search/v1/.
None required.
q - a URL-encoded string containing the the product or sector,
with optional country, to search for. Examples:
bananas
or bananas%20from%20ecuador.
Tip: In Google Sheets the ENCODEURL()
can be used to URL-encode text.
output - Either json or html (default). See below for details.
clientid - Your clientid, or 1234 for demo mode.output=htmlIMPORTHTML function extracts tables from
an HTML document. This web service provides the following tables which can be extracted.
The third parameter to IMPORTHTML, the index parameter, specifies which of these tables will be read:
output=json
interface Scope3Result {
scope3: number, /* The scope 3 intensity, in Gg CO2eq/$. */
unit: string, /* The unit of the scope 3 intensity. */
id: number, /* The sector ID, as an index into the MRIO */
country: string, /* The country name for this intensity coefficient. */
sector: string /* The sector name for this intensity coefficient. */
}
To use this service you must provide a Client ID with an active license with the "multipliers" feature.
For testing you may use clientid=1234. In this case all numeric values will be 3.14.
If you do not provide a valid client ID the service will return a 403 error.