use soci api instead of do the parsing manually

Merged Benjamin REIS requested to merge fix/external-list-subscription into master

Merge request reports