To solve the error: Failed to create, update/transform record because Cannot find function getSelectOptions in object Field

Rosemol Joe

• July 07, 2023 08:47

We are creating a custom flow to sync sales orders from the Warroad Netsuite account to the Touchstone Netsuite account. 

We have created 2 transaction searches in the Warroad account. One to fetch the details of body fields of sales order and the other to fetch the item line fields of sales order. The body field included search is fetched on the Export side and the item line field search is included on the Lookup. And also we provided a result mapping. On the Import side, we have provided a mapping.

After running the flow we are getting an error message like this: 

Failed to create, update/transform record because Cannot find function getSelectOptions in object Field

0

• 

  Nuri Ensing NetSuite Integration Whiz

  • July 07, 2023 09:15

  

  

  

  Can you also show your mapping and do you also use netsuite scripts on certain fields?
  The error message you're seeing, "Cannot find function getSelectOptions in object Field", usually occurs when the getSelectOptions function is called on a field that either doesn't support this function or doesn't exist in the form.

  0
• 

  Rosemol Joe

  • July 07, 2023 11:13

  Screenshots of Import Mapping 

  

  0
• 

  Tyler Lamparter Principal Product Manager

  • July 07, 2023 12:42

  

  

  

  

  

  Rosemol Joe can you try use dynamic mode? See article here: https://docs.celigo.com/hc/en-us/community/posts/360077243491/comments/15124655745307.

  0
• 

  Rosemol Joe

  • July 07, 2023 13:41

  Yes I have included dynamic mode in mapping and also reordered the mapping like this

   

  

   

  

  

  But still the same error

  

  0
• 

  Dhilip Srinivasan

  • July 10, 2023 17:49
  • Edited

  Hi Rosemol Joe,

  Use Dynamic Mode should solve the problem. can you please try either any one of the below steps

  1. Remove "Status" field in mappings if not needed

  2. Try to update import doc by replacing "restletVersion" from "suiteapp2.0" to "suitebundle" through POSTMAN(In UI, its disabled field)

  0
• 

  Rosemol Joe

  • July 11, 2023 05:09

  Yes, after removing the Status field from mapping the error got solved.

  But now there is another error 

   

  

  The mapping now providing is like

  

  In the preview, we can see the item details. But in the debug log the item details are missing

  

   

  1
• 

  Dhilip Srinivasan

  • July 11, 2023 05:59

  Rosemol Joe,

  While we are using suiteAPP 2.0, it will throw an error when all the sublist(eg: items) values are hardcoded. we need to map either one of the sublist values from exports(Standard type) or you can use dynamic lookup for items : item (internalid) field mapping to set item id or item name. this will solve the above error

  0
• 

  Rosemol Joe

  • July 11, 2023 07:12

  The Above error solved 

  Thank You

  0
• 

  Rosemol Joe

  • July 12, 2023 11:20

  Failed to create, update/transform record because Cannot find function getSelectOptions in object Field

  The above-mentioned error was solved by removing the status field from mapping. But need to hardcode the status as Pending Fulfillment in the mapping.

   

   

  0
• 

  Dhilip Srinivasan

  • July 12, 2023 15:51

  Rosemol Joe,

  Then please try to update the backend import doc by replacing "restletVersion" from "suiteapp2.0" to "suitebundle" through POSTMAN(In UI, it's a disabled field for existing imports). For new imports, you can select "suitebundle" in the advanced section.

  FYI, Please refer to this article for performing API requests

  0

Please sign in to leave a comment.