Could not compile handle bar (define lookup criteria)

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!
 
 
0

Comments

4 comments
Date Votes
  • 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.

    0
  • Thanks Nuri Ensing!

    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:

    0
  • 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.

    0
  • thank you so much Nuri Ensing

    0

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post