SuiteScript Service get Database Info when User Not Logged In?

Question

Can a SuiteScript Service grab information from the NetSuite database and return it as JSON to a user who is not logged into the website/NetSuite?

For example; if a user accesses http://website.com/sca-dev-montblanc/services/upcomingCourses.Service.ss the service should grab a list of upcoming courses from the NetSuite database and send it back as JSON.

I have implemented a SCA module with 1 SuiteScript Service file that does this but when the user is not logged in I get the response:

{"errorStatusCode":"403","errorCode":"ERR_INSUFFICIENT_PERMISSIONS","errorMessage":"Insufficient permissions"}

I have determined that the problem results from the nlapiLoadRecord('customrecord_course', 1); line in my service. When I comment this out and just send back dummy JSON everything works. So looks like a database access permissions problem. Is there anyway to allow access to this info without having the user logged in? Maybe I can change table permissions? Or if I make the service part of another application? Any advice would be extremely helpful.

    /*exported service*/
function service (request)
{
    'use strict';

    var Application = require('Application');

    try
    {
        var method = request.getMethod();


        switch (method)
        {
            case 'GET':

                // Below line of code causes error 
                var firstCource = nlapiLoadRecord('customrecord_course', 1);

                var coursesTest = [
                    {
                        course_id: record.getFieldValue('id'),
                        course_name: record.getFieldValue('name')
                    }
                ];

                Application.sendContent(coursesTest);
            break;

            default:
                Application.sendError(methodNotAllowedError);
        }

    }
    catch (e)
    {
        Application.sendError(e);
    }
}

I also did so many thing In SCA let me know if you will required any help I will assist you — Anup Chaudhary, Mar 17 '17 at 20:07

score 3 · Accepted Answer · answered Feb 21 '17 at 22:20

3

Yes.

In your script deployment mark the script as available without login and select all roles for the audience.

In this instance you would generally use the external url for accessing the suitelet.

answered Feb 21 '17 at 22:20

bknights

14,408
2
18
31

Thanks. Does this also work if I am accessing a different table? For example right now I am accessing the table `customrecord_course`. If I try to access `customer`, `salesorder` or etc. will it still work? – sazr Feb 22 '17 at 00:11
1

Yes. If your script runs with administrator privilege it can access anything. – bknights Feb 22 '17 at 01:08
Right script should have admin access – Anup Chaudhary Mar 17 '17 at 20:06

SuiteScript Service get Database Info when User Not Logged In?

1 Answers1