clean json and update extract data