Querying NetSuite Records in Custom Form Builder Settings

Integrator.io
, ,
2

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
5301043caa20740200000001-d867bc7d97314e1c9f95ba6ec3320984.png1944×1253 293 KB

5301043caa20740200000001-d0636a4f440d4f709401a0b666d75cb5.png
5301043caa20740200000001-d0636a4f440d4f709401a0b666d75cb5.png2560×1132 196 KB

{
  "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"
        }
      }
    }
  }
}