question

David Li avatar image
David Li asked

Exporting Custom Events to Google Sheet

I have a custom event "lobby_search" with the following properties as a json. How do I export all "Lobby_Search" to Google Sheet as a datatable; the Sub-Properties are each a column

JSON

{
  "PlayFabEnvironment": {
    "Application": "mainservercloudscriptint",
    "Vertical": "master",
    "Commit": "4781025",
    "Cloud": "main"
  },
  "EventNamespace": "title.8E611",
  "EntityType": "player",
  "SourceType": "GameServer",
  "Timestamp": "2020-09-30T02:10:15.0024393Z",
  "EventName": "lobby_join",
  "EntityId": "BA65C2F3319A9776",
  "EventId": "7974efc5d3ab4d40a116778464d3cbe2",
  "TitleId": "8E611",
  "Source": "8E611",
  "Username": "Ken",
  "GameType": "1v1",
  "Region": "us-east-2"

}

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
Sarah Zhang avatar image
Sarah Zhang answered

You can search “JSON to CSV Convert” in the Google search engine to find an external tool to convert your JSON file to a CSV file. CSV files can be directly imported to Google Sheets or Excel.

If you are using PlayFab Explorer, it provides a built-in feature to export your table as a CSV file. You can navigate to [Game Manager]->[Data]->[Explorer(Preview)], click the [File] button in the upper right corner. Then chose the [Export to CSV] in the drop-down menu.


snipaste-2020-10-01-14-46-51.png (11.9 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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.