Error "Attribute: ownerid cannot be set to NULL".

  • 5Views
  • Last Post 1 weeks ago
0
votes
Jonathan Killen posted this 2 weeks ago

You are supposed to be able to use Lookup mapping with the "Set null when no match found" option to set the OwnerId (Owner) of items in Daynamics CRM when importing items from SugarCRM. In this case, if Lookup finds Dynamics CRM user with the same name as SugarCRM user, this owner will be assigned for the corresponding record. If corresponding Dynamics CRM user is not found, a NULL value should be sent by Skyvia to Dynamics CRM and the necessary OwnerId will be assigned automatically based on the user assiciated with the used Dynamics CRM connection.
But, currently it will give an error "Attribute: ownerid cannot be set to NULL".

I have it setup like this:

Target Lookup:
Object - systemuser
Result column - systemuserid
lookup key column - fullname
+
Source lookup:
Object - User
Result Column - user_name
Lookup Key Column - Id
Column - assigned_user_id

I also have the  "Set null when no match found" option turned on for both the Target Lookup and the Source Lookup.  Is this the correct way to set this up?  Please help me figure out why this is not working as expected.

0
votes
Mariia Zaharova posted this 1 weeks ago

We have contacted you by email, please check it.

Close