D365 import fails with 401Unauthorized error

  • 59Views
  • Last Post 16 December 2021
Maneesh Luhana posted this 15 December 2021

Hello Team,


I am doing a fresh import from Zoho extracted data (Accounts & Contacts) into the CRM and it results in  (401) Unauthorized. error

Also, wanted to know how do I create a lookup between Accounts which has multiple contacts


Nataliia Nikulina posted this 16 December 2021

Hello Maneesh,


Thank you for contacting Skyvia Support team.

The 401 Unauthorized error occurs on the stage of updating the account object in Dynamics 365. 

The problem may hide in one of the columns which are being updated during the package run.

We would ask you to try to perform the test update of a couple of fields in the test record of the Contacts table using Skyvia Query SQL tab. You can use the DDL script below:

UPDATE account set name = 'test' where accountid = '135a5d42-b830-ec11-b6e6-000d3a399755'

Note that the accountid should be substituted with a relevant value.  

If this test update works please try to perform the same test update of the fields which are mapped in your package. 

If the update operation doesn't work for any fields, then we would recommend that you find out if there were any changes in your

access rights for the account object.  

Regarding the lookup settings, please send us the package link you are working on so we can take a look at the package configuration. 

We look forward to hearing from you.


Best regards,


Customer Support Engineer