How to filter customer by Email in Acumatica API with Postman

Hello everybody,

I want to add few more words about Acumatica API usage.

Recently I was asked on how to find customer by email in Acumatica. And I was asked to provide example of Postman functionality. That wasn't easy task, first of all because I'm not very skilful in Postman, but after few more efforts I was able to deliver Postman url.

But first of all let's consider how to configure Acumatica.

Acumatica configuration.

First of all, you'll need to either use your own endpoint, or default. For learning sake I recommend you to use your own. Also add customers screen to it. First gif visualizes this process:

I want to add few comments on this visualtion. Object name, that I gave: Customers has meaning. Later on I will use it in forming request.

Also in this gif I didn't show clicking on Save button, but I hope it's understandable by default. Next step goes adding fields. Take a look on another gif:

As you can see, I added Customer ID and Customer name, and after that I've added information related to customer email. After that preparation of endpoint and Customers entity I can proceed with creation of postman requests. 

Postman preparation.

Next thing goes postman preparation. Before you can do anything, first step should be logging to Acumatica. Next screenshot shows how you can prepare your Postman for logging in ( keep in mind, that I blured some non important data ):

After you log in to Acumatica, you'll have a chance to get all users by email. For example you can send in postman something like this:

https://bin.com:555/ticaERP/entity/TestC/17.200.001/Customers?$filter=Email eq 'vish@labs.com' and you will get necessary customers by email.

No Comments

Add a Comment