Solved

Add CreatedByID and ModifiedByID in CHECK web service endpoint

  • 2 November 2023
  • 3 replies
  • 47 views
B

I was working on with the "Get" method in Acumatica API, I successfully pull the records from the api however there is no userID of the creator and modifier.

Webservice Endpoints I tried to find the createdBy and ModifiedBy in the dropdown but there is none.

how to add the UserID of creator and modifier on the web service endpoint so that these fields will be parts of the Get response.

Thanks in Advance

icon

Best answer by Mike Gifford 3 November 2023, 18:15

View original

3 replies

RohitRattan88
Rank
Userlevel 7
Badge +4

@bunnyboy04 

I believe these system fields are not exposed via API for some(many) screens. 

As a workaround though, you could try adding an Unbound field to store these value and pull it in the API:

How to get stored value of custom field instead of displayed value in web service endpoint | Community (acumatica.com)

 

Hopefully it helps

Mike Gifford
Rank
Userlevel 4
Badge

Try referencing it through the custom parameter: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=a0444120-2e5d-41cd-8c65-0385210b0f8a

I have been able to access standard fields not in the endpoint this way in the past. Worth a shot.

J
Rank
Userlevel 2

I can confirm this should work using @Mike Gifford’s suggestion of the custom parameter.  For example to get the Created By and Last Modified By fields for a Vendor record, I’d perform a GET request to: https://{instance url}/entity/Default/20.200.001/Vendor/{vendor_acctID}?$custom=BAccount.CreatedByID, BAccount.LastModifiedByID

and within the body of the response find these fields within the “custom” element:

}
    ...,
    "custom": {
        "BAccount": {
            "CreatedByID": {
                "type": "CustomStringField",
                "value": "admin"
            },
            "LastModifiedByID": {
                "type": "CustomStringField",
                "value": "jturcotte"
            }
        }
    },
    ...
}

 

Reply


Terms & ConditionsCookie settings
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