I am using the data service to manage a series of relationships, containing information on owners, their clients, and individual client information tables. But have struck a bit of a wall when trying to upload the data to data service.
I have established the owners, table, but the process of using relationship fields to link tables together is not allowing me to use the owners email as a reference, instead I am required to use the corresponding GUID for the owner row.
The only way to grab this that I am aware of is through the query entity records and then using result(0) as my field.
Is there a more efficient way to pull this specific entity GUID without having to run queries every time? Such as an assign that works something like this:
ClientList.OwnerEmail = OwnerList.OwnerEmail(“Email”)