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
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,
Nataliia,
Customer Support Engineer
