Skip to main content
Solved

New to API Endpoint - How to Expand a detailed section linked to a detail section above

  • May 14, 2025
  • 1 reply
  • 88 views

Forum|alt.badge.img+1

Hello, I'm new to API development and I need help with a specific query. In my current project, I can successfully retrieve all employees from the top list using $expand=Employees.

My goal is to get the results from the bottom section (Overrides) which are linked to specific employees. In the UI form, when I click on Employee #1, the bottom window changes to show their specific overrides, and similarly for Employee #0.

I've tried using $expand=Employees/EmployeesOverrides, but this returns Employee #0's overrides for Employee #1, which doesn't make sense.

How can I properly query the API to get the correct overrides for each specific employee? I need to establish the proper parent-child relationship between each employee and their corresponding overrides.

I've attached screenshots showing the UI interface and the API endpoint configuration for reference. Any guidance would be greatly appreciated!

employee 0 overrides
employee 1 overrides

 

Best answer by Vignesh Ponnusamy

Hi ​@raphrf,

From my testing, seems like a bug. Kindly create support case with necessary the information(steps to reproduce, error, etc).

For now, to workaround the issue, you can create a GI(that retrieves the Employee Overrides based on the ProjectID and EmployeeID) and then map the GI to the endpoint to access these information through the API. Please feel free to post back if you have any questions. Thanks.!

1 reply

Vignesh Ponnusamy
Acumatica Moderator
Forum|alt.badge.img+5

Hi ​@raphrf,

From my testing, seems like a bug. Kindly create support case with necessary the information(steps to reproduce, error, etc).

For now, to workaround the issue, you can create a GI(that retrieves the Employee Overrides based on the ProjectID and EmployeeID) and then map the GI to the endpoint to access these information through the API. Please feel free to post back if you have any questions. Thanks.!