What's wrong when I get the message: Unrecognized Guid formatI am building a solution to sync data from Dynamics to Hubspot. I am trying to move the country field to Hubspot and get this error message

[Manoj Chaurasia]

: Detail:

Error in mapping 'Contact.country ' for Operation 'Update'

 

Description:

Operation failed. Label: Update/Insert HS Contact, Name: ContactUpdateInsert, Message: Exception Type : FormatException

Message : Unrecognized Guid format.

StackTrace : at System.Guid.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument, String failureArgumentName, Exception innerException)

at System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result)

at System.Guid.Parse(String input)

at Scribe.Process.ProcessCRMContactHSContactUpdateInsert.Execute(Dictionary`2 settings, IEnumerable`1 dataEntityInput)- could anybody help

[Manoj Chaurasia]

This is the formula in the field matching table:

IF(ISNULLOREMPTY(contact.address1_country), NULL,LOOKUPTABLEVALUE2("Country", contact.ambcust_address1_country ))