Query API worked in UAT, 403 in Production
We're currently migrating from an on premises instance of FE7 to FE NXT. In the process we were given access to an UAT environment. I built a process that retrieves information from AR using the Query API.
This process is working in the UAT environment, but failing in the production environment. In the production environment I'm receiving responses that are zero bytes long with a 403 status code. The failed request show up on the SKY API Analytics page as “Blocked requests”.
I notice that AR is available in web view in our UAT environment but not in the production environment. Could it be that our production environment is an older version of FE NXT in which the Query API is not fully available?
I think I've gone through all of the necessary steps to connect and authorize my SKI API application to the production environment. Is there something else I should look for?
Comments
-
@Aaron Spike You likely need your system admin to add rights for you for AR. One of those rights should be access to query:
0 -
@Erik Leaver I’m the admin. Can you tell me how to find this screen?
0 -
@Aaron Spike Should be under Control Panel → Security → Role Management → AR Roles
0 -
@Erik Leaver, here's what we see in our UAT environment:
And here's what we see in production:
The list of available roles is quite different. Is there something that we need to change at a higher level?
0 -
@Aaron Spike Images are broken :-(. I'd reach out to your implementation team and ask why the permissions are different between the two environments. I'd guess your user account doesn't have the same permissions enabled in prod that are currently enabled in test.
0 -
@Erik Leaver, Thanks! We have reached out but haven't heard back yet.
0 -
@Erik Leaver The implementation team “pushed modern permissions” and this solved the issue. Thanks!
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 206 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 357 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 561 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.6K SKY Developer
- 242 ResearchPoint™
- 117 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 777 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

