I can see also that for new images a "message.publish" action gets recorded, but I haven't yet gotten much further in investigating how the relation between these media and text content is being established.
Just wanted to leave you with a link to the Bulk Data API documentation which might also help you further this investigation: https://developer.khoros.com/khoroscommunitydevdocs/reference/bulk-data-api#export-reference
The examples of media uploads I found in my data so far are actually avatar uploads, so they are not tied to a message id. They will all land in the user's media album though which is what explains why they are registered as a "publish" event. I agree though that it is confusing that it's a "message.publish" event and not a "media.publish" event.
After further digging into the depths of the Bulk Data API it looks to me like there is indeed no event triggered that would help you establish the relationship between media and - if and where - it is being used within a conversation topic.
The message.publish events you found for media uploads seem to be triggered either during the avatar upload flow or on the post message page (e.g. while the message editor is opened and the "upload media" feature of the rich text editor is being used). But there is no event listed on bulk data event list that ties the media on post creation to the actual message.
An alternative to obtain which message(s) an image is being used in would be to use API v2 and a LiQL query like:
SELECT id FROM images WHERE messages.id ='187'Thanks Cladius for looking into this. Yeah, the only way I was able to establish the relationship was due to timestamp and action taken and check that across multiple users/posts/messages to validate it.
As I understand, since each media file is a message.publish event with its own unique and completely different message and conversation ids I don't think the LIQL query you wrote would be able to establish the one-one relationship because we would not know the message id in the images table.
Please let me know if I am missing something here.
