Forum Discussion

CKummer's avatar
CKummer
Advisor
2 years ago

General problem in understanding API data

Hello wise people, 

I really hope someone can help me understanding what the data is telling me ;). We did an API call and received a lot of data. I'm now trying to understand the meaning of what is in the sheet. Whenever I think I have understood it, the next question appears. But honestly I'm not a data specialist. 

Ok here is one example: 

What I have understood: 

In the board (ID 20) is a thread (ID 153737) which received after 10.977.408 seconds) either a first reply or a first solution. Actually in the case it is a reply (not frist one) which has been marked as a solution. When this has happend it's not clear. So it could be the day after the reply has been posted ot weeks, right? I have verified it and the reply has been posted more than 4 month later. Thread started Nov. 2021 and the reply has been posted in march 2022. 

But why does that very old data appears now in that data sheet? 

Second question: 

What is counted here?

Posting_Count_Community (column AH): Does that refer to all posts within the community within a specific timeframe? If so, that would mean that we have received 779 posts/replies within six hours. That can't be true. 

The same with posts for the board with the ID 16. What are the numbers in column AJ standing for?

Please open my eyes ;). 

Regards

Christoph

Bulk Data API
  • StanGromer's avatar
    StanGromer
    Boss
    2 years ago

    For the first question - Could this be due to merging topics/posts or even a deleted one?  A year into using the bulk data API, this seems to be something that comes up a lot with our data. When something gets merged, deleted, archived - Data all gets a bit whacky.

    For the latter - I’m clueless there, and our reporting genius is out of town this week else I would ask him.