How to get count of records while executing any webservice within Acumatica while executing API in postman

Question

Hi Experts,I am currently working on integrating with Acumatica and I have encountered a situation where I need to retrieve the count of records while executing an API from Postman.I have a few questions regarding this:	Is there a solution to obtain the count of records in Acumatica through the API?			What is the purpose of the "$expand" key? Is there an alternative way to import all inner nodes without explicitly specifying them using the "$expand" parameter?			How can I determine the "Data Type" of a field when retrieving the schema of an object within the Acumatica system from Postman?	I would greatly appreciate your assistance.

sweta68 · Accepted Answer

Hi @sagar07,No, I believe currently it is not possible to obtain the count of records in Acumatica through the API.There is no alternative way to import all inner nodes without explicitly specifying them using the "$expand" parameter.You can retrieve the schema of an entity using the "$adHocSchema" parameter in the API request. The response will include the schema information, including the data type of each field. This allows you to determine the data type of a field when retrieving the schema of an object in Acumatica through the API.Hope, it helps!Regards,Sweta

bhitterdal75 · Answer

sagar07 - Not sure on the count, but for REST testing with Postman I find it easiest to first do a GET query then use the results of that in a PUT query editing a few fields like Created Date/Time fields as needed.

With Invoices if you use Expand on details that will give you the lines for the invoice and you can import the header and lines with one PUT:

Invoice/449cd1e0-fd7a-ec11-8f9b-000d3a9689c0/?$expand=Details

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded