Hi all, trying to figure out if it’s possible to run the NetSuite bank statement importer from a script? Having a bit of an issue where the values in the csv files I’m being provided are wrapped in double quotes e.g. “Joe Bloggs”, “Current Account”,  “1234567”, “125.00" To get around this I was planning on having a SuiteLet that would strip the quotes and then programmatically run the statement importer with the amended csv file but I’ve not been able to find any information on whether this is even possible. Anyone know?

Any particular reason you are married to the CSV format? Maybe try BAI2?

Just the format that was specified by the client, I was trying to do some research on a workaround before I went back to ask if they’d be willing to provide a different format.

Right, but asking for a different natively supported format is likely to be easier for you, and them, and cheaper. Not sure what country you are based out of, but BAI2 is generally reliable within the US, (with some small exceptions) and the bank should be able to provide it with little effort.

I have went back to the client to ask if it’s possible to get the file in the BAIv2. I’m based in the UK and I can see from the banks website that they do provide some statement files in that format so hopefully that includes the one I need. Thanks for your input!