error 403 when trying to call advanced list

Arthur Yao
Arthur Yao
Name Dropper Participant Facilitator 1 Loyalty Badge
in SKY Developer General Discussions

Hello everyone,

I’d be greatly appreciated if someone can shed some lights on my problem here:

I’m trying to create a Google app script that pulls data from advanced list to a Google sheet. I’ve pass the authorization step and confirmed the token works, but got a 403 error when I’m trying to pull the list. It says:

Exception: Request failed for https://api.sky.blackbaud.com returned code 403. Truncated server response: {"title":"Forbidden","status":403,"detail":"This application has insufficient scope to perform the operation. The access token used in this request... (use muteHttpExceptions option to examine full response)

It seems to be suggesting that something is wrong with the scope setup of this application but I’ve already granted full access in the setting. I’m the only one in our organization running SKY API and I’m a platform admin with highest access level, so I’m not sure where this error is coming from.

Any suggestions? Thanks.

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 bbcon 2025 Attendee Badge

    @Arthur Yao
    Can you show what your full request looks like?

    I have a feeling you are not talking about RE NXT SKY API, please confirm.

  • Arthur Yao
    Arthur Yao
    Name Dropper Participant Facilitator 1 Loyalty Badge

    Hi @Alex Wong, thanks so much for replying.

    No, I'm not referring to RE NXT SKY API, I'm trying to use data from BB EMS.

    the request looks like this in Google App Script:

    I used another function to return the access token first and it returns the correct value, and I did pass the authorization step. I'm now stuck on this step where I'm trying to pull the actual data from a certain list.

    Thanks again for getting back.

    function test() {

    let {response} = getList([{

    list: XXX,

    name: 'NAME'

    }]);

    let h = [...new Set(response.map(z=>Object.keys(z)).flat())];

    return h;

    }

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 bbcon 2025 Attendee Badge

    @Arthur Yao
    I don't use EMS so can't be of much help. Someone else with EMS API experience will need to chime in.

    Good luck

  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 bbcon 2025 Attendee Badge PowerUp Challenge: Product Update Briefing Feedback Task 3

    @Nick Marchese Maybe this is something you can help with?

  • Victoria Wong
    Victoria Wong
    Ninth Anniversary Kudos 2 Name Dropper Participant

    @Arthur Yao Can you tell me how many records are in the advanced list?

  • Arthur Yao
    Arthur Yao
    Name Dropper Participant Facilitator 1 Loyalty Badge

    Hello everyone,

    Thanks for all your replies! I think I've figured out the authentication issue. I need to approve the change of scope in the BB marketplace page after I make any changes to the scope of application, it needs to show as updated in the environment setting of the application, as stated in the “changing scope” section here.

    Really appreciate all your support!

Categories