Xero Entity Lookup Column

<< Click to Display Table of Contents >>

SmartConnect 2017

Xero Entity Lookup Column

When updating / inserting information into Xero via SmartConnect, records may require links to records that already exist within Xero. E.g. When loading a Xero invoice a link may be required from the invoice to the account to which the invoice belongs. An entity lookup column allows users to look for another entity within Xero and link it to the current entity.


To create a Xero entity lookup column:

1.Select Create on the Map tab, or select the Maps Quick Link and double click on the map to be edited.
2.If creating a new map enter the map id and description.
3.If creating a new map enter the data source and key field information.
4.If creating a new map select Xero as the destination, then double click on the mapping type required.
5.Select Additional Columns from the toolbar at the top of the mapping window.
6.Select Entity Lookup to add a new column, or double click the column to be edited.
7.Enter a name for the lookup column. Names must be unique within a map.
8.Select the entity type that should be linked to the current record.
9.Select the Add_Node on the criteria grid to enter the matching details for the lookup.
10.Select the column within Xero that should be looked up.
11.Select the data source column that contains that data to be lookup up within Xero.
12.Add extra criteria rows if required.
13.Select OK to save the column changes.
14.Select OK to close the column window. The new lookup column should now appear in the left grid on the matching window.
15.Drag the lookup field to the required spot in the destination grid or select entity lookup as the Column Type and the column name as the Column Name in the destination grid.





If more than one record matches the criteria the first matching record returned by the query will be used.
An entity lookup column will only return the Id of the entity that matched the criteria. This should then be mapped to the appropriate id column in the destination entity. Entity lookup columns will not return data other than the entity id.