GetDataReport always returns ReportNotAvailable

Question

question

Brent Batas (Lisk) asked Nov 14, '17

GetDataReport always returns ReportNotAvailable

I am trying to call GetDataReport, but I always receive ReportNotAvailable as a result.

My C# call looks like this:

var task = await PlayFabAdminAPI.GetDataReportAsync(new PlayFab.AdminModels.GetDataReportRequest()
{
    ReportName = "MonthlyOverviewReport",
    Day = DateTime.Now.Day,
    Month = DateTime.Now.Month,
    Year = DateTime.Now.Year,
});

I also tried using the ReportName = "PurchaseDataReport" which is in the example call in the documentation, but I receive the same result: ReportNotAvailable.

Additionally, it's unclear to me what the set of possible values are for ReportName. It lists various values in the documentation (https://api.playfab.com/documentation/admin/method/GetDataReport#request-properties) but these have spaces in them, while the example ReportName of "PurchaseDataReport" is not even in the list.

apis sdks

10 |1200

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

Answer 1 · 2017-11-14T00:29:00Z

brendan answered Nov 14, '17

It's all the reports you see on the reports tab (Analytics->Reports), and you can specify them using the names you see there, either with or without spaces (we strip spaces out in the call anyway). We'll update the docs to clarify this.

If you're getting a ReportNotAvailable error, that means the report you're asking for simply doesn't exist, though. What are the specifics of the values in your query, and what is the Title ID?

5

10 |1200

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

Brent Batas (Lisk) commented · Nov 14, 2017 at 12:40 AM

Thanks - it was definitely not clear to me that it corresponded with the Analytics->Reports reports - that clarifies things greatly.

I was able to figure out the original problem in the question; however, while you're updating the docs, I noticed that in the docs it says we'll receive a JSON file while in the actual SDK call, I receive a csv file instead.

0 ·

brendan Brent Batas (Lisk) commented · Nov 14, 2017 at 12:42 AM

Yes, I'll make sure that's highlighted, but that wouldn't cause the ReportNotAvailable error. What did you find was causing that issue?

0 ·

Brent Batas (Lisk) brendan commented · Nov 14, 2017 at 12:44 AM

I was simply requesting reports that didn't exist - I was requesting a monthly report for a non-first Day.

0 ·

Brent Batas (Lisk) commented · Nov 14, 2017 at 12:47 AM

I am also a bit confused on how to parse the CSV file.

var task = BackendApi.GetDataReport("Monthly Totals Report", 1, DateTime.Now.Month - 1, DateTime.Now.Year, (error) =>
{
}).Result;

string url = task.DownloadUrl;
DeveloperApi.LogSuccess("Successfully got data report with url: " + url);

using (WebClient client = new WebClient())
{
    client.Encoding = Encoding.UTF8;

    string raw = client.DownloadString(url);

    DeveloperApi.Log("Got raw: " + raw);
}

I am receiving some garbled text when I print out "raw"; something like:

�@ ��,��xT��Xj�Biu�U|{�XP_&!3)�[��

What am I doing wrong?

0 ·

brendan Brent Batas (Lisk) commented · Nov 14, 2017 at 02:21 AM

The reports are stored compressed (gzip), so you'd need to download them and decompress them first - we automatically do that when you click to download them in the Game Manager.

1 ·

question