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

[syeggidi]

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:

• I have verified that I am using the correct API key and credentials.
• I am authenticated properly for other AEP services, as suggested at https://experienceleague.adobe.com/en/docs/experience-platform/landing/platform-apis/api-authenticat...

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

[bjoern__koth]

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.

[Parvesh_Parmar · Accepted solution]

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