Could not compile handle bar (define lookup criteria)

[jurajtoth]

Hi,

I'm struggling with the below.

Trying to import netsuite employees with this lookup criteria:

The export app stores Employee ID in the Employee_ID field. NetSuite stores it in the Hibob ID field.

Export applicaton:

Import app:

Getting following error:

Could not compile handle bar "{{{Report_Entry[*].Employee_ID}}}" because "Parse error on line 1: {{{Report_Entry[*].Empl ---^ Expecting 'ID', 'STRING', 'NUMBER', 'BOOLEAN', 'UNDEFINED', 'NULL', 'DATA', got 'INVALID'" .Please correct and retry I also tried "is" instead of "equal to" in the handlebard, but same result. Thank you!

[nuriensing]

It seems you have multiple report_entry json objects. Are they all filled in correctly?
And maybe try to use the one to many option:

Then in the search filter, you can just use Employee_ID then it will execute the import per object.

One to many is used in cases where you have a single record which internally needs to create multiple records.

[jurajtoth]

Thanks @nuriensing!

I do indeed have multiple report_entry json objects:

I tried what you proposed:

Could you please point me to some documentation on how to handle mapping for multipe report_entry jsons? I managed to import records into NetSuite but the mapping is apparently wrong becasue fields are empty (name, email, etc.):

My output is empty:

[nuriensing]

If you use one to many, then it will do an import based on the N number of child objects.
This means in the left side of your mapping you can use Name instead of Report_Entry[*].Name and this is the case for all the nodes which fall under Report_Entry. If you want to map properties above the child node then you can use _PARENT.propertyname.

Hope this helps.

[jurajtoth]

thank you so much @nuriensing