Video metadata wrong

Unknown

We've uploaded some videos into the database, but now I see that Xano is returning text/html for the mime type in the metadata.

You can see the problem at this public endpoint:

https://xim9-gixc-hpns.n7.xano.io/api:55wqYSaL/public/reviews

Any idea what's going on? How can we fix this metadata?

Thanks!

Jonathan ┄ video: {
id: 677,
created_at: 1649626864590,
reviews_id: 675,
users_id: 106,
views: 68,
youtube: ,
video: {
path: /vault/7TpgOkuG/NNfQ7cOvsZfXtSwK5QH12aXKEJY/mMHLfw../D94A7967-6B36-4356-AF00-4B52255589FA.mov,
name: D94A7967-6B36-4356-AF00-4B52255589FA.mov,
type: video,
size: 37134883,
mime: text/html; charset=UTF-8,
meta: {
audio: {
freq: 48000,
codec: aac (LC) (mp4a / 0x6134706D),
bitrate: 126000},
video: {
dar: false,
fps: 29.98,
par: false,
res: 1080x1920,
codec: h264 (High) (avc1 / 0x31637661),
bitrate: 6388000,
profile: yuv420p(tv,
postWidth: 1080,
postHeight: 1920},
duration: 45.57},
url: https://xim9-gixc-hpns.n7.xano.io/vault/7TpgOkuG/NNfQ7cOvsZfXtSwK5QH12aXKEJY/mMHLfw../D94A7967-6B36-4356-AF00-4B52255589FA.mov},
cover: {
path: /vault/7TpgOkuG/RsCLK_R6rGxAfLZZcuIGs3DgVIA/Bbre6Q../D94A7967-6B36-4356-AF00-4B52255589FA.jpg,
name: D94A7967-6B36-4356-AF00-4B52255589FA.jpg,
type: image,
size: 1856512,
mime: image/jpeg,
meta: {
width: 1080,
height: 1920},
url: https://xim9-gixc-hpns.n7.xano.io/vault/7TpgOkuG/RsCLK_R6rGxAfLZZcuIGs3DgVIA/Bbre6Q../D94A7967-6B36-4356-AF00-4B52255589FA.jpg},
photos: []},

Sean Montgomery

 

I went ahead and fixed this for you. Let me know if you run into any more issues.

Unknown

 Hmm, I don't see any change. Did you fix this for just one video or for everything? Do I need to do anything for the fix to apply?

Sean Montgomery

 the mime type is now correct for all of your mov files. You don't need to do anything.

Try clicking on the link in your original post. The video downloads properly.

Unknown

Yup, I see that! Thanks!

The reason I'm asking is that the metadata in the /public/reviews endpoint is still wrong, even though the server is treating the file correctly:
{"path":"/vault/7TpgOkuG/NNfQ7cOvsZfXtSwK5QH12aXKEJY/mMHLfw../D94A7967-6B36-4356-AF00-4B52255589FA.mov","name":"D94A7967-6B36-4356-AF00-4B52255589FA.mov","type":"video","size":37134883,"mime":"text/html; charset=UTF-8","meta":{"audio":{"freq":48000,"codec":"aac (LC) (mp4a / 0x6134706D)","bitrate":126000},"video":{"dar":false,"fps":29.98,"par":false,"res":"1080x1920","codec":"h264 (High) (avc1 / 0x31637661)","bitrate":6388000,"profile":"yuv420p(tv","postWidth":1080,"postHeight":1920},"duration":45.57}Any idea why the video metadata is wrong? Also, will this be a problem going forward for new files?

Sean Montgomery

Ah - unless you are using that field, it will not be a problem. The actual download has the correct mime type.

We just added mov mime types to our build so in a few days, it will use the updated mime type of video/quicktime.

New files added before then, will be treated as binary - which is much better than html.

Unknown

Ahh, understood. Thanks greatly!