Anyone seen this error in Excel when working with REST before? I’m not aware of any changes we have made on our Epicor Server and hitting refresh on my datasource produced this error:
Look into server event log
Query with ‘subqueryBTF2’ id is not found in ‘400’ company. Any idea why it suddenly would be defaulting to company 400 instead of 300? I am logged into 300.
Manually passing the company doesn’t work and shows the same id is not found in ‘400’ error.
This is the path I am using with our hostname removed. Yesterday it was working.
EpicorLive10/api/v1/BaqSvc/subqueryBTF2?Company=‘300’
Current company changed for the user you connect from Excel. I doubt that excel works with query parameter. (that is after ?)
Log into Erp with the user you use in Excel, change company to 300 and logout. Company will be saved on exit.
1 Like
The logoff part through me off - thanks.
Why wouldn’t Excel work with the query parameter to force the company?
1 Like
Excel is Odata client that we did not write 
So when we created that possibility to switch company using query string we did not know Excel will not use it. Probably because it is not by Odata standard. And when you switch company using subqueryBTF2 (300), it also fails in some newer version of Excel.
We need to follow more strict Odata standard for BAQs, but it requires rework of current approach.
Thanks.