Has anyone come up with a creative way to allow no...
# general
r
Has anyone come up with a creative way to allow non-Admins to download another user's (service account user if it makes a difference) CSV Response files? I have some folks I want to give access to support certain processes, but those functions don't require Admin access otherwise, so I don't particularly want to grant them Admin access.
k
I have never seen it. I'd be curious if there was a way though
a
Do you mean the result files from their CSV import jobs?
r
> Do you mean the result files from their CSV import jobs? Yes, we have an automated/scripted process that runs CSV imports via a service user. For troubleshooting purposes, I'd like non-admins to be able to access those response files for research if records fail.
a
Hmm, aside from scripting your own CSV import functionality that generates its own results file and puts it in the file cabinet, I'm not sure. I did notice that the result file download links look like this, though: https://4557656.app.netsuite.com/app/setup/upload/csv/uploadlogcsv.nl?wqid=123456789 If that wqid number matches the Task ID of the CSV Import Task in your script, then maybe you could use that. Or maybe you could try screen-scraping the HTML response of a request to https://4557656.app.netsuite.com/app/setup/upload/csv/csvstatus.nl and try matching to the import task name somehow. But either one of these approaches is designed to get the file as if it were a logged-in NetSuite user, so it would likely have to be triggered manually by someone with access to the CSV import Status page anyway, dump the files to the file cabinet, and then associate those files to some kind of data structure that the customer Customer Center role has access to. Sounds tricky.
r
Yeah thanks I appreciate the input, but we're probably at "that sounds tricky" like you say..ha. It's not critical enough that I'd probably go to an amount of effort that takes more than an hour or two if that. I was looking more for a "I'm being dumb and missing something easy/obvious" kind of answer, which it sounds like doesn't exist. tbh I'm kind of surprised that those files don't appear to live in the file cabinet. At least not that I can find. If they were there, a work-around would probably be way easier.
👍 1
k
Supposedly when you do a CSV import via script you are supposed to be able to interpret results - but I'm not developer enough to understand what that actually looks like.
r
Just a wild idea - could
Core Administration Permissions
help here?
r
That is a good idea @Richard Pokorny, thanks. I'll check that out. I forgot they added that option.
🙌 1
FYI for all, checking the Core Admin box does grant the access to other people's response files. It also grants some excessive reporting permissions that I'm not crazy about, but luckily the way our business flow works, most of the reporting in the system isn't that sensitive, so I think I can live with that. Thanks again @Richard Pokorny!
a
I would like to know how to access those response files once the required permissions are obtained. What did you figure out?
r
Oh I'm not in technical-land, I'm just going to the Job Status page in the UI>https://[your_account_number].app.netsuite.com/app/setup/upload/csv/csvstatus.nl?whence=. Then you click on the CSV Response link for any line and it downloads as if it were your own. where without the Core Admin box checked previously, I got a perms error any time I tried that.
👍 1
Presumably if you granted that access to some connection, you could do the equivalent through the API.
If you were asking about what to do on the role, you just check the box here
a
Thanks, I was asking about whether anyone know of an API that can do that.
r
AFAIR no API can't access the CSV page. Possibly an RPA-based solution that will log into NS as the user
👍 1