Get Generic Inquiry Results via REST API in Excel Format (Binary Data)

Question

Acumatica version 25R2. I’ve successfully deployed and consumed generic inquiries with parameters via OData. For a specific generic inquiry, I would like to return the result in Excel format for direct opening or download, rather than returning the data in json format. I do not want the calling application to have to convert the data. I’ve been going round and round with Claude AI on a low-code customization solution, but it can’t figure out how to do it in one shot. It wants to trigger an export and file save to the file system then return a reference to the file which requires another API call to download the file. Has anyone been able to perform this type of action with a generic inquiry in one API call? It’s hard to believe that this is so difficult when I can do it with very little code in a web service method in a very old SAP system. Thanks.

Best answer by Dmitrii Naumov

@bbohn there is no support for this and that’s the first time I see this request. You can try creating an idea here and if it gets any traction we’ll consider implementation of it in the product.

Dmitrii Naumov · Accepted Answer

​@bbohnthere is no support for this and that’s the first time I see this request. You can try creating an idea here and if it gets any traction we’ll consider implementation of it in the product.

bbohn · Answer

​@bbohnthere is no support for this and that’s the first time I see this request. You can try creating an idea here and if it gets any traction we’ll consider implementation of it in the product.Thanks for the response. It’s probably not worth an idea request; I was just curious if I was missing something. I exposed the GI via OData, and we’ll just use SheetJS (or someother method) to convert the JSON response to an Excel file after the call.

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded