question

sreepunnoli avatar image
sreepunnoli asked

Is it possible to query the catalog items and similar internal data using KQL (or any SQL) for LiveOps?

I have been trying to query the catalog items and currency using a KQL in the data explorer. I can only see the events inside the data explorer. I know that there are REST API endpoints to get the data. Is it possible to query the catalog items and similar internal data using KQL (or any SQL)?

Player DataIn-Game Economydata
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Rick Chen avatar image
Rick Chen answered

In PlayFab, the events.all table is the default destination for all incoming events and you can only do the KQL on that table. If you want to be able to do the KQL on the Catalog, you can create your own table and store the Catalog data in that table. For more detail about creating table and do the data ingestion, you can refer to the following documents:

Performance and retention - PlayFab | Microsoft Docs

Insights Management Commands - PlayFab | Microsoft Docs

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.