I am trying to use the business central 365 connector for an on-prem instance of BC. I believe you may be looking at the incorrect company id column. It seems you are refrencing 'Id' but perhaps should be using the BC guid field $systemId