Update: through my testing I found that as soon as I added the domain name of the hosted file to the hosts on the ipad, the upload would work. If I removed the host it would continue to work without any problems. I don't know if FM GO saves the hosts even though you remove them? If I removed GO from the ipad completely and and reinstalled I would be back to where I was before when it would not import my data.
My Theory: Through my experience and reading I found that you could have a table occurence to the Master file that is hosted. This would allow you to perform the script from the hosted file without having to open the file on the ipad. This works, if your ipad has or previously had the Master files domain name listed as a host. This still does not explain why the import does not produce any error code.
My Solution: I just opened the file on the Ipad and everything seems to be working fine.
Hopefully this helps someone and saves them some time.