Error in handlebar expression

Aishwarya M J

September 22, 2023 05:42

Hi,

I have custom flow which export customer and order data from FTP server and create Customers and Sales order in NetSuite. In the Sales order import step, an error is thrown related to Shipping cost calculation. Hence I added a mapping for Shipping method using handlebar as

{{#compare ShipToCountry "==" "CANADA"}}10205{{else}}3105{{/compare}}

mapped to Shipping Method(InternalId)

Now the flow throws another errors as

Could not compile handle bar "{{#compare ShipToCountry "==" "CANADA"}}10205{{else}}3105{{/compare}" because "Parse error on line 1: ...else}}3105{{/compare} -----------------------^ Expecting 'CLOSE_RAW_BLOCK', 'CLOSE', 'CLOSE_UNESCAPED', 'OPEN_SEXPR', 'CLOSE_SEXPR', 'ID', 'OPEN_BLOCK_PARAMS', 'STRING', 'NUMBER', 'BOOLEAN', 'UNDEFINED', 'NULL', 'DATA', 'SEP', got 'INVALID'" .Please correct and retry

My order data look like following

Please suggest the soltuion for the issue.

Comments

4 comments

Tyler Lamparter
September 22, 2023 15:04

Principal Product Manager

Aishwarya M J in your error message, it shows you are missing a closing curly bracket at the very end. However, in your posted example of the expression you are using you have it. I'm able to get the same error if I leave off the last bracket, but can't get the same error if I have it. Can you confirm you do or don't have that last curly bracket on the mapping? Maybe screenshot your mappings as well and post here.

1
David Gollom
September 22, 2023 15:50

Strategic Partner

Beat me to it! i saw that too.

0
Aishwarya M J
September 25, 2023 06:19

Referral Partner

Hi Tyler Lamparter,

Thanks for the update. I have corrected the error by adding the missing closing bracket. Actually I did the mapping for Shipping method to resolve another error in my flow which is

"Failed to save record because Could not calculate cost for the selected Realtime rate. The requested service is unavailable between the selected locations."

Do you have any idea on this error?

Thanks in advance.

0
Tyler Lamparter
September 25, 2023 22:46

Principal Product Manager
Aishwarya M J that sounds more like an issue with your NetSuite config or the mappings. Here are a couple posts that may help you troubleshoot:
- https://stackoverflow.com/questions/71495177/could-not-calculate-cost-for-the-selected-realtime-rate
- https://www.reddit.com/r/Netsuite/comments/5wo3l1/could_not_calculate_cost_for_the_selected/
You can map the "use dynamic mode" and mimic entering as if you were in the UI. See articles here:
- https://docs.celigo.com/hc/en-us/community/posts/360077243491-FAQ-How-can-I-set-mapping-order-to-ensure-particular-fields-are-mapped-first-
- https://docs.celigo.com/hc/en-us/articles/16088065516187-NetSuite-field-definitions-for-import-mapping#Use_Dynamic_Mode
0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post