Topic-Content export resources

Trigger Topic-Content export

Allows to trigger a topic-content export as txt/csv file containing a list of questions with topics. Questions are listed with solutions and solution authors. For questions with multiple solutions, each solution is exported in its own row, repeating the question for each entry (denormalized). Requires the Super Admin role.

POST /export/topic-content

Request body

{
    "topics": [
        {
            "global_concept_id": "20d73fa2-2be6-11ee-ba08-0282a30da65e",
            "label":  "Tag"
        },
        {
            "global_concept_id": "20d6ea13-2be6-11ee-ba08-0282a30da65e",
            "label": "Starmind"
        }
    ]
}

Response

The request will be returned, immediately. The export is running in the background.

{
    "count": null,
    "end_date": null,
    "export_id": 34,
    "file_size": null,
    "filename": "company-name_topic_content_export_20250404-093125.csv",
    "message": null,
    "start_date": "2025-04-04T09:31:25.000Z",
    "status": "processing",
    "user_id": 117
}

Available exports

Returns all topic-content exports for the network. A finished export is indicated with status: "success".

GET export/topic-content

Response

[
    {
        "count": 4,
        "end_date": "2025-04-01T09:09:59.000Z",
        "export_id": 27,
        "file_size": 4393,
        "filename": "company-name_topic_content_export_20250401-090959.csv",
        "message": null,
        "start_date": "2025-04-01T09:09:59.000Z",
        "status": "success",
        "user_id": 117
    },
    {
        "count": 66,
        "end_date": "2025-04-01T09:12:05.000Z",
        "export_id": 28,
        "file_size": 75832,
        "filename": "company-name_topic_content_export_20250401-091204.csv",
        "message": null,
        "start_date": "2025-04-01T09:12:04.000Z",
        "status": "success",
        "user_id": 117
    },
    {
        "count": 66,
        "end_date": "2025-04-01T09:36:29.000Z",
        "export_id": 29,
        "file_size": 73877,
        "filename": "company-name_topic_content_export_20250401-093622.csv",
        "message": null,
        "start_date": "2025-04-01T09:36:22.000Z",
        "status": "success",
        "user_id": 117
    }
]

Export

Returns a topic-content export by ID. Each export can have following states:

"success", "processing", "error".

If a topic-content export is in status "success", the file_size (bytes), count (number of exported rows) and end_date will be provided, additionally.

GET export/topic-content/:ID

Response

{
    "count": 73,
    "end_date": "2025-04-02T14:43:02.000Z",
    "export_id": 31,
    "file_size": 83285,
    "filename": "network_topic_content_export_20250402-144300.csv",
    "message": null,
    "start_date": "2025-04-02T14:43:00.000Z",
    "status": "success",
    "user_id": 117
}

Export download

Returns a csv file containing the topic-content export. Content-Type: txt/csv, Encoding: UTF-16LE, with the following columns:

question id, question published date, question title, question description, question views, topic ids, topic labels, solution count, solution author, solution description

Please note that fields are TAB separated. A question can match multiple topics. In that case the topic ids and labels are listed with a pipe | separator in the topic ids and topic labels column.

Datetime column question published date is formatted according to the pattern yyyy-MM-dd HH:mm:ss and are always in timezone UTC+00.

GET export/topic-content/:ID/file

Response

network_topic_content_export_20250404-084457.csv