Looking for more information and documentation about the January 2025 SmartConnect.com Update? Use the links below to learn more about:

• New Features and Related Help Documentation
• Bug Fixes
• How to Access the SmartConnect Release
• Support & Getting Help

New Features

We’re excited to roll these updates out to the public. The January 2025 SmartConnect.com Update includes improvements that will make real-time integration easier, increase flexibility for Oracle NetSuite Integration, and make the REST API integration more efficient.

Here are the new features and related documenation included in this SmartConnect.com update:

Webhooks & REST API Integration

Webhook Real-Time Sources – Creating a Webhook Real-Time Source enables immediate, automated, and efficient communication between systems, reducing the need for constant polling and manual data retrieval.

Click here to view the documentation about webhook real-time sources.

Creating Webhook Definitions – Creating a Webhook Definition is beneficial because it provides structure, clarity, and consistency in how webhooks are implemented, managed, and utilized. It acts as a blueprint or contract between systems, ensuring that both sides understand how to communicate, what data is being exchanged, and how the data should be processed.

Click here to view the documentation for creating webhook definitions.

Oracle NetSuite REST API Integration

NetSuite REST Transformations – In the NetSuite REST web services, you can transform a record from one type to another. By using data from an existing record you can automate business processes, reduce manual data entry, and ensure data consistency when moving from one transaction to another.

Click here to view the documentation about Oracle NetSuite REST transformations.

NetSuite REST Sublists – NetSuite REST Sublists are crucial because they allow you to retrieve, update, and manage related records within a parent record using NetSuite’s REST API. Sublists represent line items or related data, such as items in a sales order, expenses in a purchase order, or addresses in a customer record.

Click here to view the documentation about working with Oracle NetSuite REST Sublists.

Integrating to the NetSuite REST API – Setting up an integration to NetSuite REST enables a unified, automated data exchange between NetSuite and other systems, improving efficiency, accuracy, and scalability. 

Click here to view the documentation.

Creating a RESTlet Query Data Source – A RESTlet Query Data Source in NetSuite is a custom tool that helps you fetch data from NetSuite using a single, efficient API call. It allows you to query specific data based on your exact needs, instead of pulling everything and filtering through it later. This will save time, improve performance, and customize your queries to your specific needs.

Click here to view the documentation about creating a RESTlet Query Data Source.

Setting up a Record Reference Column – A Record Reference Column is useful when you need to link records in one table to related records in another table, without duplicating data. This keeps data consistent, allows you to easily navigate between related records (for example, items to orders or customers to contacts), simplifies reporting by allowing you to generate reports easily, and allows you to maintain clean relationships between records as your business grows.

Click here to view the documentation about setting up a Record Reference Column.

Oracle NetSuite Integration

Creating a NetSuite Change Data Source – The NetSuite Change Data Source is used to track and extract changes from NetSuite records. This is useful for integrations, reporting, and syncing data without having to pull entire data sets, reducing the load on NetSuite and improving data integration performance.

Click here to read the documentation about creating a NetSuite Change Data Source.

Bug Fixes

Here are the most notable bug fixes that have been resolved in the January 2025 SmartConnect Update:

• Content-type header causes object reference error in REST integrations.
• NetSuite destination error “object variable not set” when mapping custom field of ListOrRecord or RecrodRef type.
• Select DISTINCT getting a syntax error in SQL sources.
• NetSuite Connector Audit Log is filling up NETSUITE_LIST_LOOKUP Completed messages.
• Multiple rest lookups causing records to be restricted.
• Arrange By not persisting for grids.
• Intergration erorr “Document was not sent due to document errors” caused by using non mapped nested SuiteQL lookups that are set to include in scripting.
• NetSuite Restlet sources are failing when ran on a schedule.
• NetSuite change source map does not apply tracking date when previewing.
• NetSuite change source map export is invalid.
• Failed Popdock queries return an Object Reference Error.
• Add the Run as User to the SmartConnect.com process scheduling window.
• Issue importing NetSuite map with QueryDataSource using Saved Search and define custom record types.
• NetSuite Realtime sources for a transaction returning 0 records under certain conditions.
• Fix NetSuite metadata timeouts for SOAP and REST to handle 600+ custom records.
• MSSQL Connectors to Serverless Instances don’t wait for the server to wakeup.
• Repeated target line change on integration edit causes memory leak.
• Delete capability implemented on NetSuite destinations.
• Couldn’t use a Calculated Column in the filter of NetSuite’s SuiteQL Lookup.

How to Access the January 2025 SmartConnect.com Release

The update is now available in your SmartConnect.com environment. The documentation linked in the “New Features” section of this documentation article notes how to navigate to the functionality.

Support & Getting Help

If you would like further assistance or have questions about the January 2025 SmartConnect.com Update, please contact us or email our support team. We will be happy to help.