Skip to main content
Solved

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

  • Sep 28, 2022 7:23 AM UTC
  • 2 replies
  • 164 views
  • Translate All
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

View original

2 replies

Fernando Amadoz
Jr Varsity I
Forum|alt.badge.img+2

@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

Translate
    Freshman II
    • farhanshaik
    • Author
    • Freshman II
    • Sep 30, 2022 8:02 AM UTC

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

    Translate
      Terms & ConditionsAccessibility 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