Hi @ivanradisson, you are correct in that the
_uuid value is the culprit. Each time a submission is edited, a new
instanceID ) value is created and the old value becomes the
deprecatedID . You can see this if you view the XML of your submissions.
Btw, is this behavior ever going to change? I mean, are there any planned updates?
I’m asking because this creates some problems for people like me, using Power BI.
If someone edits a form submission, then it gets a different UUID, but the media is still accessible by a URL that is based on the original UUID. As such, because I’m dynamically forming an URL that is based on whatever the current UUID is, then the images no longer show up in Power BI as you can see in the screenshot below.
This is a table visual and I show some data as well as photos on each column:
The arrow points towards the images that are not loading correctly (because that specific form submission has been edited).
The other parts I had to censor, but I hope it’s still clear.
I guess my real question is:
With the update that was released in March 17th, is there anything I can use to overcome situations like the one I mentioned above? I connected to a new Kobo form just a couple of days ago and I still don’t see the full URL to the photos, anywhere in the data.
So as I said, my solution is to form the URL in a new column, in PowerBI.
This is how i generate the original image URL
https://kc.humanitarianresponse.info/media/original?media_file=pdul_admin/attachments/" & [#"formhub/uuid"] & "/" & [_uuid] & "/" & [#"group_photo1/input_photo1"]
This is how i generate the thumbnail URL
https://kc.humanitarianresponse.info/media/small?media_file=pdul_admin/attachments/" & [#"formhub/uuid"] & "/" & [_uuid] & "/" & [#"group_photo1/input_photo1"]
Note: group_photo1/input_photo1 is the name of the image field in Kobo.
With the exception of edited submissions, these URL work fine!
On those edited submissions, I have to manually replace values in the _UUID column. I replace the new ID by the old ID. And then my generated URLs work again. But obviously, this is not a good solution, only a temporary one.
Just noticed this column called “Attachments” and it seems it has a list of all the URL in there (original, small, medium sizes).
Now to expand on this…