# To solve the error: Failed to create, update/transform record because Cannot find function getSelectOptions in object Field **URL:** \ **Category:** Integrator.io\ **Tags:** error-handling, export, import, flow-builder, netsuite\ **Created:** [July 7, 2023, 8:47am UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423 "2023-07-07T08:47:38Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![rosemoljoe](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/rosemoljoe/32/4430_2.png) [@rosemoljoe](https://connective.celigo.com/u/rosemoljoe)\ **Post date:** [July 7, 2023, 8:47am UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/1 "2023-07-07T08:47:38Z")
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** ![5301043caa20740200000001-34fa3248e2fd4dd7a7fad233c8003b8f.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/4e43852e1e97b4bad43c5cd65ef3141316fd5c9f.png) ---
**Author:** ![nuriensing](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/nuriensing/32/6918_2.png) [@nuriensing](https://connective.celigo.com/u/nuriensing)\ **Post date:** [July 7, 2023, 9:15am UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/2 "2023-07-07T09:15:54Z")
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. ---
**Author:** ![rosemoljoe](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/rosemoljoe/32/4430_2.png) [@rosemoljoe](https://connective.celigo.com/u/rosemoljoe)\ **Post date:** [July 7, 2023, 11:13am UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/3 "2023-07-07T11:13:09Z")
Screenshots of Import Mapping ![5301043caa20740200000001-1c95f9f99efa4084afc49f1411d3b072.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/9dbdb504306a36b1bc5ab393c5317857252788e6.png) ![5301043caa20740200000001-9608407111c64caca258a508f1dd034a.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/dbed5db177ffc1b683a6f51cae98d66e72c04696.png) ![5301043caa20740200000001-621c4554d9cf4681bec170043e359cf5.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/29efd86e02fbe1d5918f9db0c80c05145e3870b2.png) ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [July 7, 2023, 12:42pm UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/4 "2023-07-07T12:42:39Z")
@rosemoljoe can you try use dynamic mode? See article here: [https://connective.celigo.com/t/faq-how-can-i-set-mapping-order-to-ensure-particular-fields-are-mapped-first/1208](https://connective.celigo.com/t/faq-how-can-i-set-mapping-order-to-ensure-particular-fields-are-mapped-first/1208). ---
**Author:** ![rosemoljoe](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/rosemoljoe/32/4430_2.png) [@rosemoljoe](https://connective.celigo.com/u/rosemoljoe)\ **Post date:** [July 7, 2023, 1:41pm UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/5 "2023-07-07T13:41:26Z")
Yes I have included dynamic mode in mapping and also reordered the mapping like this ![5301043caa20740200000001-53674c30ff604bb7b64b01867cc4ac69.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/63df55262f3baca8becc5667a4d2b2ef48fcea99.png) ![5301043caa20740200000001-a48842a145a045bfbf851eea69853a80.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/5df2f0745de137135c129041e3eed708e1570522.png) ![5301043caa20740200000001-7f331499de30432d9e141c49c53ca034.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0b89caad447934ffe53e1e58d0440fd113fa38f7.png) But still the same error ![5301043caa20740200000001-905fd10b250d49b4ae079416cec35e09.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/8/81f466786c46cd9409dfa1e5c5ea9c87e280dd69.png) ---
**Author:** ![dhilips](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@dhilips](https://connective.celigo.com/u/dhilips)\ **Post date:** [July 10, 2023, 5:42pm UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/6 "2023-07-10T17:42:45Z")
Hi @rosemoljoe, 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) ---
**Author:** ![rosemoljoe](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/rosemoljoe/32/4430_2.png) [@rosemoljoe](https://connective.celigo.com/u/rosemoljoe)\ **Post date:** [July 11, 2023, 5:09am UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/7 "2023-07-11T05:09:14Z")
Yes, after removing the Status field from mapping the error got solved. But now there is another error ![5301043caa20740200000001-980c197a48a14e55a915b76bec3b9f2a.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/de51020c4208f61206ac10743678f3e0eb83f4fa.png) The mapping now providing is like ![5301043caa20740200000001-501ca2d806a248e580fbeb0be02c2009.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/49d31cdeb06853ca5a89e299aff12d3f4c07712c.png) In the preview, we can see the item details. But in the debug log the item details are missing ![5301043caa20740200000001-99fbc7b1b1c24d718b269a698a89480c.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/7/7ec845a73b540d6799d583dec09a3c4067aebb80.png) ---
**Author:** ![dhilips](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@dhilips](https://connective.celigo.com/u/dhilips)\ **Post date:** [July 11, 2023, 5:59am UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/8 "2023-07-11T05:59:16Z")
@rosemoljoe, 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 ---
**Author:** ![rosemoljoe](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/rosemoljoe/32/4430_2.png) [@rosemoljoe](https://connective.celigo.com/u/rosemoljoe)\ **Post date:** [July 11, 2023, 7:12am UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/9 "2023-07-11T07:12:27Z")
The Above error solved Thank You ---
**Author:** ![rosemoljoe](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/rosemoljoe/32/4430_2.png) [@rosemoljoe](https://connective.celigo.com/u/rosemoljoe)\ **Post date:** [July 12, 2023, 11:20am UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/10 "2023-07-12T11:20:32Z")
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. ---
**Author:** ![dhilips](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@dhilips](https://connective.celigo.com/u/dhilips)\ **Post date:** [July 12, 2023, 3:51pm UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/11 "2023-07-12T15:51:06Z")
@rosemoljoe, 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](https://docs.celigo.com/hc/en-us/articles/7707882031131-Import-API-endpoints) article for performing API requests ---
**Author:** ![steveklett](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@steveklett](https://connective.celigo.com/u/steveklett)\ **Post date:** [January 1, 2024, 6:58pm UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/12 "2024-01-01T18:58:00Z")
@dhilips I've just encountered this same error when creating a NetSuite Item Fulfillment. The Status field is the cause of the error, but unlike @rosemoljoe I can't exclude the Status field, I must map it. Is the solution still to hack the Import back to the SuiteBundle version? It's been 6 months so I'm hoping there is a new and better solution available. Our SuiteApp version is 1.12.1. FYI, I created ticket #204828 ---
**Author:** ![steveklett](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@steveklett](https://connective.celigo.com/u/steveklett)\ **Post date:** [April 10, 2024, 5:32am UTC](https://connective.celigo.com/t/to-solve-the-error-failed-to-create-update-transform-record-because-cannot-find-function-getselectoptions-in-object-field/423/13 "2024-04-10T05:32:15Z")
Just ran into this issue again on a new integration. Now it's been 9 months that this has been a problem. I found an alternate solution though that doesn't require dynamic mode (which creates it's own odd issues). In my case, having a mapping for ``` Status (Internal ID) hardcoded to "A" ``` would cause the error: > Failed to create, update/transform record because Cannot find function getSelectOptions in object Field However a name mapping works: ``` Status (Name) hardcoded to "Picked" ``` I suspect the reason for the different behavior is that when setting by IID the IIO processor script is trying to find the matching select value where the name version is just using setValue (or setFieldValue if still on 1.0). I don't know, maybe that's totally wrong. What I do know is that this whole thing is a big pain in the a\*\* and I can't seem to remember the workaround and keep encountering it over and over! ;)