Linking user to record on import


I am using an API to import new property records from another database. I want to be able to link the related user and related agent on import but can’t see how to get this to work.

The imported record includes the agents email address and I am trying to match this to the related user and related agent.

I have searched and searched but can’t seem to find the answer.



This was simple in the end. Sure I had tried it and it didn’t work. Anyway for others looking I just imported the email address as a text field and created a search for the related user.