Skip to main content
Solved

Images in Push Notifications


Forum|alt.badge.img

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

jinin wrote:
skater4 wrote:
jinin wrote:

Hi @skater4 
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 @skater4 

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

View original
Did this topic help you find an answer to your question?

12 replies

jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • 701 replies
  • June 6, 2022

Hi @skater4 
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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 36 replies
  • June 6, 2022
jinin wrote:

Hi @skater4 
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?


jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • 701 replies
  • June 7, 2022
skater4 wrote:
jinin wrote:

Hi @skater4 
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 @skater4 

I dont think we can get on Generic Inquiry.​​​​​​​


brendan91
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 92 replies
  • Answer
  • June 7, 2022
jinin wrote:
skater4 wrote:
jinin wrote:

Hi @skater4 
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 @skater4 

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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 36 replies
  • June 7, 2022

Thanks, ill try


Forum|alt.badge.img
  • Author
  • Freshman II
  • 36 replies
  • June 8, 2022

Thanks, it worked for me.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 36 replies
  • June 14, 2022

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.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 36 replies
  • June 15, 2022

Please, someone


jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • 701 replies
  • June 15, 2022

Hi @skater4 

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? 

 


 


Forum|alt.badge.img
  • Author
  • Freshman II
  • 36 replies
  • June 15, 2022
jinin wrote:

Hi @skater4 

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

 


Forum|alt.badge.img
  • Jr Varsity II
  • 16 replies
  • November 28, 2022

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?


jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • 701 replies
  • November 29, 2022

Hi @eelliston 

You can try with an oAuth token to fetch the images


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings