Best ways of sending records from Netsuite to an external system?

Question

I'm trying to integrate Netsuite to replace parts of our payment system. Sending data to Netsuite from an our system is pretty trivial with web services but what about getting the information back. Say, I want to add Paid Bills back to our system when they are created in NetSuite as payments records on the database.

The simplest solution I thought of, was to do a search and filter by the latest inserted transaction id but the field does not accept greaterThan operator since it's a string.

Is it possible for Workflows to trigger suitescripts? i.e. when Bill is created, run this script, etc, which will then post the data to some end point?

Any thoughts or any other suggestions how to tackle this issue.

Thanks.

Answer 1

There are many, many options here. The solution David mentioned is one option. Your current system will need an available web API (e.g. SOAP or JSON, REST, etc).

If you want near real-time payment data, you could build an appropriate User Event script on the applicable NetSuite records that pushes the data to your application's API right when the record gets created.

If you want to send data in larger batches, you can write scheduled scripts that perform a search for any records that have not been sent to the external system yet and publishes them.

You could build a saved search that runs on a schedule and emails a CSV file of the results to someone who can then import it into the external system.

As an aside, you can build the search you mentioned using the internalidnumber field instead, which will accept a Greater Than operator. More appropriate would probably be to use the createddate field ordered by the most recent.