updating loan transacation api to retreive office data