data pull from HQ APIs complete