Skip to main content
Solved

is there anyway to query an employee based on his email via restApi in acumatica

  • September 28, 2022
  • 2 replies
  • 127 views
F
Freshman II

i am trying to perform a lookup based on employee email to get the details.is there anyway to query an employee based on his email via restApi in acumatica

Best answer by Fernando Amadoz

@farhanshaik 

Try the following GET Request

http://[Instance]/entity/Default/20.200.001/Employee?$expand=ContactInfo&$filter=ContactInfo/Email eq 'jbecher@revisiontwo.com'

Keep in mind that the system does not restrict the definition of the same email account in multiple Employees, which may lead you to a multiplicity of records in the response

2 replies

Fernando Amadoz
Jr Varsity I
Forum|alt.badge.img+2
  • Fernando Amadoz
  • Jr Varsity I
  • Answer
  • September 28, 2022

@farhanshaik 

Try the following GET Request

http://[Instance]/entity/Default/20.200.001/Employee?$expand=ContactInfo&$filter=ContactInfo/Email eq 'jbecher@revisiontwo.com'

Keep in mind that the system does not restrict the definition of the same email account in multiple Employees, which may lead you to a multiplicity of records in the response

Dmitrii Naumov
jinin
szur
F
Freshman II
  • farhanshaik
  • Author
  • Freshman II
  • September 30, 2022

Thanks for replying back @Fernando Amadoz ,it did worked for me

Fernando Amadoz
Terms & ConditionsCookie settingsAccessibility statement
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