Handle null values for address fields in Implementation Inventory GET API response

[himeshr]

Vinay found 365 entries of ImplementationInventory.. where address_id field is null.
Its caused by following fields coming as null in the Goonj Salesforce "Get ImplementationInventories" API:
"CenterFieldOfficeState": null,
"CenterFieldOfficeDistrict": null,

Tasks:

• We need to handle Null values for address fields in all Goonj entities synced from Goonj Salesforce to Avni.
• Void all existing ImplementationInventory with addressIds null in DB (Post deploy of above fix)

Code place:

Subject.java:
public void setAddress(String address) {
map.put(AddressFieldName, address);
}

[himeshr]

This bug has been fixed in Salesforce. ImplementationInventory wont send null values anymore.
Ran the below command for entries in prod with null addressId:
update individual set address_id = 413044, last_modified_date_time = current_timestamp + ((id) * interval '1 millisecond') where address_id is null and subject_type_id = 1020;

[ashusvnath]

@himeshr : How many records are updated by the script you provided in the comment ? Are all the 365 entries fixed ?