How do the Object and Description table and JSON Output of commodity prices API made by Finnworlds function?

In this article, I will provide a detailed explanation of the object table and JSON output of Finnworld's commodity prices API. As a programmer, it is important to have a clear understanding of the data formats being used, and how they are structured. The object table is a widely-used data structure that presents information in a tabular format, with each row representing a distinct entity or object, and each column representing a specific attribute of that entity. On the other hand, JSON (JavaScript Object Notation) is a lightweight data interchange format that is easy to read and write, and is commonly used for transmitting data between a server and web application. In this article, I will focus specifically on how Finnworld's commodity prices API uses the object table and JSON output to provide data to its users.

API Object and Description Table

1. category: This object represents the category of the commodity. For example, the category could be "agricultural products," "metals," or "energy."

2. commodity_name: This object represents the name of the commodity. For example, the name could be "corn," "gold," or "crude oil."

3. commodity_unit: This object represents the unit of measurement related to the commodity. For example, the unit could be "bushels" for corn, "ounces" for gold, or "barrels" for crude oil.

4. commodity_price: This object represents the price of the commodity at the last update. The price could be in any currency, such as USD or EUR.

5. price_change_day: This object represents the price change of the commodity since the last trading day. The change could be positive or negative and could be represented in a specific currency or as a percentage.

6. percentage_day: This object represents the percentage change of the commodity price since the last trading day. The percentage change could be positive or negative.

7. percentage_week: This object represents the percentage change of the commodity price since the last trading week. The percentage change could be positive or negative.

8. percentage_month: This object represents the percentage change of the commodity price since the last trading month. The percentage change could be positive or negative.

9. percentage_year: This object represents the YoY (year-over-year) percentage change of the commodity price. The YoY percentage change could be positive or negative.

10. quarterX_YY: This object represents the forecast of the commodity for future quarters. The forecast could be represented in any currency, such as USD or EUR.

11. date: This object represents the date and time that the system updated the commodity price. The date and time could be represented in any timezone or format.

The information in the table provides valuable insights into the commodity market and helps traders, investors, and businesses make informed decisions about buying and selling commodities. The table provides information on the current and historical prices of commodities, as well as the percentage change in prices over different time periods. This information is essential for traders who need to understand the market trends and make informed decisions about when to buy and sell commodities. Additionally, businesses that rely on commodities as raw materials can use this information to manage their supply chain and make purchasing decisions based on market trends. Overall, the information in the table is critical for anyone who wants to understand the commodity market and make informed decisions based on market trends and price fluctuations.

Explaining the JSON output

The JSON output is a structured data format that contains information on commodity prices for two commodities, Brent and Coal. The output is divided into two main sections, "status" and "result". The "status" section indicates the status of the API response, with a code of 200 indicating success, a message of "OK", and an empty "details" field. The "result" section contains the actual data, with the "output" field providing an array of objects that represent each commodity's information. The objects contain the category, name, unit, price, and percentage change of each commodity. Additionally, the objects also provide quarterly forecasts of the commodities and the date when the information was last updated. The information is useful for traders, investors, and businesses that need up-to-date and accurate information on commodity prices to make informed decisions.

{
"status": {
"code": 200,
"message": "OK",
"details": ""
},
"result": {
"output": [
{
"category": "energy",
"commodity_name": "brent",
"commodity_unit": "usd/bbl",
"commodity_price": "90.398",
"price_change_day": "1.222",
"percentage_day": "-1.33%",
"percentage_week": "-4.13%",
"percentage_month": "-0.29%",
"percentage_year": "6.25%",
"quarter4_22": "104.512",
"quarter1_23": "105.802",
"quarter2_23": "95.713",
"quarter3_23": "99.325",
"date": "2022:10:18"
},
{
"category": "energy",
"commodity_name": "coal",
"commodity_unit": "usd/t",
"commodity_price": "392.15",
"price_change_day": "0.35",
"percentage_day": "-0.09%",
"percentage_week": "1.46%",
"percentage_month": "-10.68%",
"percentage_year": "63.84%",
"quarter4_22": "462.47",
"quarter1_23": "500.994",
"quarter2_23": "419.46",
"quarter3_23": "446.338",
"date": "2022:10:17"
},
}
]
}
}

Concluding

In this article today, we discussed the object table and JSON output formats used in Finnworld's commodity prices API. We converted an HTML table into a readable list and described each object in detail. We also examined a JSON output that contained information on commodity prices for Brent and Coal. We discussed how this information could be useful for traders, investors, and businesses looking to make informed decisions. Overall, this conversation provided insights into the technical aspects of Finnworld's commodity prices API and highlighted the importance of accurate and up-to-date commodity price information.

Footnote

You can request access to Finnworld's commodity prices API through the third-party data marketplace of Worldindata. Worldindata is a reputable data provider that offers a wide range of datasets and APIs from various sources, including Finnworld. To access Finnworld's commodity prices API through Worldindata, you will need to create an account with Worldindata, browse their marketplace to find Finnworld's API, and request access. Then, you will be provided with an API key that you can use to access the data. Worldindata provides a convenient and reliable way to access Finnworld's commodity prices API for those looking for up-to-date and accurate commodity price information.

###