Hello. Im trying to export Image to website by push notification but there is just image name exporting, how can i get image url?
Im using following 2 tables in inquiry
Thanks.
Best answer by brendan91
View original
Hi
I think you are trying to export the images. Try like below.
You can join the “PX.SM.UploadFileRevision” and “PX.Data.NoteDoc” tables and get the fileID. From the FileID, you can read the data from the UploadFileRevision table.
I’ve attached the GI to get the FileID, The Data will not load on the GI. You can programmatically read the data based on FileID and export the image
Hi
I think you are trying to export the images. Try like below.
You can join the “PX.SM.UploadFileRevision” and “PX.Data.NoteDoc” tables and get the fileID. From the FileID, you can read the data from the UploadFileRevision table.
I’ve attached the GI to get the FileID, The Data will not load on the GI. You can programmatically read the data based on FileID and export the image
Hi, thank you for the response. Cant I just get item image URL in inquiry?
Hi
I think you are trying to export the images. Try like below.
You can join the “PX.SM.UploadFileRevision” and “PX.Data.NoteDoc” tables and get the fileID. From the FileID, you can read the data from the UploadFileRevision table.
I’ve attached the GI to get the FileID, The Data will not load on the GI. You can programmatically read the data based on FileID and export the image
Hi, thank you for the response. Cant I just get item image URL in inquiry?
Hi
I dont think we can get on Generic Inquiry.
Userlevel 5
+1
Hi
I think you are trying to export the images. Try like below.
You can join the “PX.SM.UploadFileRevision” and “PX.Data.NoteDoc” tables and get the fileID. From the FileID, you can read the data from the UploadFileRevision table.
I’ve attached the GI to get the FileID, The Data will not load on the GI. You can programmatically read the data based on FileID and export the image
Hi, thank you for the response. Cant I just get item image URL in inquiry?
Hi
I dont think we can get on Generic Inquiry.
The image URL is just https://(your company).acumatica.com/Frames/GetFile.ashx?fileID= plus the file ID.
If you concatenate the above URL and the File ID you should be able to build the link
Thanks, ill try
Thanks, it worked for me.
Hello. I have some questions again.
Im using these tables, for stock push notifications, but when im changing main image in attributes push is not going to website
==================
When I upload new image to attributes it sends empty push to website
====================================
I cant find how to delete image from attribute. Is there such ability?
====================================
How can I determine the main and additional images in push notifications?
Thanks.
Please, someone
Hi
I’ve checked with the same table and am able to get the notification when insert/delete. Can you please confirm that you added the NoteDoc.fileID in the result grid?
Hi
I’ve checked with the same table and am able to get the notification when insert/delete. Can you please confirm that you added the NoteDoc.fileID in the result grid?
sure
I know this is an older thread but I was wondering what type of authentication is needed to fetch the image
https://acumaticaURL/Frames/GetFile.ashx?fileID=44e05c99-4b38-44b4-b3c9-959346bc0e8c
Can I use our oAuth token to fetch the image?
Hi
You can try with an oAuth token to fetch the images
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.