# Querying NetSuite Records in Custom Form Builder Settings

**URL:** <https://connective.celigo.com/t/querying-netsuite-records-in-custom-form-builder-settings/566>\
**Category:** Integrator.io\
**Tags:** shopify, flow-builder, netsuite\
**Created:** [January 9, 2023, 3:09pm UTC](https://connective.celigo.com/t/querying-netsuite-records-in-custom-form-builder-settings/566 "2023-01-09T15:09:55Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**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:** [January 9, 2023, 7:39pm UTC](https://connective.celigo.com/t/querying-netsuite-records-in-custom-form-builder-settings/566/2 "2023-01-09T19:39:51Z")

</div>

Hi @sujitdesai183, yes this is possible and here is an example I put together for you. Note that you will need to change the connection id for each virtual export to your own Shopify and NetSuite connection ids. Also, for the NetSuite section, you will need to change the search id to your own NetSuite search id. As for the NetSuite saved search itself, my result included _Internal ID_ that had a custom label of _value_ and then _Name_ with a custom label of _label_. Hopefully this helps!

 ![5301043caa20740200000001-d867bc7d97314e1c9f95ba6ec3320984.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/7/7635cc60e82a1fe1fc9db1ec820a4f4929d1247c.png)

 ![5301043caa20740200000001-d0636a4f440d4f709401a0b666d75cb5.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/df0e8457bf8ef73e466ead12f5dbbe26a522cb4a.png)

```
{ "fieldMap": { "refreshable": { "id": "refreshable", "name": "refreshableName", "type": "staticMap", "label": "label this", "keyName": "extract", "keyLabel": "extractLabel", "valueName": "generate", "valueLabel": "generateLabel", "keyResource": { "virtual": { "name": "Lookup", "_connectionId": "626168f90b6ef816b50c82d7", "apiIdentifier": "ea7da9f678", "asynchronous": true, "oneToMany": false, "sandbox": false, "netsuite": { "type": "restlet", "skipGrouping": true, "statsOnly": false, "restlet": { "recordType": "location", "searchId": "2597", "useSS2Restlets": false }, "distributed": { "useSS2Framework": false } }, "distributed": { "disabled": false }, "adaptorType": "NetSuiteExport" } }, "valueResource": { "virtual": { "name": "Get Locations", "_connectionId": "62d95e8be26de11b5ee0dba6", "apiIdentifier": "ede0fb0635", "asynchronous": true, "assistant": "shopify", "oneToMany": false, "sandbox": false, "assistantMetadata": { "resource": "locations", "version": "v2", "operation": "retrieves_alistoflocations" }, "http": { "relativeURI": "/locations.json", "method": "GET", "successMediaType": "json", "errorMediaType": "json", "formType": "assistant", "paging": { "method": "linkheader", "lastPageStatusCode": 404, "linkHeaderRelation": "next" }, "response": { "resourcePath": "locations" } }, "rest": { "relativeURI": "/locations.json", "method": "GET", "resourcePath": "locations", "pagingMethod": "linkheader", "allowUndefinedResource": false, "linkHeaderRelation": "next" }, "transform": { "type": "expression", "expression": { "rules": [[ { "extract": "id", "generate": "value" }, { "extract": "name", "generate": "label" }] ], "version": "1" }, "version": "1", "rules": [[ { "extract": "id", "generate": "value" }, { "extract": "name", "generate": "label" }] ] }, "adaptorType": "RESTExport" } } } }}
```

---

_[View the full topic](https://connective.celigo.com/t/querying-netsuite-records-in-custom-form-builder-settings/566)._