ClimateProducts
Returns Climate products available for carbon removal, including pricing, delivery year, and supplier details.
View-Specific Information
SELECT
The add-in uses the Stripe API to filter the results by the following columns and operators:
| Column | Supported Operators |
| Id | = |
The rest of the filter is executed client-side within the add-in.
You can select from ClimateProducts with the following queries:
SELECT * FROM ClimateProducts
SELECT * FROM ClimateProducts WHERE Id = 'climpr22343'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the Climate Product object. | |
| Object | String | The string representing the object's type. Objects of the same type share the same value. | |
| Created | Datetime | The time at which the object was created. Measured in seconds since the Unix epoch. | |
| CurrentPricesPerMetricTonUnit | String | Current prices for a metric ton of carbon removal. | |
| DeliveryYear | Integer | The year in which the carbon removal is expected to be delivered. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. Returns true if the object exists in live mode and false if the object exists in test mode. | |
| MetricTonsAvailable | String | The quantity of metric tons available for reservation. | |
| Name | String | The Climate product's name. | |
| Suppliers | String | The carbon removal suppliers that fulfill orders of this Climate product. |