Solved

Acumatica endpoint taking too long to return records

  • 17 January 2024
  • 5 replies
  • 124 views
Michael Ndungi
Rank
Userlevel 4
Badge

I have an external  mobile application which I I’m intergating with acumatica. I  I’m using a look up field where a user has to select from and can also input keywords to get the desired customer.

Below is the endpoint Im using;
https://XXX.acumatica.com/entity/Default/20.200.001/Customer
Number of customer in acumatica: 30,000

However it is taking around 15 min to get the customers and be diplayed on the selector for the end user to choose or in getting the desired result if the user is using a keyword.


How can I improve the speed of fetching to be in seconds and not this many minutes.
 

icon

Best answer by jinin 19 January 2024, 19:47

View original
Michael

5 replies

bryanb39
Rank
Userlevel 6
Badge +5

That's a lot of records to pull in each time.   Can you use a GI instead to reduce the amount of data or require entering at least 3 characters for example before sending the request so it's filtered?  

https://www.fiverr.com/acudatica
S
Rank
Userlevel 4
Badge

Hi @Michael Ndungi 

 

Depending on your needs, you could try using $select to limit the fields returned for each record.

 

For example, something like this should dramatically reduce the amount of data returned (and by extension, the time taken to process the request):

https://XXX.acumatica.com/entity/Default/20.200.001/Customer?$select=CustomerID,CustomerName

 

I’ve also heard that GI based OData feeds tend to run faster than the WS API.

Michael Ndungi
Rank
Userlevel 4
Badge

That's a lot of records to pull in each time.   Can you use a GI instead to reduce the amount of data or require entering at least 3 characters for example before sending the request so it's filtered?  

Thank you @bryanb39 

I used a GI to retrieve the records, the response time improved slightly, however, the user has to wait for like 2min to get the list of all customers and I’m only interested in only 6 fields.

could you please elaborate abit on the following statement?
“or require entering at least 3 characters for example before sending the request so it's filtered”

Michael
Michael Ndungi
Rank
Userlevel 4
Badge

Hi @Michael Ndungi 

 

Depending on your needs, you could try using $select to limit the fields returned for each record.

 

For example, something like this should dramatically reduce the amount of data returned (and by extension, the time taken to process the request):

https://XXX.acumatica.com/entity/Default/20.200.001/Customer?$select=CustomerID,CustomerName

 

I’ve also heard that GI based OData feeds tend to run faster than the WS API.

Thanks @stephenbologna39 

I I’m using $select to limit the fields to only 6. However, The time taken to return response is still too long.

Do you have an example or article I can reference on this?
“I’ve also heard that GI based OData feeds tend to run faster than the WS API.”

Michael
J
Rank
Userlevel 7
Badge +11

Hi @Michael Ndungi 

 

Depending on your needs, you could try using $select to limit the fields returned for each record.

 

For example, something like this should dramatically reduce the amount of data returned (and by extension, the time taken to process the request):

https://XXX.acumatica.com/entity/Default/20.200.001/Customer?$select=CustomerID,CustomerName

 

I’ve also heard that GI based OData feeds tend to run faster than the WS API.

Thanks @stephenbologna39 

I I’m using $select to limit the fields to only 6. However, The time taken to return response is still too long.

Do you have an example or article I can reference on this?
“I’ve also heard that GI based OData feeds tend to run faster than the WS API.”


Hi @Michael Ndungi 
Please refer to the article below regarding OData.
https://openuni.acumatica.com/wp-content/uploads/2017/08/I300-slides.pdf

Jini N

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved