One thing you will need to know/consider -- ServiceNow MID servers don't have the ability to "fetch" from another server inherently. MID servers do file importing, but it is manual/scheduled or via data source (via specific configurations).

MID servers do have other capabilities that would "act like import" (all by themselves) -- but they are specific. For instance, Discovery "imports" data to the instance...but specific data (CIs) to a specific place (CMDB).

This might help - How to import a CSV file from a MID Server - Support and Troubleshooting (servicenow.com)