Skip to main content
Answer

File attachments to external system via API

  • September 21, 2023
  • 2 replies
  • 749 views

kyoung14
Varsity I
Forum|alt.badge.img

We are going to implement an external system for crew and equipment scheduling for road construction/repair jobs.  Project Quotes will be created in Acumatica and converted to Projects.  At this point project info will be sent to this external system via an API/web service - that is all fine.  The challenge is that they also need any file (.pdf, .jpg, .xlsx, etc.) that was attached/linked to the Project in Acumatica to also be sent to this external system where it will be linked to the project there.  Is this possible?  Has anyone ever done anything like that before?  Another requirement from the receiving  system is that the files be converted to Base64 for use with their web service.

I’m just curious to hear if anyone has done anything similar and to see what is even possible.

 

Best answer by dcomerford

You can use the Rest API to get records see Page 32. There example is to get files from the item but you can use it to get them from a Project. I have used it to get item images from items.

 

https://openuni.acumatica.com/wp-content/uploads/2017/08/I320_WebServicesDataRetrievalAdvanced_2022R1.pdf

2 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • Answer
  • September 21, 2023

You can use the Rest API to get records see Page 32. There example is to get files from the item but you can use it to get them from a Project. I have used it to get item images from items.

 

https://openuni.acumatica.com/wp-content/uploads/2017/08/I320_WebServicesDataRetrievalAdvanced_2022R1.pdf


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • September 22, 2023

@kyoung14  Additionally, here is the article with an example for your reference.

https://asiablog.acumatica.com/2018/01/attach-files-with-rest-api.html