Documentation: installations
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
| Row Name | Type | Example |
|---|---|---|
|
manufacturer * manufacturer of system, needed to make id when combined with serial number
|
string |
HOP |
|
customer_external_id * Identifies the customer in the context of the data_origin. Can be a fixed ID in another database system or any other way to identify the customer, but note that this information is not encrypted, if you use national id numbers or phone numbers pseudonymize them first.
|
string |
SMU 12 Chinsanka |
|
serial_number * Serial number of the device
|
string |
A1233754345JL |
|
last_source_id Id of the last Source which updated the record
|
integer |
33 |
|
location_area_1 Installation first-level location according to Administrative division |
string |
Northern |
|
location_category Category describing what type of location the location fields represent (e.g., customer residence) |
enum: customer_residence, installation, sale, nearest_fixed_point_of_sale, other |
customer_residence |
|
country_autogen A two-letter country code, auto-generated from given location area 1-5, according to ISO 3166-1 alpha-2 |
string |
UG |
|
country A two-letter country code according to ISO 3166-1 alpha-2 |
string |
UG |
|
longitude Installation location longitude blurred to 3 decimal points Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.
|
float |
-122.419 |
|
latitude Latitude of installation, blurred to 3 decimal points Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.
|
float |
37.775 |
|
is_test Indicates that this is a test installation, which should be excluded in overall analyses. |
boolean |
true |
|
write_off_reason reason for write off (e.g. cancellation, return, etc.) |
string |
Return |
|
write_off_date Date when customer defaulted on the loan and/or the device was written off |
date |
2022-01-01 |
|
repossession_category The reason for repossession, classifying the type of action taken regarding the asset. |
enum: default, swap, voluntary_return, other |
swap |
|
paid_off_date Date when the device was paid off (null if not paid off). |
date |
2022-01-01 |
|
repossession_date Date when the device was repossessed (null if not repossessed). |
date |
2022-01-01 |
|
installation_date Date when the device was installed |
date |
2022-01-01 |
|
purchase_date Date when the device was purchased |
date |
2022-01-01 |
|
payment_plan_category Type of the repayment model |
enum: paygo, upfront, arrears, subscription, other |
paygo |
|
payment_plan_days_down_payment This is the number of days of lighting resulting from the payment of a down payment. Note that the first installment will normally be due at the end of this period. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
30 |
|
payment_plan_days_financed If the device is purchased with a loan, this indicates the loan duration in days, (payment_plan_installment_period_days * number_of_installments). It excludes any days covered by the down payment. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
3650 |
|
last_import_id Id of the last import which updated the record
|
integer |
337 |
|
data_origin Origin of the data, generic or name of the api
|
string |
generic |
|
custom Saves additional imported data out of standard structure
|
jsonb |
{ "some": "key" } |
|
organization_id References Organization of data
|
integer |
1 |
|
import_id References Import of data
|
integer |
1 |
|
source_id References Source of data
|
integer |
1 |
|
updated_at Timestamp when row was updated
|
datetime |
2021-05-03 6:23:55 |
|
created_at Timestamp when row was inserted
|
datetime |
2021-05-03 6:23:55 |
|
location_area_5_autogen Auto-generated location area 1-5 from given coordinates
|
string |
Bila |
|
location_area_4_autogen Auto-generated location area 1-5 from given coordinates
|
string |
Alela |
|
location_area_3_autogen Auto-generated location area 1-5 from given coordinates
|
string |
Arum |
|
location_area_2_autogen Auto-generated location area 1-5 from given coordinates
|
string |
Agago |
|
location_area_1_autogen Auto-generated location area 1-5 from given coordinates
|
string |
Northern |
|
latitude_autogen Auto-generated coordinates from given location area 1-5 Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.
|
float |
-122.419 |
|
longitude_autogen Auto-generated coordinates from given location area 1-5 Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.
|
float |
37.775 |
|
location_area_5 Installation fifth-level location according to Administrative division |
string |
Bila |
|
location_area_4 Installation fourth-level location according to Administrative division |
string |
Alela |
|
location_area_3 Installation third-level location according to Administrative division |
string |
Arum |
|
location_area_2 Installation second-level location according to Administrative division |
string |
Agago |
|
payment_plan_installment_period_days If the device is purchased with a loan, this represents the number of days of lighting per installment paid. For example, if the loan requires 25,000 UGX every 30 days, the payment_plan_installment_period_days is 30. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
180 |
|
usage_sub_category which type of business, which institution |
string |
farmer |
|
usage_category The intended use for this device, e.g. household, institutional, commercial |
enum: household, institutional, commercial |
household |
|
battery_capacity_wh battery capacity in watt-hour Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
500.0 |
|
account_external_id ID for the specific loan account or sale associated with the device. Ideally this is a text or number which can be used to link to any associated payments. |
string |
1 |
|
parent_serial_number Serial number of the parent device, required to build parent_uid. |
string |
A1233754345JL |
|
parent_manufacturer manufacturer of the parent device, needed to make id when combined with serial number, required to build parent_uid. |
string |
HOP |
|
parent_customer_external_id ID for the specific device parent tracked by the data provider, identifying the customer in the context of the data_origin, required to build parent_uid. |
string |
1 |
|
device_external_id id of the specific device as recorded in the source data table, ex. the CRM or sales platform used by the company. |
string |
1 |
|
product_common_id id of common_product table for verified products. |
string |
Verasol |
|
installer_agent_external_id The unique identifier of the installer as recorded in the source data table, ex. the CRM or sales platform used by the company. |
string |
SMU 12 Chinsanka |
|
installer_agent_uid organization_id + data_origin + installer_agent_external_id
|
string |
1_sid_462 |
|
seller_agent_external_id the external ID of the seller agent |
string |
SMU 12 Chinsanka |
|
seller_agent_uid organization_id + data_origin + seller_agent_external_id
|
string |
1_sid_462 |
|
customer_uid organization_id + data_origin + customer_external_id
|
string |
1_api_167 |
|
account_uid organization_id + data_origin + account_external_id
|
string |
123_api_453 |
|
parent_uid If the device is attached to another in a star like topology, like an appliance associated with a specific solar system or a meter associated with a specific grid. Generated from parent_customer_external_id, parent_manufacturer, parent_serial_number, organization_id and data_origin.
|
string |
123_Spark_B1233754345JL_1_api_1 |
|
device_uid organization_id + manufacturer + serial_number
|
string |
123_Spark_A1233754345JL |
|
uid device_uid + customer_uid
|
string |
123_Spark_A1233754345JL_1_api_1 |
|
payment_plan_number_of_installments If the device is purchased with a loan, this is the total number of payment installments required to fully repay the loan for the device. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
integer |
365 |
|
payment_plan_installment_amount If the device is purchased with a loan, this is the amount owed in each installment period, e.g., 25000.00 UGX every 30 days. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
25000.0 |
|
payment_plan_currency If the device is part of an installation with loan this is currency code of payment plan in ISO 4217 three character format. |
string |
ZMW |
|
payment_plan_cash_price The cash price is the amount the customer pays when purchasing the device outright. It is usually equal to payment_plan_amount_down_payment + payment_plan_amount_financed_principal for the same product on loan. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
20000.0 |
|
payment_plan_amount_down_payment If a device is purchased with a loan, the down payment refers to the amount the customer is obligated to pay at the time of purchase. While the customer may choose to pay more, this value reflects only the amount specified in the loan terms. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1500.0 |
|
payment_plan_amount_financed_total If device is purchased with a loan, this is the total amount of the loan to be repaid. This should not include the down payment. This is equal to payment_plan_amount_financed_interest + payment_plan_amount_financed_principal Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1500.0 |
|
payment_plan_amount_financed_interest If device is purchased with a loan, this represents the interest applied to the financed portion of the payment plan after the down payment has been made. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1500.0 |
|
payment_plan_amount_financed_principal If the device is purchased with a loan, this is the total amount of principal to be repaid (excluding down payment and interest) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
1500.0 |
|
site_name Unhashed name for the device |
string |
Hospital Name, Grid Name, etc |
|
pv_power_w PV panel size in Watts Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
50.0 |
|
rated_power_w Max. rated power in Watts Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
float |
30.0 |
|
primary_use Which appliance is bearing the main load of system. This is also used for calculation of device-specific events, ex. number of cooking events. |
string |
cooking |
|
model specific model of system |
string |
DTZ1737 |
|
firmware_version firmware version installed on the smart meter / modem |
string |
1.2-rc3 |
|
dc_input_source the type of power input source used, indicating where the energy is sourced from (e.g., solar, grid, battery) |
string |
solar |
|
ac_input_source ex. generator, grid, wind turbine |
string |
generator, grid, wind turbine etc.. |
|
device_external_category type of device as reported externally by the data source |
string |
pv-array |
|
device_category type of device |
enum: solar_home_system, water_pump, meter, grid, inverter, lantern, refrigerator, water_heater, EPC, electric_stove, non_electric_cooking, milling, other_production_use |
solar_home_system |