Hi support,
Following this ticket I will make one myself to keep things clear.
We have set up a Business Central 365 connection, both via OAuth2.0 as service to service authentication. We have succesfully tested the connection with both authentication options. However, when we want to read objects, we receive the error “Invalid response from Business Central retrieving table Field for company”. Full log is added to this ticket as an attachment.
We have walked through all steps from the prerequisites guide. Hence, we have a succesful connection. From the other ticket I understand that there are more versions of the Jet Analytics for Business Central extension. It has to be the newest one and I have to keep on trying. In the Extension Marketplace we only find two versions of the Jet Analytics for Business Central extension. The first from Jet Global Data Technologies is not available anymore and they point to the second; the one from insightsoftware. This is the one we have installed; version 1.23.12.3601, which seems to be the latest. How can we find out whether or not the version we use is outdated or even the wrong version?
For service to service authentication we have set up the Microsoft Entra Application Card permissions as follows:
Any help would be appreciated! :)