topic Re: Create/Update in Bulk NetSuite Actions in Workato Pros Discussion Board

Create/Update in Bulk NetSuite Actions

jessica-lie — Fri, 15 Jan 2021 13:14:58 GMT

[Dec 2, 2020] Joe Blanchett (Product Manager, Finance Systems at Seat Geek) posted:

Hi Automation Pros,

Has anyone had any luck w/ using any of theCreate/Update Records in Bulk actions in the NetSuite Connector? I've tried a few times but have never got it to work - the job just hangs in aProcessingstate until I eventually cancel the job.

Actions I've tried, all w/ the same results.

Create Custom Records in Bulk
Update Custom Records in Bulk
Create Standard Records in Bulk
Update Standard Records in Bulk

Let me know if you've gotten this to work - would love to chat!

Re: Create/Update in Bulk NetSuite Actions

jessica-lie — Fri, 15 Jan 2021 13:16:42 GMT

[Dec 2, 2020] Sean Duggan (Financial Systems Administrator at Catalant Technologies) replied:

Hi Joe,

How many records are you attempting to update in bulk?

Re: Create/Update in Bulk NetSuite Actions

jessica-lie — Fri, 15 Jan 2021 13:17:32 GMT

[Dec 3, 2020] Kyle Tan (CSM at Workato) replied:

Hey Joe,

Was it attempted via a test job, by any chance? You might need to "start" the recipe for the long running action to work. The jobs status will probably also update in 5 minute intervals as Workato checks the bulk requests to see if they're completed.

Re: Create/Update in Bulk NetSuite Actions

jessica-lie — Fri, 15 Jan 2021 13:18:32 GMT

[Dec 3, 2020] Joe Blanchett (Product Manager, Finance Systems at Seat Geek) replied:

Thanks Kyle - that was it! I have 1000 records in step 4 and I'm repeating in batches of 100 in step 5, then calling NetSuite bulk update in step 6 below. Do you know if Workato will make the calls in step 6 at the same time, then catch each async response in the next 5 minute checkAsyncStatus call? Or will the setup below lead to 1 call + checkAsyncStatus every 5 minutes (meaning a total time = 50 min)? If the latter, the bulk update probably isn't the way to go with this.

Re: Create/Update in Bulk NetSuite Actions

jessica-lie — Fri, 15 Jan 2021 13:18:53 GMT

[Dec 3, 2020] Kyle Tan (CSM at Workato) replied:

From a quick glance at the recipe, it appears that we won't need to split them up into batches. You should be able to put the rows straight into the bulk action 🙂 The connector will figure out how to batch them up so they're processed as quickly as possible.

Re: Create/Update in Bulk NetSuite Actions

jessica-lie — Fri, 15 Jan 2021 13:20:03 GMT

[Dec 3, 2020] Joe Blanchett (Product Manager, Finance Systems at Seat Geek) replied:

Ok - based on the help text here I assumed I had to batch in groups of <= 200 before passing the records into the bulk update step.

Re: Create/Update in Bulk NetSuite Actions

jessica-lie — Fri, 15 Jan 2021 13:20:25 GMT

[Dec 3, 2020] Kyle Tan (CSM at Workato) replied:

Oh, that's odd, good catch! Could you try it with the total number of records? I'll let the product team know that something doesn't look right about that note.

Re: Create/Update in Bulk NetSuite Actions

jessica-lie — Fri, 15 Jan 2021 13:20:56 GMT

[Dec 11, 2020] Kyle Tan (CSM at Workato) replied:

Hmm, this was my bad, Joe 😞 The NetSuite bulk action does indeed only work with up to 200 records.

And yes, it would take 50 minutes in your example. One alternative is to use an asynchronous callable recipe with concurrency at 5 to make it faster.