By default, the integrator.io NetSuite connection communicates via custom RESTlets in the Celigo integration bundle. However, you can route your connection to a different NetSuite RESTlet by specifying HTTP headers in integrator.io API exports or imports, acting as a proxy for requests to your NetSuite connection.
Note
See Set up an OAuth 1.0 connection to NetSuite SuiteTalk APIs (including SuiteQL) to set up a connection to SuiteQL.
First, create or edit a standard NetSuite connection. Copy the connection ID at the end of the URL to use when configuring your export and import below.
Next, set up an API token for integrator.io. After you've configured your API token, create an integrator.io connection.
In Flow Builder, create an export to integrator.io.
Name: Give the export a name.
Application form view: Choose HTTP. Learn more about the different types of connectors.
HTTP method: Choose POST
.
Relative URI: Enter the proxy URI for your NetSuite connection, referencing the NetSuite connection ID you copied above. The format is: /v1/connections/<id>/proxy
.
Headers: Add the following headers.
Name |
Suggested value |
---|---|
|
Paste in the Script ID. |
|
Paste in the Deployment ID. |
|
The method to use with your RESTlet call (most likely |
HTTP request body: Enter an empty JSON object, {}
. You can pass query parameters for GET
and DELETE
methods by adding them to the request body as follows:
{ "query": { "key": "value" } }
Export type: Choose All.
Click Preview to see your RESTlet data.
In your flow, create an import to integrator.io using the connection you built earlier.
Name: Give the import a name.
Application form view: Choose HTTP. Learn more about the different types of connectors.
HTTP Method: Choose POST
.
Relative URI: Enter the proxy URI for your NetSuite connection, referencing the NetSuite connection ID you copied above. The format is: /v1/connections/<id>/proxy
.
Headers: Add the following headers.
Name |
Suggested value |
---|---|
|
Paste in the Script ID. |
|
Past in the Deployment ID. |
|
The method to use with your RESTlet call (most likely |
Within this import, the integrator.io connection functions like any other HTTP connection. You can specify an HTTP request body or use field mappings. If you go with the latter, you can provide a sample request under Do you have a sample destination record? in the import settings to make mapping easier.
You can pass query parameters for GET
and DELETE
methods by adding them to the request body:
{ "query": { "key": "value" } }