Skip to main content
Solved

Issue with Endpoint extension Key Fields

  • November 9, 2023
  • 5 replies
  • 106 views

Forum|alt.badge.img

Hi Community!!

I’m trying to fetch details of users for that I created a new Endpoint extension with name “AppUsers1”

I have added 5 fieds for it but Username was showing a warning.
 

as per the document I310 web services Tried ti fetch the data Using GET with Key Field Values
but I’m not sure which fields are Key Fields tried with Username but is not working.
 

POSTMAN Get call

How can I find the Key fields is there a standard way or does that differ?

Thank you in advance.

Best answer by Vignesh Ponnusamy

As @RohitRattan88  and @jinin mentioned, login fields seems to work. Map login field to endpoint, and use it directly the GET request(without ?$filter).

 

Request URL: <<Instance URL>>/entity/DefaultExt/22.200.001/AppUsers/AcumaticaSupport

 

5 replies

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

Hi @DineshJ,

The key field is usually the fields in the screen that we use to select a specific record. For example

  • Sales Order screen it would be composite key of OrderType and OrderNbr.
  • Project screen it would be ProjectID

In this scenario, I assume you are mapping the User(SM201010) screen. User screen, seem to be designed differently, maybe for security reasons. From my testing, I wasn’t able to fetch the data as required, pointing to the key field(like UserName, Guid). 

I suggest create a GI with required columns, map in to the endpoint and do GET request to fetch the required data. Good Luck.!


RohitRattan88
Acumatica Moderator
Forum|alt.badge.img+4
  • Acumatica Moderator
  • November 9, 2023

@DineshJ 

Please note that Login(Username) is the key field for this DAC is required for proper functioning of this web service entity:

In your Web Service extension, please make sure Login field is there(not the username you added). this field belongs to the User information section:

This should be sufficient for your endpoint to work properly:

Here’s an example call:

 

Cheers


jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • November 9, 2023

Hi  @DineshJ ,

 

Did you check with the login field?
 

 

 


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

As @RohitRattan88  and @jinin mentioned, login fields seems to work. Map login field to endpoint, and use it directly the GET request(without ?$filter).

 

Request URL: <<Instance URL>>/entity/DefaultExt/22.200.001/AppUsers/AcumaticaSupport

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • November 10, 2023

Thank you for the solution @RohitRattan88 @jinin @Vignesh Ponnusamy this works as expected.👍