Error: "User is missing required permissions to use Query Service API" (403 Status Code) | Community
Skip to main content
October 7, 2024
Solved

Error: "User is missing required permissions to use Query Service API" (403 Status Code)

  • October 7, 2024
  • 2 replies
  • 950 views

I am encountering an issue when making a GET call to the following endpoint:

https://platform.adobe.io/data/foundation/query/query-templates/

I receive the following error response:

{ "message": "User is missing required permissions to use Query Service API", "statusCode": 403 }
Details:
  • API Call: GET
  • Endpoint: /data/foundation/query/query-templates/
  • Error: 403 Forbidden
  • Message: User is missing required permissions to use Query Service API.

Steps I have already tried:

Could you please assist in confirming the necessary permissions or point me toward a solution to resolve this issue? I would appreciate any guidance on how to check or update my permissions for the Query Service API in AEP.

 

Thank you for your assistance!

 

Best regards,
Sampath

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Parvesh_Parmar

Hello @syeggidi 

 

Just adding addition information shared by bjoern. 

 

1. For query server service you need these permissions: 

Query Service Packaging | Adobe Experience Platform

2. Now if you have Attribute-based access control  is enabled then you have to add this permission under API credentials of your user or roles. 

Attribute-based Access Control Manage Role Permissions | Adobe Experience Platform

 

 

Kr,

Parvesh

 

2 replies

bjoern__koth
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 7, 2024

Hi @syeggidi 

which permissions do you have? I think these might be needed.

Execute Data Exploration and Batch Queries: This permission allows users to execute SELECT, CTAS, and ITAS queries.
Manage Datasets: This permission provides read-only access for schemas and allows access to read, create, edit, and delete datasets for use with Query Service.

Cheers from Switzerland!
Parvesh_Parmar
Community Advisor
Parvesh_ParmarCommunity AdvisorAccepted solution
Community Advisor
October 7, 2024

Hello @syeggidi 

 

Just adding addition information shared by bjoern. 

 

1. For query server service you need these permissions: 

Query Service Packaging | Adobe Experience Platform

2. Now if you have Attribute-based access control  is enabled then you have to add this permission under API credentials of your user or roles. 

Attribute-based Access Control Manage Role Permissions | Adobe Experience Platform

 

 

Kr,

Parvesh

 

Parvesh Parmar – Adobe Community Advisor https://www.linkedin.com/in/parvesh-parmar/