[BUG] [SP-API] [Issue] Data Kiosk SKU Economics dataset query authorization issues remained after the public release (403)

[Felix-singular]

I'm submitting a...

[ ] Regression (a behavior that used to work and stopped working in a new release) [x] Bug report
[ ] Feature request [ ] Documentation issue or request [ ] Other... Please describe:

SP-API Name and Version or Report/Feed Type

Data Kiosk 2023-11-15 createQuery POST /dataKiosk/2023-11-15/queries

Expected Behavior

Query gets created and report document will start generating

Current Behavior

Returns 403 unauthorized even though the very same data is accessible and retrievable from other Selling Partner APIs including the old Reports API thus this response makes no sense.

Context/Screenshots

I'm just trying to retrieve the report. Every single one of the other APIs and even all other Data Kiosk dataset queries work as expected.

Request:

{
    "query": "query SalesBase{analytics_economics_2024_03_15{economics(endDate:\"2024-04-29\" marketplaceIds:[\"A1PA6795UKMFR9\"]aggregateBy:{date:DAY,productId:MSKU}startDate:\"2024-02-29\"){childAsin netProceeds{perUnit{amount currencyCode}total{amount currencyCode}}parentAsin startDate endDate marketplaceId msku sales{unitsRefunded unitsOrdered refundedProductSales{amount}orderedProductSales{amount}netUnitsSold netProductSales{amount}averageSellingPrice{amount}}fees{feeTypeName charge{aggregatedDetail{quantity amount{amount}amountPerUnit{amount}promotionAmount{amount}taxAmount{amount}totalAmount{amount}}components{name aggregatedDetail{taxAmount{amount}amount{amount}amountPerUnit{amount}promotionAmount{amount}quantity totalAmount{amount}}}}}}}}"
}

Response:

{
  "errors": [
    {
      "code": "Unauthorized",
      "message": "Unauthorized to access requested fields.",
      "details": "Unauthorized to access: [analytics_economics_2024_03_15.economics.endDate, analytics_economics_2024_03_15.economics.netProceeds.total.currencyCode, analytics_economics_2024_03_15.economics.sales.unitsRefunded, analytics_economics_2024_03_15.economics.sales.averageSellingPrice.amount, analytics_economics_2024_03_15.economics.sales.refundedProductSales.amount, analytics_economics_2024_03_15.economics.fees.charge.components.aggregatedDetail.quantity, analytics_economics_2024_03_15.economics.sales.netUnitsSold, analytics_economics_2024_03_15.economics.marketplaceId, analytics_economics_2024_03_15.economics.fees.charge.components.aggregatedDetail.totalAmount.amount, analytics_economics_2024_03_15.economics.fees.charge.aggregatedDetail.totalAmount.amount, analytics_economics_2024_03_15.economics.fees.feeTypeName, analytics_economics_2024_03_15.economics.fees.charge.components.aggregatedDetail.amountPerUnit.amount, analytics_economics_2024_03_15.economics.fees.charge.aggregatedDetail.promotionAmount.amount, analytics_economics_2024_03_15.economics.sales.orderedProductSales.amount, analytics_economics_2024_03_15.economics.fees.charge.aggregatedDetail.taxAmount.amount, analytics_economics_2024_03_15.economics.fees.charge.components.name, analytics_economics_2024_03_15.economics.fees.charge.components.aggregatedDetail.amount.amount, analytics_economics_2024_03_15.economics.netProceeds.perUnit.amount, analytics_economics_2024_03_15.economics.fees.charge.components.aggregatedDetail.taxAmount.amount, analytics_economics_2024_03_15.economics.childAsin, analytics_economics_2024_03_15.economics.sales.unitsOrdered, analytics_economics_2024_03_15.economics.startDate, analytics_economics_2024_03_15.economics.netProceeds.perUnit.currencyCode, analytics_economics_2024_03_15.economics.msku, analytics_economics_2024_03_15.economics.fees.charge.aggregatedDetail.amount.amount, analytics_economics_2024_03_15.economics.sales.netProductSales.amount, analytics_economics_2024_03_15.economics.fees.charge.aggregatedDetail.quantity, analytics_economics_2024_03_15.economics.fees.charge.aggregatedDetail.amountPerUnit.amount, analytics_economics_2024_03_15.economics.fees.charge.components.aggregatedDetail.promotionAmount.amount, analytics_economics_2024_03_15.economics.netProceeds.total.amount, analytics_economics_2024_03_15.economics.parentAsin]"
    }
  ]
}

Your Environment

Happens in all environments

Ubuntu 22.04 LTS - Node 20.12 LTS Postman (in-browser) Mac OS Sonoma 14.3 - Node 20.12 LTS

[Javadebi]

I get the same error after rotating my LWA credentials.

[takeno-dev]

Can I use 'analytics_salesAndTraffic_2024_04_24' in Japan?

[mafge]

Hi @Felix-singular , thanks for reaching out! There was a known issue with the economics schema where it was not possible to create a query despite having all required roles. This issue is resolved by now - can you try again on your side? Best, Marc Selling Partner Developer Services

[Felix-singular]

Hi @mafge, Yeah, now the problem's been solved.