parsing connection info into json arrays