Unable to use shopifyqlQuery GraphQL API

Authentication & Access
1

Hello community,

I’m trying to use shopifyqlQuery query from GraphQL Admin API, but I’m unable to use it because currently I don’t have the “Level 2 access to customer data”.

The query I’m trying to run is:

FROM sales SHOW total_sales, orders, net_items_sold WHERE product_id IN (${product_ids}) SINCE -30d UNTIL today COMPARE TO previous_period

As you can see from above, I’m not touching any customer data.

And I understand that I need Level 2 access, even if I don’t need customer data, as from this answer in different post:

So I submitted request for protected customer data access, and when submitting I selected name, email, phone, and address from protected customer fields, stating that I need level 2 access for using shopifyqlQuery API and I’m not actually using those fields.

Then I got only approved for Level 1 access, so I submitted the request again but now I got my Level 1 access revoked. There was no explanation about why it wasn’t approved in emails.

I tried to contact support, but they suggested resubmitting the request with reasons specified, which I already did and got rejected.

I’m not sure what I’m supposed to do in current situation. So I wanted to ask community if someone managed to get Level 2 access even they don’t need protected customer data, just like in my case, and how they got approved.

1 Like
3

Hey @xhdtlsid2, am I right to assume this a new feature you are adding to your app but not yet implemented? If so, did you mention this in your PCD request? If our review team doesn’t see these scopes being used in your app or doesn’t have the necessary context to know why they are needed then it will be rejected.

What I would recommend in this case is to re-submit one more time.

Go into the form and add additional context that this is a feature that your are building out:

  1. Select “Other” on any of the PCD fields
  2. Add the details that this is a future feature
  3. Click “Save”
4

My request was approved on the fourth submission, after going through the review process including a screencast.

1 Like